Sign in to confirm you’re not a bot
This helps protect our community. Learn more

SQL for Data Analytics - Learn SQL in 4 Hours

Luke Barousse
509K subscribers
<__slot-el>
<__slot-el>
690K views 1 year ago #sqlite #postgresql #sql
Course Problems & Certificate 👉 https://lukeb.co/sql Course Databases & Links 👉 https://lukebarousse.com/sql ⚠️ Fix Database Load Issue in Ch 2 👉 https://lukeb.co/sql_error IMPORTANT: Drop the database & reload tables before following!!! (Instructions in pinned comment) My FREE Course to be a Data Analyst 👉 https://lukebarousse.com/5daycourse Thanks to Kelly Adams for her work in producing this course 🎉🙌 👩🏻‍💼 Kelly's LinkedIn:   / kellyjianadams   🌐 Kelly's Website: https://www.kellyjadams.com/ Ch 1️⃣ - Basics ============== 0:00:00 - Welcome 0:03:43 - What is SQL 0:10:44 - Intro to Course 0:16:51 - The Basics 0:33:59 - Comparisons 0:41:18 - Practice Problem 1 0:45:23 - Wildcards 0:48:49 - Alias: AS 0:51:06 - Practice Problem 2 0:54:01 - Operations 0:59:37 - Aggregation 1:06:28 - Practice Problem 3 1:08:45 - NULL Values Skipped - Practice Problem 4 1:10:07 - JOINS 1:20:15 - Order of Execution 1:22:35 - Practice Problem 5 Ch 2️⃣ - …...more
...more

Welcome

0:00

What is SQL

3:43

Intro to Course

10:44

The Basics

16:51

Comparisons

33:59

Practice Problem 1

41:18

Wildcards

45:23

Alias: AS

48:49

Practice Problem 2

51:06

Operations

54:01

Aggregation

59:37

Practice Problem 3

1:06:28

NULL Values

1:08:45

JOINS

1:10:07

Order of Execution

1:20:15

Practice Problem 5

1:22:35

Setup PostgreSQL

1:26:18

IDE Install: VS Code

1:32:48

Data Types

1:44:08

Manipulate Tables

1:47:35

Database Load

2:00:00

Date Functions

2:10:02

Problem Problem 6

2:20:26

CASE Expression

2:25:02

SubQueries and CTEs

2:30:24

Practice Problem 7

2:42:21

UNION Operators

2:50:11

Practice Problem 8

2:54:28

About the Project

2:58:11

Create the Repository

3:02:17

Query 1 - Top Paying Jobs

3:14:50

Query 2 - Top Paying Job's Skills

3:20:42

Query 3 - In-Demand Skills

3:28:10

Query 4 - Top Paying Skills

3:34:14

Query 5 - Most Optimal Skills

3:41:37

Share on GitHub

3:53:14

Share on LinkedIn

4:05:16
SQL for Data Analytics - Learn SQL in 4 Hours
21KLikes
690,613Views
2024Mar 11
Course Problems & Certificate 👉 https://lukeb.co/sql Course Databases & Links 👉 https://lukebarousse.com/sql ⚠️ Fix Database Load Issue in Ch 2 👉 https://lukeb.co/sql_error IMPORTANT: Drop the database & reload tables before following!!! (Instructions in pinned comment) My FREE Course to be a Data Analyst 👉 https://lukebarousse.com/5daycourse Thanks to Kelly Adams for her work in producing this course 🎉🙌 👩🏻‍💼 Kelly's LinkedIn:   / kellyjianadams   🌐 Kelly's Website: https://www.kellyjadams.com/ Ch 1️⃣ - Basics ============== 0:00:00 - Welcome 0:03:43 - What is SQL 0:10:44 - Intro to Course 0:16:51 - The Basics 0:33:59 - Comparisons 0:41:18 - Practice Problem 1 0:45:23 - Wildcards 0:48:49 - Alias: AS 0:51:06 - Practice Problem 2 0:54:01 - Operations 0:59:37 - Aggregation 1:06:28 - Practice Problem 3 1:08:45 - NULL Values Skipped - Practice Problem 4 1:10:07 - JOINS 1:20:15 - Order of Execution 1:22:35 - Practice Problem 5 Ch 2️⃣ - Advanced ============== 1:26:18 - Setup PostgreSQL 1:32:48 - IDE Install: VS Code 1:44:08 - Data Types 1:47:35 - Manipulate Tables 2:00:00 - Database Load 2:10:02 - Date Functions 2:20:26 - Problem Problem 6 2:25:02 - CASE Expression 2:30:24 - SubQueries and CTEs 2:42:21 - Practice Problem 7 2:50:11 - UNION Operators 2:54:28 - Practice Problem 8 Ch 3️⃣ - Project ============== 2:58:11 - About the Project 3:02:17 - Create the Repository 3:14:50 - Query 1 - Top Paying Jobs 3:20:42 - Query 2 - Top Paying Job's Skills 3:28:10 - Query 3 - In-Demand Skills 3:34:14 - Query 4 - Top Paying Skills 3:41:37 - Query 5 - Most Optimal Skills 3:53:14 - Share on GitHub 4:05:16 - Share on LinkedIn Social Media / Contact Me ====================== 📫Newsletter: https://www.lukebarousse.com/ 👨🏼‍💼 Linkedin:   / luke-b   🅧 X/Twitter:   / lukebarousse   🌄 Instagram:   / lukebarousse   ⏰ TikTok:   / lukebarousse   #sql #postgresql #sqlite

Shorts remixing this video

Follow along using the transcript.

Luke Barousse

509K subscribers