Intermediate SQL Bootcamp

Washington, D.C. campuses

GA D.C. (Northern Virginia)
2231 Crystal Drive - 10th Floor
Arlington VA 22202

GA D.C., 1776
1133 15th Street NW, 8th Floor
Washington D.C. 20005

Intermediate SQL Bootcamp

Washington, D.C.

Washington, D.C. campuses

GA D.C. (Northern Virginia)
2231 Crystal Drive - 10th Floor
Arlington VA 22202

GA D.C., 1776
1133 15th Street NW, 8th Floor
Washington D.C. 20005

About this class

Enabling analysts to broaden their SQL skills to retrieve and manipulate data from multiple sources into timely, cohesive, informative analysis.

Takeaways

We will be going over the following: We will be going over the following:

  • JOIN and UNION with Aliasing
  • Primary and Foreign Keys
  • Aggregation and Functions
  • Complex JOINs with multiple tables
  • NULL values and related SQL functions
  • GROUP BY combined with HAVING
  • CASE and COALESCE
  • Nested Subqueries

Prereqs & Preparation

  • Understanding of SQL fundamentals including use of the following command line functions:
  • SELECT queries that include FROM, WHERE, ORDER BY, LIMIT.
  • Familiarity with using GROUP BY and HAVING in SELECT queries.
  • General understanding of accessing remote/cloud databases.

Laptop, Mac or Windows, with minimum of 8G (16G preferred) available memory and 200 MB available to download applications; Preload pgAdmin and PostgreSQL per instruction PDF. Instructions attached.

Coming up near you

Let’s Keep You Updated

Enter your email to start following

By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.