Intro
  • Intro to SQL a 101 Guide to Designing and Building Your First Database
  • Hit the High Def Button Please
  • Section 1 quiz
Lets Recreate a Database Like Udemy's Database
  • Lets Talk About Tables And How They Are Used In SQL
  • What Would This Database Need If We Were Recreating Udemy?
  • Person Table
  • Section 2 quiz
Keys Both Primary and Foreign
  • How to Create Keys In SQL And Why
  • Look What Keys Buy You
  • Section 3 quiz
Lets Fill In Our Datapoints
  • Adding Data To Your Database
THe Select
  • Select Statement In SQL
  • The Anatomy of the Select Statement in SQL
  • Select Exercises to Help You Learn SQL Faster
  • What Else Can You Do WIth The Select
  • Lets Talk About The Order By Clause In SQL
  • Where Clause Deep Dive
  • Lets Discuss The Like and the In Statements
  • Basic Database Analytics - Introducing Aggregate Functions
  • More Complex Analytics: Group By Clause
  • Section 5 quiz
Sub-queries
  • What Is A Subquery
  • Section 6 quiz
Course Slides and Material Up To Here
  • Course Slides and Material Up To Now
Joins
  • Inner Join
  • Left Outer Join
  • Section 8 quiz
User Defined Functions
  • Introduction to User Defined Functions
  • Scalar Functions
  • Scalar Functions SQL Statments
  • Table Functions
  • Table Functions SQL Statements
  • Section 9 quiz
The View
  • Lets Talk About Views
  • View SQL Statements
Stored Procedures The V8 of the SQL World
  • Our First Stored Procedure
  • Stored Proc SQL Statments
  • Section 11 quiz
Insert Update Delete The Fabulous 3
  • Insert Statements in SQL
  • Update Statements in SQL
  • SQL Delete Statement
  • SQL for this section
  • Section 12 quiz
Getting Real Deep In SQL
  • Adding Random Data To Play With
  • Statements for the Random Data
  • Adding More Random Data
Introducing the Pivot
  • Intro to Pivot and Unpivot
  • Our First Example Of A Pivot
  • Code For Pivot Lecture
  • Section 14 quiz
Trouble Shooting and Optimizing Your Database
  • A Intro To SQL Profiler
  • A How To On Optimizing Our Datbase
  • Adding Our First Indexes To Our Database
  • Create a Script to Index All Foreign Keys
  • Useful Queries For Building The Script To Index All Foreign Keys
  • Section 15 quiz
SQL Server Reporting Services (SSRS)
  • Installing SQL Report Builder 3.0
  • A Very Basic SSRS Report
Random Tips That Make Life Easier
  • How To Use Templates For Quick Access To SQL
  • Whole DB as Text File