๐ FREE Course Databases & Links ๐ https://lukebarousse.com/sql
๐ Supporter Access: Problems, Certificate, & More ๐ https://lukeb.co/sql
โ ๏ธ Fix Database Load Issue in Ch 2 ๐ https://lukeb.co/sql_error
IMPORTANT: Drop the database and reload the tables before proceeding. (Instructions in pinned comment)
My FREE Course to be a Data Analyst ๐ https://lukebarousse.com/5daycourse
๐๐ต 1๏ธโฃ - ๐๐ฎ๐๐ถ๐ฐ๐
โโโโโโโ
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
๐๐ต 2๏ธโฃ - ๐๐ฑ๐๐ฎ๐ป๐ฐ๐ฒ๐ฑ
โโโโโโโโ
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
๐๐ต 3๏ธโฃ - ๐ฃ๐ฟ๐ผ๐ท๐ฒ๐ฐ๐
โโโโโโโ
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
๐ฆ๐ผ๐ฐ๐ถ๐ฎ๐น ๐ ๐ฒ๐ฑ๐ถ๐ฎ
โโโโโโโ
๐ซNewsletter: https://www.lukebarousse.com/
๐จ๐ผโ๐ผ Linkedin: https://www.linkedin.com/in/luke-b/
๐
ง X/Twitter: https://twitter.com/LukeBarousse
๐ Instagram: https://www.instagram.com/lukebarousse/
โฐ TikTok: https://www.tiktok.com/@lukebarousse
Thanks to Kelly Adams for her work in producing this course ๐๐
๐ฉ๐ปโ๐ผ Kelly's LinkedIn: https://www.linkedin.com/in/kellyjianadams/
๐ Kelly's Website: https://www.kellyjadams.com/
#sql #postgresql #sqlite