SQL Bootcamp 2 | Online
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.
