Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Corporate Finance Institute

Advanced SQL for Analysts

via Corporate Finance Institute

Overview

What Do Analysts at Goldman Sachs and Amazon Have in Common?
They master their craft with the full CFI curriculum — now 30% off with code AFF30.
Get 30% Off

Advanced SQL for Analysts Course Overview

Advanced SQL for Analysts builds on foundational SQL skills and focuses on the patterns analysts use to solve more complex business questions. You’ll learn how to use advanced querying techniques such as window functions, reporting shapes, subqueries, and modular query building to produce more reliable analytical results. The course also introduces key concepts from the realms of data engineering and database administration to help you become a stronger analyst. By understanding ideas like grain, keys, relationships, medallion architecture, reusable logic, and common query pitfalls, you’ll be better equipped to work with data thoughtfully, communicate across technical teams, and write SQL that is easier to trust.

Who Should Take This Course?

This course is designed for analysts who already know basic SQL and want to write more advanced queries for reporting, analysis, and business logic. It is especially useful for professionals in analytics, business intelligence, finance, or operations who want to strengthen their SQL skills while building a better understanding of data modeling, engineering concepts, and analytical best practices. 

Advanced SQL for Analysts Learning Objectives

Shape analytical results with reporting patterns and window functions Solve complex business questions with subqueries and modular query building Apply core data modeling concepts such as grain, keys, and relationships Evaluate analytical output using medallion architecture, denormalization, and semantic layers Identify and avoid common SQL pitfalls involving NULLs, filters, joins, dates, and text

Syllabus

  • Course Introduction
  • Reporting Query Patterns
  • Advanced Query Structure
  • Data Modeling & Semantic Layers
  • Common Pitfalls & Best Practices
  • Course Wrap-Up
  • Qualified Assessment

Taught by

Joseph Yeates

Reviews

Start your review of Advanced SQL for Analysts

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.