Intmd. SQL Bootcamp

Austin

Data

Austin Campus

GA Austin, WeWork Congress
600 Congress Avenue, 14th Floor
Austin TX 78701

Past Locations for this Class

Austin

Stay up to date

Follow this class to get an email the next time it’s scheduled.

Sign-up not required

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.