Let's get started
  • What is this FREE course about ? it's about SQL !
  • Download and install SQL 2014 Express
  • Introduction to the SQL Server management studio
  • What is a relational database ?
  • Pop quiz
SQL Foundation skills
  • Anatomy of a query
  • Where are the sample database and script files ?
  • The SELECT statement
  • Practice session with SELECT
  • The SELECT statement with a WHERE predicate
  • Practice session with SELECT with a WHERE predicate
  • The Group By clause
  • Practice session with Group By
  • A few tips about data types
  • Pop Quiz - Data types
Table joins, how they work
  • Where are the sample database and script files ?
  • Review the Chapter 3 database and model (PK/FK)
  • Brain Teaser
  • How to do an Inner Join
  • Prac time
  • How to do a Left Outer Join
  • How to do a Right Outer Join
  • How to do a Full Outer Join
  • Prac time
  • How to do a Cross Join
Transform data using aggregation functions
  • Where are the sample database and script files ?
  • Counting stuff using the Count() function
  • Prac Count()
  • Adding up using the Sum() function
  • Calculate the mean using the Avg() function
Bonus content to enhance your knowledge
  • What the heck is a UNION ?
  • How to insert data to a table
  • Importing raw data from non database files
  • Backup your database(s)
  • How to use the Case statement
  • Award based Course Certificates