Intro to Advanced SQL Concepts

Online Campus

Online
Anywhere
Online

Past Locations for this Workshop

Intro to Advanced SQL Concepts | Online

Online Campus

Online
Anywhere
Online

Past Locations for this Workshop

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

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.