2-Day Intermediate SQL & Database Management Bootcamp

This workshop will enable analysts to advance their SQL skills to retrieve and manipulate data from multiple sources with precision, integrate SQL queries with reporting tools to create automated reports and visualizations, and database management principles/best practices.

Takeaways
Database architecture and creation
Database management functions CREATE, INSERT, UPDATE, DROP, DELETE
NULL values and working with bad data
Complex JOINs with multiple tables and conditional JOINs
Common Table Expressions (CTE) and subqueries
Aggregation and GROUP BY combined with HAVING
Stored procedures and reporting tool integrations
Preparation
Understanding of SQL fundamentals including the use of the following command line functions
SELECT queries that include FROM, WHERE, ORDER BY, LIMIT
Basic understanding of table JOINs and UNIONs
Familiarity with using GROUP BY and HAVING in SELECT queries
General understanding of accessing remote/cloud databases and stored data formats
Laptop, Mac or Windows, with a minimum of 8G (16G preferred) available memory and 200 MB available to download applications
Preload pgAdmin
Instructor will walk you through how to download PostgreSQL