create and interact with SQL databases at an intermediate to advanced level
utilize subqueries, variables, custom functions and more
a working knowledge of SQL fundamentals
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.
Who this course is for:
students who have taken the introductory SQL course or who have a basic understanding of SQL
9 sections • 44 lectures • 4h 19m total length
The Warm Up7 lectures • 32min
Important - Download These First - Working Files
About This SQL Advanced Title
Relational Databases And Key Terms Explained
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
Useful Skills5 lectures • 34min
Creating A Temporary Table
The DISTINCT And TOP Keywords In Action
Indexing To Speed Up Your Life
Declaring And Using Variables
The Subquery5 lectures • 29min
What Is A Subquery?
Subquery Vs Joins
Using Correlated Subqueries
Using The EXISTS Keyword
Finding Duplicate Records
The CASE Statement6 lectures • 36min
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 Ranking4 lectures • 22min
Numbering Or Ranking Records In A SELECT Statement
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.