Buy and Download - Infinite Skills SQL Beyond The Basics Training Video

2015
Infinite Skills
Guy Vaccaro
4:15
English

In this SQL - Beyond the Basics training course, expert author Guy Vaccaro will dive deeper into SQL and covers advanced techniques. This course is designed for users that already have experience with SQL.
You will start by learning a variety of useful skills, including how to convert datatypes, create a temporary table, and declare and use variables. From there, Guy will teach you about sub queries, the CASE statement, and numbering and ranking. This video tutorial also covers using built in functions, creating and using your own functions, and creating views. Finally, you will learn about stored procedures, such as how to create and run a stored procedure, loop with WHILE and IF, and dynamically build SQL statements.
Once you have completed this computer based training course, you will have expanded your skills and be able to make more efficient use of SQL. Working files are included, allowing you to follow along with the author throughout the lessons.

01. The Warm Up
0101 About This SQL Advanced Title
0102 About The Author
0103 Relational Databases And Key Terms Explained
0104 Recap Of SQL SELECT Command
0105 Overview Of The Other DML Statements
0106 How To Access Your Working Files
0107 Installing The Sample Data And Using The Working Files
02. Useful Skills
0201 Converting Datatypes
0202 Creating A Temporary Table
0203 The DISTINCT And TOP Keywords In Action
0204 Indexing To Speed Up Your Life
0205 Declaring And Using Variables
03. The Subquery
0301 What Is A Subquery?
0302 Subquery Vs Joins
0303 Using Correlated Subqueries
0304 Using The EXISTS Keyword
0305 Finding Duplicate Records
04. The CASE Statement
0401 Getting Started With The CASE Statement
0402 Using The CASE Statement With Criteria On Multiple Columns
0403 Multiple Criteria Within The CASE Statement
0404 CASE In WHERE, ORDER BY, And GROUP BY Clauses
0405 CASE In UPDATE And INSERT Statements
0406 CASE Within Subqueries
05. Numbering And Ranking
0501 Numbering Or Ranking Records In A SELECT Statement
0502 Filtering Results Based On Numbering Ranking
0503 Using Numbering Within Groups
0504 Filtering A Ranked Group To Determine Top N
06. Functions
0601 Using Built In Functions
0602 Creating And Using Your Own Functions (UDF)
07. Views
0701 Creating A View
0702 Example Views And Views In Views
0703 Using The UNION Clause
08. Stored Procedures
0801 What Is A Stored Procedure?
0802 Creating A Stored Procedure
0803 Running A Stored Procedure
0804 Stored Procedures Within Stored Procedures
0805 The Global Variables @@Identity And @@Rowcount
0806 Looping With WHILE And IF
0807 Dynamically Build SQL Statements
0808 TRY And CATCH For Error Trapping
0809 Cursors In Use - Part 1
0810 Cursors In Use - Part 2
0811 Use Of Transactions
09. Conclusions
0901 Wrap Up