Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: The Warm Up|
Important - Download These First - Working FilesPreview
About This SQL Advanced TitlePreview
Relational Databases And Key Terms ExplainedPreview
Recap Of SQL SELECT Command
Overview Of The Other DML Statements
How To Access Your Working Files
Installing The Sample Data And Using The Working Files
|Section 2: Useful Skills|
Creating A Temporary Table
The DISTINCT And TOP Keywords In Action
Indexing To Speed Up Your Life
Declaring And Using Variables
|Section 3: The Subquery|
What Is A Subquery?
Subquery Vs Joins
Using Correlated Subqueries
Using The EXISTS Keyword
Finding Duplicate Records
|Section 4: 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
|Section 5: 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
|Section 6: Functions|
Using Built In Functions
Creating And Using Your Own Functions (UDF)
|Section 7: Views|
Creating A View
Example Views And Views In Views
Using The UNION Clause
|Section 8: 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 - Part 1
Cursors In Use - Part 2
Use Of Transactions
|Section 9: Conclusions|
Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.
The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.