SQL for Data Analysis

Learn SQL from absolute basics to advanced analytical queries. You will master SELECT, JOINs, aggregations, subqueries, window functions, CTEs, and use real-world datasets to answer business questions in PostgreSQL.

group 0 students

trending_up beginner Level

layers 4 Modules

Created by Test Instructor

Course Content

4 Modules • 21 Lessons

play_circle Subqueries and Correlated Subqueries

play_circle Common Table Expressions (CTEs)

play_circle Window Functions: ROW_NUMBER, RANK

play_circle LAG, LEAD, and Running Totals

description Query Optimization and EXPLAIN

description Capstone: Sales Analysis

play_circle COUNT, SUM, AVG, MIN, MAX

play_circle GROUP BY

play_circle HAVING

play_circle DISTINCT and CASE WHEN

description Aggregation Practice

play_circle What is SQL and Relational Databases? Preview

description Installing PostgreSQL Preview

play_circle SELECT and FROM

play_circle WHERE, AND, OR, IN

play_circle ORDER BY and LIMIT

description Basics Quiz

Your Instructor

Test Instructor

Instructor

school 0 Students

Student Reviews

star_border

No reviews yet. Be the first to review this course!

Enroll Now

Free forever. Start learning instantly.

layers 4 modules • 21 lessons
ondemand_video On-demand video lessons
all_inclusive Full lifetime access
emoji_events Certificate of completion

Enroll Now