Intro to Advanced SQL Concepts | Los Angeles

About this workshop

Do you already use SQL on a regular basis to answer business questions, but are ready to take your skills to the next level? This 3 hour workshop will provide an introduction to advanced concepts in working with data in relational database management systems (RDBMS). Participants will learn to how to use advanced SQL techniques to work with data more efficiently and to complete advanced calculations. By the end of the workshop, you will be able to create window functions, stored procedures, and use views in SQL. This workshop is geared towards intermediate SQL users who want to master the use of the language for data analysis.

Takeaways

• General understanding of the following advanced concepts in SQL: - Window Functions, Text Searching, Stored Procedures/Functions, and Views
• Knowledge of advanced techniques in SQL for data analysis
• Resources for continued practice to master advanced SQL concepts

Prereqs & Preparation

• Laptop and the needed permissions to download and install postgreSQL and pgAdmin 4
• Should have familiarity with:
  • Laptop and the needed permissions to download and install postgreSQL and pgAdmin 4
• Should have familiarity with:
  • Complex JOINs with multiple tables and aliasing
  • Aggregation and Functions
  • NULL values and related SQL functions
• Subqueries