Certification training

SQL: From design to Mastery Class

Prepare for your exam with a structured video course built for focused study, topic review, and repeatable progress before exam day.

38Lectures
4h 54m 17sDuration
Vendor
SQL: From design to Mastery Class course cover Best seller
certification training 38 lessons arranged in a guided course path
Course overview

Study with a clear path.

Move through focused sections, review lecture timing, and return directly to the objectives that need more work.

Sequenced lessons

Follow the course in order or jump directly to the section you need to revisit.

Video-first prep

Use concise lecture blocks for technical review before moving into exam practice.

Fast access

Your purchased course becomes available in the member area after confirmed payment.

Curriculum

Course sections.

16 sections, 38 lessons, and lecture-level duration details.

01 Intro to SQL a 101 Guide to Designing and Building Your First Database 5m 18s

01 Lets Talk About Tables And How They Are Used In SQL 5m 57s
02 What Would This Database Need If We Were Recreating Stuff? 7m 33s
03 Person Table 15m 4s

01 How to Create Keys In SQL And Why 10m 18s
02 Look What Keys Buy You 1m 50s

01 Adding Data To Your Database 11m 35s

01 Select Statement In SQL 10m 13s
02 The Anatomy of the Select Statement in SQL 3m 45s
03 Select Exercises to Help You Learn SQL Faster 3m 50s
04 What Else Can You Do WIth The Select 17m 5s
05 Lets Talk About The Order By Clause In SQL 6m 54s
06 Where Clause Deep Dive 7m 15s
07 Lets Discuss The Like and the In Statements 8m 2s
08 Basic Database Analytics - Introducing Aggregate Functions 11m 25s
09 More Complex Analytics: Group By Clause 7m 48s

01 What Is A Subquery 9m 27s

01 Inner Join 15m 33s
02 Left Outer Join 7m 27s

01 Introduction to User Defined Functions 2m 6s
02 Scalar Functions 10m 22s
03 Table Functions 4m 52s

01 Lets Talk About Views 5m 24s

01 Our First Stored Procedure 6m 26s

01 Insert Statements in SQL 7m 59s
02 Update Statements in SQL 5m 47s
03 SQL Delete Statement 6m 54s

01 Adding Random Data To Play With 7m 56s
02 Adding More Random Data 5m 26s

01 Intro to Pivot and Unpivot 2m 21s
02 Our First Example Of A Pivot 8m 9s

01 A Intro To SQL Profiler 7m 25s
02 A How To On Optimizing Our Datbase 4m 21s
03 Adding Our First Indexes To Our Database 9m 40s
04 Create a Script to Index All Foreign Keys 25m 41s

01 Installing SQL Report Builder 3.0 1m 52s
02 A Very Basic SSRS Report 2m 44s

01 How To Use Templates For Quick Access To SQL 2m 33s
Continue preparing

Connect the lessons to exam-day practice.

Use the course for structured review, then move into current questions, timed simulator sessions, and a broader vendor catalog.

VTSimu exam simulatorRehearse pacing in focused desktop sessions.
Unlimited AccessBuild a practice library across vendors and formats.
More video coursesExplore every available certification training track.