Aug 25, 2022 12:00 AM

Learn SQL for Data Analysis in one hour (with sample dataset + 50 queries)

External YouTube Channel

SQL is one of the most important skills to have for data people. In this comprehensive video, learn how to use SQL to perform common data analysis tasks.

How to use SELECT statement to answer business questions

  • Working with WHERE clause
  • Using AND, OR, NOT and combining them to create complex queries.
  • Sorting query results using ORDER BY
  • Combining data from two or more tables using JOINS
  • Creating reports with GROUP BY
  • More than 50 example queries, tips and ideas

In this Video

IN THE VIDEO:

0:00 - Introduction

0:43 - Data setup, explanation & basic queries

6:24 - Adding calculated columns in SELECT

8:39 - Our first WHERE clause

10:28 - Ordering query results with ORDER BY

13:24 - More Where clause examples

16:42 - Between conditions

19:06 - Working with Dates

21:50 - Using other tables

23:47 - IN clause

24:36 - Pattern matching in SQL

26:30 - CASE operator and branching logic

30:30 - JOINS

36:32 - LEFT Join vs. RIGHT Join

38:28 - More Join examples

42:10 - Adding conditions to Joins

47:30 - GROUP BY and creating reports with SQL

54:50 - Showing Top 10 Products by Amount

57:12 - Closing remarks & next steps for you