SQL Bootcamp 2

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

Past Locations for this Class

SQL Bootcamp 2

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

Past Locations for this Class

About this class

Empowering business and data analysts to expand their SQL tools for filtering, aggregating, and manipulating data as they create focused queries to retrieve information from multiple sources for timely and informative analysis.

Takeaways

We will be going over the following:

  • Complex Filtering and Aggregation
  • Applying SQL Specialty Functions
  • JOIN and UNION with Aliasing
  • Primary and Foreign Keys
  • Complex JOINs with multiple tables
  • Aggregating with GROUP BY and HAVING
  • Evaluating NULL values for business meaning
  • Applying SQL functions to NULLs
  • Building data value with CASE and COALESCE

Prereqs & Preparation

  • Understanding of SQL fundamentals including use of the following command line functions:
  • SELECT queries that include FROM, WHERE, ORDER BY.
  • Prior experience writing queries with at least one filter criteria.
  • General understanding of accessing remote/cloud databases.

Laptop, Mac or Windows, with system configuration within table below; Preload pgAdmin per instruction PDF. *We HIGHLY recommend taking the SQL Bootcamp prior to taking this next level class.

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.