You've gotten your feet wet with SQL - now it's time to move on to the next level.

Solve real-world problems and business questions with SQL
What this course is about:

After taking this course, you should be able to say you're "Good at SQL." If someone asks you to pull some data from a database, or to perform some analysis, or to review their SQL query, you should feel confident that you can get the job done. We will spend half the first class reviewing material from "Introduction to SQL" (since it's easy to get rusty), then move onto newer and better things.

None of these concepts matter unless we can solve real-world problems and business questions with them, so that is where we will spend the majority of our time.

Who this program is for:

To take this course, you MUST have taken "Introduction to SQL" or know the concepts that we covered extremely well. You must know SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, each type of JOIN, and finally aggregate functions. Otherwise this course will be a waste of time and money. Please email "alex@alexpetralia.com" if you have any doubts. Please do not bring those who haven't registered for the course - they will not be on the attendance list Class starts promptly at 6:30pm and ends at 8:00pm We do not cover data engineering in this course (it will be a separate workshop)

You will learn:
  1. Subqueries
  2. Views
  3. Temp tables
  4. Working with dates
  5. COALESCE
  6. CASE WHEN
  7. UNION
Prerequisites & Preparation:
  1. Laptop (Chrome browser)

Start Dates

Jan 31st Evening

$90

Course schedule:
Jan. 31, 2018, 6:30 p.m.
Feb. 7, 2018, 6:30 p.m.