Introduction
  • Introduction
  • Setup database
  • Practice what you learned in this section
Selecting data from multiple tables
  • Section introduction
  • INNER JOIN
  • SQL Alias
  • RIGHT OUTER JOIN
  • LEFT OUTER JOIN
  • FULL OUTER JOIN
  • Sub-queries
  • CASE
  • Practice what you learned in this section
Filtering data
  • Section introduction
  • TOP N
  • DISTINCT
  • IN and NOT IN
  • NULL and NOT NULL
  • LIKE
  • BETWEEN and NOT BETWEEN
  • Practice what you learned in this section
Aggregating data
  • Section introduction
  • GROUP BY
  • COUNT
  • SUM
  • MIN and MAX
  • HAVING
  • Practice what you learned in this section
Set operations
  • Section introduction
  • UNION and UNION ALL
  • INTERSECT
  • Practice what you learned in this section
Conclusion
  • Wrap up