2-Day Intermediate SQL & Database Management Bootcamp

Online Campus

Online
Anywhere
Online

Past Locations for this Class Series

2-Day Intermediate SQL & Database Management Bootcamp | Online

Online Campus

Online
Anywhere
Online

Past Locations for this Class Series

About this class series

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

Prereqs & 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

Coming up near you

Let’s Keep You Updated

Enter your email to start following

I have read and acknowledge General Assembly's Privacy Policy and Terms of Service. SMS message and data rates may apply.