30% OFF Marked Prices & FREE Shipping!   -   ENDS 5PM FRIDAY!   -   Use Discount Code 303

Beginners to Advanced SQL Tutorial

This discounted bundle includes:
Beginners SQL Tutorial
Duration: 4 Hours
Video lessons: 35

Advanced SQL Tutorial
Duration: 4.25 hours
Video lessons: 43
A professionally created, self-study video training course
Includes 8 hours of easy to follow Beginners to Advanced SQL video tutorials presented by an industry expert.
The training is delivered to your desktop allowing you to learn at a time that suits you and at your own pace.
You can start learning online right away. Sample Beginners to Advanced SQL tutorial videos by clicking a blue link below:
COMPLETE COURSE CONTENTS
We hope you enjoyed the free lessons. To view the complete contents, including all lessons below & above, please purchase the course via DVD or Download.
Paid Content
Section

Get all lessons with purchase
Contents from Beginners SQL
Using SQL To Select And Filter Data
Using Select To View Data
Sorting The Data
Adding A Where Clause To Filter Data
Filtering Date Columns
Working With Null Or Empty Values
Using Comments Within SQL
Use Of Wildcards In Filtering
Multiple Criteria Using And Or In

Functions, Grouping And Summarizing
Add A Calculating Column To A SQL Statement
Text Manipulation Functions
Differences In Date Functions Within SQL
Calculating Age
Concatenate Data Columns

Joining Tables
Which Tables Can I Join And How?
Joining More Than Two Tables - Lesson 1
Joining More Than Two Tables - Lesson 2
Using Different Join Types
The Special Cross Or Cartesian Join
Group And Summaries Within Joined Table SQL

Data Modification
Amend Data In Tables
Adding Data To Tables With Insert
Removing Data From Tables

Creating And Altering Database Objects
Create A New Table
Changing A Tables Structure
What Is A View And How To Create One
Alter Or Delete A View

SQL Summary
The Main Variances In SQL Between Databases
The Powerful Subquery

Conclusions
Wrap Up
Contents from the Advanced SQL
Useful Skills
Converting Datatypes
Creating A Temporary Table
The DISTINCT And TOP Keywords In Action
Indexing To Speed Up Your Life
Declaring And Using Variables

The Subquery
What Is A Subquery?
Subquery Vs Joins
Using Correlated Subqueries
Using The EXISTS Keyword
Finding Duplicate Records

The CASE Statement
Getting Started With The CASE Statement
Using The CASE Statement With Criteria On Multiple Columns
Multiple Criteria Within The CASE Statement
CASE In WHERE, ORDER BY, And GROUP BY Clauses
CASE In UPDATE And INSERT Statements
CASE Within Subqueries

Numbering And Ranking
Numbering Or Ranking Records In A SELECT Statement
Filtering Results Based On Numbering Ranking
Using Numbering Within Groups
Filtering A Ranked Group To Determine Top N

Functions
Using Built In Functions
Creating And Using Your Own Functions (UDF)

Views
Creating A View
Example Views And Views In Views
Using The UNION Clause

Stored Procedures
What Is A Stored Procedure?
Creating A Stored Procedure
Running A Stored Procedure
Stored Procedures Within Stored Procedures
The Global Variables @@Identity And @@Rowcount
Looping With WHILE And IF
Dynamically Build SQL Statements
TRY And CATCH For Error Trapping
Cursors In Use
Use Of Transactions

Conclusions
Wrap Up
  • Tutor: Guy Vaccaro
  • Duration: 8 hours
  • Video lessons: 78
  • Product code: 01915
  • In stock: YES
  • Available on: DVD & Download
  • Work files included: YES
  • Works on: MS Windows PC & Mac
  • Date Released: 28th January 2015
Gain an in-depth understanding of what SQL (Structured Query Language) is and how to correctly apply it to various database types with the help of these Advanced and Beginners SQL tutorial videos.

Commencing from the absolute basics, expert database tutor Guy Vaccaro uses step by step training videos to help explain and demonstrate exactly how to use SQL to manage your data that's contained in a relational database.

