Introduction
  • Introduction
  • Relational Databases and Tables
  • What Version of SQL Should I Use?
Day 1 - Write Your First Query
  • Learn how to use SELECT
  • Using Select #1
  • Using Select #2
  • Using Select #3
Day 2 - Filter You Query using WHERE
  • Filter Data using WHERE
  • Using WHERE
  • Using Comparison Operators
  • Using LIKE
  • Using BETWEEN in the WHERE clause
  • Using the IN comparison Operator
Day 3 - Ordering Results using ORDER BY
  • Sorting Data using ORDER BY
  • Using ORDER BY
  • Using ORDER BY with multiple fields
  • Getting the Top Items in a Query
Day 4 - Manipulating Data with INSERT, UPDATE, and DELETE
  • Modifying Data using INSERT, UPDATE, and DELETE
Day 5 - Grouping and Summarizing Query Results
  • Using GROUP BY to Summarize Your Results
  • Calculate Averages
  • Counting Rows
Day 6 - Using INNER JOIN to Combine Data from Multiple Tables
  • Using INNER JOIN with Two or More Tables
  • Learn to Write a INNER JOIN
  • Use a Join and Order the Results
  • Joining more than Two Tables
Day 7 - Write Subqueries
  • Write A Subquery to Calculate a Value
  • Using a Subquery in the SELECT statement
  • Using a Subquery in an Expression
Bonus
  • Bonus Lecture
  • Left and Right Outer Joins - From Join Together Now
  • Left and Right Outer Joins - Examples From Join Together Now