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

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