Intermediate SQL Bootcamp: How to Architect Complex Queries

Online Campus

Online
Anywhere
Online

Past Locations for this Workshop

Intermediate SQL Bootcamp: How to Architect Complex Queries | Online

Online Campus

Online
Anywhere
Online

Past Locations for this Workshop

About this workshop

The Empire Strikes Back, The Godfather Part II and The Dark Knight. What do these films all have in common? Well, they were just as good if not better than the original films they followed!

The much-anticipated sequel to our SQL Bootcamp; Intermediate SQL Bootcamp: How to Architect Complex Queries.

Our CAST of characters has expanded to CASE statements, Window functions, subqueries and CTEs. This course is a great opportunity to review Intro to SQL and also learn some new concepts that can be applied immediately in your current or future role! A more thorough description can be found below.

Topics Covered:

  • Review of Intro to SQL Concepts (SELECT, WHERE, FROM, JOIN, GROUP BY, ORDER BY) in an interactive group workshop
  • Creating conditional statements (CASE functions) that can be paired with aggregate functions (SUM, COUNT, MIN, MAX, etc.)
  • Using window functions (RANK, SUM() OVER) to create ranked lists with partitioning and grand totals in your SQL queries
  • Building and understanding the differences between a subquery and a common table expression; CTEs (WITH keyword)
  • Iron-clad framework to use when architecting multi-layered and complex queries

Prereqs & Preparation

A desire to review SQL and learn some new and highly practical syntax

Coming up near you

Let’s Keep You Updated

Enter your email to start following

I have read and acknowledge General Assembly's Privacy Policy and Terms of Service. SMS message and data rates may apply.