Description

Curriculum For This Course

• 1. Intro 1 Videos 00:05:28

  • Intro to SQL a 101 Guide to Designing and Building Your First Database05:18

• 2. Lets Recreate a Database Like Udemy's Database 3 Videos 00:28:34

  • Lets Talk About Tables And How They Are Used In SQL05:57

  • What Would This Database Need If We Were Recreating Stuff?07:33

  • Person Table15:04

• 3. Keys Both Primary and Foreign 2 Videos 00:12:08

  • How to Create Keys In SQL And Why10:18

  • Look What Keys Buy You01:50

• 4. Lets Fill In Our Datapoints 1 Videos 00:11:35

  • Adding Data To Your Database11:35

• 5. THe Select 9 Videos 01:16:17

  • Select Statement In SQL10:13

  • The Anatomy of the Select Statement in SQL03:45

  • Select Exercises to Help You Learn SQL Faster03:50

  • What Else Can You Do WIth The Select17:05

  • Lets Talk About The Order By Clause In SQL06:54

  • Where Clause Deep Dive07:15

  • Lets Discuss The Like and the In Statements08:02

  • Basic Database Analytics - Introducing Aggregate Functions11:25

  • More Complex Analytics: Group By Clause07:48

• 6. Sub-queries 1 Videos 00:09:27

  • What Is A Subquery09:27

• 7. Joins 2 Videos 00:22:60

  • Inner Join15:33

  • Left Outer Join07:27

• 8. User Defined Functions 3 Videos 00:17:20

  • Introduction to User Defined Functions02:06

  • Scalar Functions10:22

  • Table Functions04:52

• 9. The View 1 Videos 00:05:24

  • Lets Talk About Views05:24

• 10. Stored Procedures The V8 of the SQL World 1 Videos 00:06:26

  • Our First Stored Procedure06:26

• 11. Insert Update Delete The Fabulous 3 3 Videos 00:20:40

  • Insert Statements in SQL07:59

  • Update Statements in SQL05:47

  • SQL Delete Statement06:54

• 12. Getting Real Deep In SQL 2 Videos 00:13:22

  • Adding Random Data To Play With07:56

  • Adding More Random Data05:26

• 13. Introducing the Pivot 2 Videos 00:10:30

  • Intro to Pivot and Unpivot02:21

  • Our First Example Of A Pivot08:09

• 14. Trouble Shooting and Optimizing Your Database 4 Videos 00:47:07

  • A Intro To SQL Profiler07:25

  • A How To On Optimizing Our Datbase04:21

  • Adding Our First Indexes To Our Database09:40

  • Create a Script to Index All Foreign Keys25:41

• 15. SQL Server Reporting Services (SSRS) 2 Videos 00:04:36

  • Installing SQL Report Builder 3.001:52

  • A Very Basic SSRS Report02:44

• 16. Random Tips That Make Life Easier 1 Videos 00:02:33

  • How To Use Templates For Quick Access To SQL02:33