SQL for Data Analytics - Learn SQL in 4 Hours

Thanks to Kelly Adams for her work in producing this course 🎉🙌

Ch 1️⃣ - Basics
==============
00:00 - Welcome
03:43 - What is SQL
10:44 - Intro to Course
16:51 - The Basics
33:58 - Comparisons
41:16 - Practice Problem 1
45:21 - Wildcards
48:47 - Alias: AS
51:04 - Practice Problem 2
53:58 - Operations
59:34 - Aggregation
1:06:25 - Practice Problem 3
1:08:42 - NULL Values
Skipped - Practice Problem 4
1:10:03 - JOINS
1:20:11 - Order of Execution
1:22:31 - Practice Problem 5

Ch 2️⃣ - Advanced
==============
1:26:14 - Setup PostgreSQL
1:32:43 - IDE Install: VS Code
1:44:03 - Data Types
1:47:29 - Manipulate Tables
1:59:54 - Database Load
2:09:55 - Date Functions
2:20:18 - Problem Problem 6
2:24:54 - CASE Expression
2:30:16 - SubQueries and CTEs
2:42:12 - Practice Problem 7
2:50:02 - UNION Operators
2:54:19 - Practice Problem 8

Ch 3️⃣ - Project
==============
2:58:01 - About the Project
3:02:07 - Create the Repository
3:14:39 - Query 1 - Top Paying Jobs
3:20:31 - Query 2 - Top Paying Job's Skills
3:27:59 - Query 3 - In-Demand Skills
3:34:02 - Query 4 - Top Paying Skills
3:41:25 - Query 5 - Most Optimal Skills
3:53:01 - Share on GitHub
4:05:03 - Share on LinkedIn

Social Media / Contact Me
======================

#sql #postgresql #sqlite

[LukeBarousse]

Updates for Video 👇

2:06:55 - Database Load Issues


NOTE: If you are having issues with permissions. And you get an error like: "could not open file
for reading: Permission denied."

1. Open pgAdmin

2. In Object Explorer (left-hand pane), navigate to `sql_course` database

3. Right-click `sql_course` and select `PSQL Tool`
- This opens a terminal window to write the following code

4. Get the absolute file path of your csv files
a. Find path by right-clicking a CSV file in VS Code and selecting “Copy Path”

5. Paste the following into `PSQL Tool`, (with the CORRECT file path)

\copy company_dim FROM '[Insert File Path]/company_dim.csv' WITH (FORMAT csv, HEADER true, DELIMITER ', ', ENCODING 'UTF8');

\copy skills_dim FROM '[Insert File Path]/skills_dim.csv' WITH (FORMAT csv, HEADER true, DELIMITER ', ', ENCODING 'UTF8');

\copy job_postings_fact FROM '[Insert File Path]/job_postings_fact.csv' WITH (FORMAT csv, HEADER true, DELIMITER ', ', ENCODING 'UTF8');

\copy skills_job_dim FROM '[Insert File Path]/skills_job_dim.csv' WITH (FORMAT csv, HEADER true, DELIMITER ', ', ENCODING 'UTF8');


2:06:55 - Duplicate Key Error

NOTE: If you are getting the following error (below) even after following the steps above you need to restart over and drop the database:
ERROR >> duplicate key value violates unique constraint "company_dim_pkey"
ERROR >> could not open file for reading: Permission denied

1. Drop the Database
DROP DATABASE IF EXISTS sql_course;

2. Repeat steps to create database and load table schemas

3. Follow steps above for copying CSV files into the sql_course database


3:08:15 Git Error - "Tell me who you are"

NOTE: Some users, setting up git for the first time are receiving the following error:
Please tell me who you are.
Run
git config --global user.name "Your Name"

1. Open your terminal.
2. Set your Git identity by :
git config --global user.email "[insert email address]"
git config --global user.name "[insert your name]"
3. Continue video

