Video is being uploaded

The lesson notes below are ready. Add a YouTube id or a Bunny Stream link for this lesson in the admin portal and the player appears here.

Open the course playlist

Module 04 · SQL for Data AnalysisFREE LESSON19 min

Databases, Tables and Your First SELECT

How a relational database is laid out, and SELECT / FROM / LIMIT.

By the end of this lesson you can

Read a schema diagram
Write your first queries

Found this useful? Send it on.

This lesson is free — whoever you send it to can watch it without an account.

Lesson feedback

No ratings for this lesson yet.

Correlation, Causation and A/B Tests WHERE, Operators and NULL

Course content

0/73

01Data Analysis Foundations

0 / 9

02Excel & Google Sheets for Analysts

0 / 11

Mini projects

1.Retail Sales Dashboard in Excel

03Statistics for Data Analysts

0 / 11

Mini projects

1.A/B Test Analysis for a Checkout Change

04SQL for Data Analysis

0 / 12

SQL for Data Analysis

0 / 12

Querying Single Tables

0 / 3

1.Databases, Tables and Your First SELECTFree
2.WHERE, Operators and NULL21m
3.ORDER BY, DISTINCT and CASE18m

Exercises

1.25 Filtering Queries
2.Revenue by Category, Region and Month
3.Rewrite Nested Queries as CTEs

Interview Q&A

1.SQL Interview Questions

Aggregation and Grouping

0 / 3

Joins and Subqueries

0 / 3

Advanced SQL for Analysts

0 / 3

Mini projects

1.E-commerce SQL Analysis

05Python for Data Analysis

0 / 12

Mini projects

1.EDA on Indian Startup Funding

06Business Intelligence with Power BI

0 / 9

Mini projects

1.Executive Sales Dashboard in Power BI

07Capstone Projects & Career Preparation

0 / 9

Capstone projects

1.Capstone — Telecom Customer Churn, End to End

Stay updated