SQL: From design to Mastery Class
BEST SELLER
38 Lectures
4h 54m 17s
Prepare for your examination with our training course. The course contains a complete batch of videos that will provide you with profound and thorough knowledge related to certification exam. Pass the test with flying colors.
$14.99
$19.49
Curriculum For This Course
-
1. Intro to SQL a 101 Guide to Designing and Building Your First Database5m 18s
-
1. Lets Talk About Tables And How They Are Used In SQL5m 57s
-
2. What Would This Database Need If We Were Recreating Stuff?7m 33s
-
3. Person Table15m 4s
-
1. How to Create Keys In SQL And Why10m 18s
-
2. Look What Keys Buy You1m 50s
-
1. Adding Data To Your Database11m 35s
-
1. Select Statement In SQL10m 13s
-
2. The Anatomy of the Select Statement in SQL3m 45s
-
3. Select Exercises to Help You Learn SQL Faster3m 50s
-
4. What Else Can You Do WIth The Select17m 5s
-
5. Lets Talk About The Order By Clause In SQL6m 54s
-
6. Where Clause Deep Dive7m 15s
-
7. Lets Discuss The Like and the In Statements8m 2s
-
8. Basic Database Analytics - Introducing Aggregate Functions11m 25s
-
9. More Complex Analytics: Group By Clause7m 48s
-
1. What Is A Subquery9m 27s
-
1. Inner Join15m 33s
-
2. Left Outer Join7m 27s
-
1. Introduction to User Defined Functions2m 6s
-
2. Scalar Functions10m 22s
-
3. Table Functions4m 52s
-
1. Lets Talk About Views5m 24s
-
1. Our First Stored Procedure6m 26s
-
1. Insert Statements in SQL7m 59s
-
2. Update Statements in SQL5m 47s
-
3. SQL Delete Statement6m 54s
-
1. Adding Random Data To Play With7m 56s
-
2. Adding More Random Data5m 26s
-
1. Intro to Pivot and Unpivot2m 21s
-
2. Our First Example Of A Pivot8m 9s
-
1. A Intro To SQL Profiler7m 25s
-
2. A How To On Optimizing Our Datbase4m 21s
-
3. Adding Our First Indexes To Our Database9m 40s
-
4. Create a Script to Index All Foreign Keys25m 41s
-
1. Installing SQL Report Builder 3.01m 52s
-
2. A Very Basic SSRS Report2m 44s
-
1. How To Use Templates For Quick Access To SQL2m 33s