[qualitybacon]

SELECT column1, column2 -- Silly
FROM table_name -- Frogs
WHERE column1 = 'value' -- Wear
GROUP BY column2 -- Green
HAVING COUNT(column2) > 1 -- Hats
ORDER BY column1 -- On
LIMIT 10; -- Lakes

[adamscott]

Gotta say, What i really appreciate about this is that you include when you mess up. its a great teaching point for others to know that someone like you still messes up. its not about being perfect with code, its about knowing how to troubleshoot and debug the code. to me, that matters more than always getting it right the first time.

[marissajepsen]

Holy cow! This is goes in depth of SQL to delve into. I have been trying to find a really good up to date course that is 4 hours long! You did an incredible job. My boyfriend and I are learning SQL together. We changed career paths and want to become a data analyst. THANK. YOU!! 🎉❤😊

[KidnovaFOI]

I just started my journey in data analytics to change career paths in early January. I'm almost done the IBM Data Analytics course on Coursera. I'm so glad this came out as the course has way more python than SQL and I planned to look for a course soon. THANK YOU!! 😄

[rurza]

i have waited for such course from you for my whole life. Thank you

[kavalimahesh]

I have been trying to learn basics of SQL for quite sometime now and this comes at a right time as it's easy to understand and very resourceful.
Thanks Luke for breaking down every step and explaining everything about SQL to millions of people around the world.

[wetsand]

I'm in school for data analytics and this course has been FAR more helpful than any of my classes so far. Thanks a lot!

[jonr]

4h of Luke? I can binge on that, but not today!

First few minutes... Not just clear as Cristal (& as tasty!) With real serious info but delivery with wit & humor..

Picture of favorite uncle in picture frame??

[MirjaShahidulIslam]

This is by far one of the best and most complete SQL tutorial for Data Analytics, minus the course purchase option. Luke is one of my favorite data nerd, thank you. May the data be with you! 🤓

[kqtctuc]

Luke!!!! Just found this video and can hardly wait to get started this evening. Thanks in advance to you and Kelly Adams for putting this course together. Was wondering what I was going to explore next, now I know. Have a fantastic week! 😎

[jaybatterson]

Great course - totally worth the upgrade for the exercises and the additional notes. Best training "bang-for-buck" that I have seen for a long time. The video is 4 hours long, but it took me 3 days to get through it with all of the additional exercises (because I am slow) and tangents (because I am too curious). Really opened my eyes to more than SQL and data analysis.

[printdigitalpivot]

This is Absolute GOLD. Thank you Luke and Kelly for providing us with this for anyone. You Guys are awesome!!

[nunodolgner]

Pure excelence! Started just now the full course and really looking forward to improving my SQL skills. Thanks once again Luke. 🙌

[aissamboudra]

by watching your different videos and the analysis done on your websites, learning SQL is essential in the world of data. Lots of tutorials on the web, I didn't find the motivation to start, but finally here is the SQL tutorial from my favorite channel. no more excuses, I can't wait to start 😀

[josipgregoric]

Note: extra_hours at 59:13 shows wrong data when a 16h work day is in question (shows 0, should be 8). Corrected code for the extra_hours column would be: (hours_spent % 8) + (FLOOR(hours_spent / 8) - 1) * 8 AS extra_hours. Great material. Cheers!

[pieroiturrizaga]

I'm a college student trying to break into data analytics, really appreciate the time and effort put into this video. Excited to learn more about data, THANK YOU!!

[kangwamumba]

You sir are a godsend. Will definitely work towards supporting the course.

[mxmorningstarr]

It was an awesome project and the best part was editing the readme file and correcting all the hick-ups i found myself in along the way. I have almost completed the Google Data Analytics certificate on Coursera and they have SQL in it but this is so much more insightful. Thank you so much for this video.

[just_a_viewer]

Thank you Luke. Took me around a month to finish this but now I know SQL very well!