Skip to main content
Sign inRequest a demo
EduRails

Online learning made easy. For your whole institution.

Request a demo Sign in

IntermediateContent in Spanish

SQL for data analysis

Master SQL with your eyes on analysis: query, filter, join and aggregate data from relational databases to answer real business questions. You will learn everything from the simplest SELECT to window functions and CTEs using PostgreSQL. It is the third course of the Professional Certificate in Data Analysis.

9 lessons 10 hours 700 XP

Start the course

Syllabus

Module 1 · Relational model fundamentals

  1. 1The relational model and your first SELECT query45 min
  2. 2Filtering and sorting: WHERE, ORDER BY and LIMIT50 min
  3. 3Data types and column functions50 min

Module 2 · Joining and aggregating data

  1. 4JOINs: combining related tables55 min
  2. 5Aggregating data: GROUP BY, aggregate functions and HAVING55 min

Module 3 · Advanced queries

  1. 6Subqueries: queries within queries50 min
  2. 7CTEs: organize complex queries with WITH50 min

Module 4 · Analysis with window functions and dates

  1. 8Window functions: ROW_NUMBER, RANK and SUM OVER55 min
  2. 9Working with dates and time-based analysis50 min

Back to the catalogue