Description

Curriculum For This Course

• 1. Intro 1 Videos 00:05:28

  • Intro to SQL a 101 Guide to Designing and Building Your First Database5:28

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

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

  • What Would This Database Need If We Were Recreating Stuff?7: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 You1: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 SQL3:45

  • Select Exercises to Help You Learn SQL Faster3:50

  • What Else Can You Do WIth The Select17:05

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

  • Where Clause Deep Dive7:15

  • Lets Discuss The Like and the In Statements8:02

  • Basic Database Analytics - Introducing Aggregate Functions11:25

  • More Complex Analytics: Group By Clause7:48

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

  • What Is A Subquery9:27

• 7. Joins 2 Videos 00:22:60

  • Inner Join15:33

  • Left Outer Join7:27

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

  • Introduction to User Defined Functions2:06

  • Scalar Functions10:22

  • Table Functions4:52

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

  • Lets Talk About Views5:24

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

  • Our First Stored Procedure6:26

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

  • Insert Statements in SQL7:59

  • Update Statements in SQL5:47

  • SQL Delete Statement6:54

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

  • Adding Random Data To Play With7:56

  • Adding More Random Data5:26

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

  • Intro to Pivot and Unpivot2:21

  • Our First Example Of A Pivot8:09

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

  • A Intro To SQL Profiler7:25

  • A How To On Optimizing Our Datbase4:21

  • Adding Our First Indexes To Our Database9: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.01:52

  • A Very Basic SSRS Report2:44

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

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