There is more to the course than just the videos

I will also include some additional content and services.

  • Example Database

    You're going to get a free example database with the course. This is a completely custom database built specifically for this course so the assignments will be specific.

  • SQL Syntax Cheatsheet

    You will also get provided with a cheat sheet to help save time when writing SQL code. This has some example syntax for some more advanced queries.

  • Assignments

    Each section will come with its own assignment. Then at the end of the course there is a final assignment to bring together all the things you learned. There is an option for you to send it in to me for feedback.

Course Curriculum

Check out what we will be learning

  1. 1
  2. 2

    • Basic SELECT

    • WHERE Clauses
  3. 3

    • What Are All The Things - Tables | Views | Stored Procedures

    • Syntax & Formatting
  4. 4

    • CREATE & DROP

    • ALTER
  5. 5

    • Basic UPDATE

    • UPDATE From SELECT
  6. 6

    • Basic INSERT

    • INSERT From SELECT
  7. 7

    • Basic DELETE & TRUNCATE

    • DELETE From SELECT
  8. 8

    • INNER JOIN

    • LEFT & RIGHT OUTER JOIN

    • Sub-Queries
  9. 9

    • GROUP BY

    • SUM & COUNT

    • AVG, MIN & MAX
  10. 10

    • CREATE & DROP

    • ALTER

    • Exporting Data
  11. 11

    • What Stored Procedures Are Used For

    • Variables

    • CREATE & ALTER Stored Procedures

    • TRANSACTION

    • CURSORS & LOOPS

    • Assignment Practise
  12. 12

    • Final Thoughts

    • Final Assignment Outline