Throughout the course, Guy makes frequent reference to and uses SQL files that are included with the DVD and download purchase helping you to effortlessly follow along with his on-screen actions and verbal instruction.

Through over 8 hours of professionally created video training, the instruction starts with lessons on using SQL to select and filter data from a database, with details on sorting your data and working with null or empty values.
You will also learn SQL functions, how to join tables and various types of data modification including how to remove data from tables.
The course covers advanced techniques such as utilizing built in functions, how to create and use your own functions, and creating views step by step. Towards the conclusion of the tuition, Guy discusses all about creating and altering database objects with table structure explained in-depth.

The complete training course contents is listed below and you can start your SQL education right away. Click any of the blue linked lessons below to sample free SQL video tutorials and discover how effective this practical teaching guide is...
What Our Customers Are Saying

"We have purchased 11 of these training CDs to date. Their structure and content have improved our technical skills at our own pace. We've extracted ourselves from many a production problem by referring back to the relevant CD."Ian Walsh, Slide FX Ltd, Ireland
 
Purchase Info - 30% OFF MARKED PRICE!
The DVD and Download options include the same training contents and both priced as below:
PRICE
CURRENCY
   
 
Item(s):
   
Once purchased, you will receive 78 Beginners to Advanced SQL training videos (listed left), lasting a total of 8 hours and the working files.

Worldwide
Shipping
Delivery Details
Download Course downloadable when payment processed (within one hour average)

CD/DVDs No shipping charges. Please allow 2-3 days for UK, Europe, US & Canada. 3-5 days rest of world.
WE AIM TO PLEASE
All DVD courses have a 100% money back guarantee. If you are not happy with your course contact us within 30 days of purchase for a refund.
View our full product guarantee
|
Need to Train Multiple Users?
This Beginners to Advanced SQL course is available in multi-user format ideal for corporate users, schools and universities.

The course loads directly onto your server and delivered to multiple users over your network.

An unlimited number of users can access the training with a pre-determined number viewing the tuition at any one time.

Training Multiple Users

Load onto your server
Deliver on your network or existing learning management system


USING THE SAME EXCELLENT CONTENT AS SINGLE USER COURSES
For companies and educational establishments wanting multi user access to training resources, we offer this Beginners to Advanced SQL course to do just that.
Now you can integrate training or technical support within your own computer network, or allow employees or students to gain access to training and support from home or any other location that they can gain access to your organizations network.

EASILY VIEWED OVER A NETWORK
The courses can be played over a LAN using a standard browser such as Microsoft Internet Explorer, Safari or Firefox.
The movies are viewed using Adobe Flash (same method as YouTube) and are slightly compressed in order to not clog the network.
All advanced and the "for dummies" courses are available via this multi user solution and can be copied directly to a hard disk for faster access and the access page may be customized, if needed, using a html editor.

ADDITIONAL USERS AND TITLES CAN BE ADDED
More than one title can exist on your server and the supplied player will automatically show titles that are available.
Simply purchase more user licences (supplied as files) and drop them into the folder. This will automatically increase the number of users allowed onto the system. All purchases are backed up by excellent after-sales support team and easy to follow instruction manual.
You can order multi user online or speak to our knowledgeable sales team.
PRICE
(Per 10 user concurrent licence)
Closely Related Courses
We recommend the Oracle PL/SQL Tutorial
See our complete range of Oracle Tutorials
Prove Your Capabilities
Once a course is completed you can download a free certificate.

This certifies that you have started from the beginners level, have now viewed all instruction. The certificate advises you now possess essential skills and an in-depth knowledge of Beginners to Advanced SQL. Show your boss or potential employer!
Weekly Special
Promoted Course
View sample videos from the new
AutoCAD 2016
A recent customer speaks out...
"Thank you so much, this tutorial is incredible! I have never learned how to use a software package so fast and in such a fun way before, presenter Andy has a style and sense of humour that is bang on. thank you!"Tadgh Creed, Texas