SQL

SQL

Session 01: Intro to Relational Databases

Now, you have reached the stage in the Program where you need to learn how to manage your data in an institutional way.

Session 02: Intro to PostgreSQL

Imagine you’ve just joined a company as a data analyst.
The company sells products through an online channel and stores its operational data in a PostgreSQL relational…

Session 03: DA with SQL | Data Types & Constraints

Before diving into more SQL syntax, let’s pause for a moment to consider what happens behind the scenes when a SQL query is executed.

Session 04: DA with SQL | Filtering

Now, we will be taking a closer look at how to filter data using the WHERE clause and the HAVING statement. With lots of examples and use cases along the way to prepare you…

Session 05: DA with SQL | Numeric Functions

Before jumping to the built-in SQL Funcions let’s ensure that we have sales_analysis table.

Session 06: DA with SQL | String Functions

Text (string) functions are used to inspect, clean, standardize, and transform textual data at the row level.

Session 07: DA with SQL | Date Functions

Up to this point, we have worked with numbers and text.
Now we move to the most important analytical dimension of all: the Time.

Session 08: DA with SQL | JOINs

Relational databases do not start with JOINs.
They start with structure.

Session 09: DA with SQL | Advanced SQL

In analytical work, queries are rarely written, executed, and forgotten. Analysts typically work iteratively: they explore data, compute intermediate metrics, validate…

Session 10: DA with SQL | Advanced SQL Functions

A window function is a SQL function that performs a calculation over a set of rows related to the current row, called a window, without collapsing rows.

Session 11: DA with SQL | UDFs, Stored Procedures

By the end of this session, students will be able to:

Session 12: DA with SQL | Advanced Aggregations

This final session demonstrates why advanced aggregations exist by first solving an analytical problem using classic GROUP BY + UNION ALL, and then solving the same problem u…

Session 13: DA with SQL | Final Project

Design and deliver a production-grade analytical SQL project that demonstrates: