Pro Tips & Troubleshooting: ⏪ Use the "J" key to rewind 10 secs ⏩ Use the "L" key to fast-forward 10 secs 🪡 Precise Seeking: - Tap the screen to see the progress bar - Slide up from the scrubber (red dot) to see a row of thumbnails - Swipe on the thumbnails to find a specific moment in the video Updates for Video 👇 =========================================================================== 2:06:55 - Database Load Issues WATCH THIS VIDEO FOR A WALKTHROUGH OF THESE INSTRUCTIONS: lukeb.co/sql_error NOTE: If you are having issues with permissions. And you get an error like: "could not open file "C:\file_path\job_postings_fact.csv" 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. Open pgAdmin 4. In Object Explorer (left-hand pane), navigate to `sql_course` database 5. Right-click `sql_course` and select `PSQL Tool` - This opens a terminal window to write the following code 6. 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” 7. 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 "C:\Users\...\company_dim.csv" 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.email "you@example.com" 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
Solved it! I found the solution on stack overflow. 'Assuming the psql command-line tool, you may use \copy instead of copy. \copy opens the file and feeds the contents to the server, whereas copy tells the server the open the file itself and read it, which may be problematic permission-wise, or even impossible if client and server run on different machines with no file sharing in-between. Under the hood, \copy is implemented as COPY FROM stdin and accepts the same options than the server-side COPY.' I used SQL Shell (psql). Make use you typed \copy instead of COPY
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.
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
I can’t really understand this, because no syntax is “ultimate”. I have seen syntaxes such as : WITH X as ( Var1 as defined.. Var2 as defined.. …) Select Y FROM X LIMIT Z
I have two bachelor's degree and graduated at the top of both my classes for both degrees, dropped out of two grad programs and I firmly believe that skills are more marketable than degrees and certifications. It's more about what you can do than what you claim you can do.
You guys are doing such a great job. I watched Tim's courses on LinkedIn Learning, it was a Gold for sure and now I am getting another gold thing from Luke.
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.
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!! 😄
I am a beginner who often gets confused with whether GROUP BY should come first or ORDER BY. One way to remember this is 'G' comes before 'O' alphabetically (HAVING is used in combination with GROUP BY) and finally as Luke mentioned in the video LIMIT will always be the last statement. Your pinned tips of using "J" key for rewind was a big saver, Luke.
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!! 🎉❤😊
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! 😎
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! 🤓
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??
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.
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!!
Absolutely spectacular video! Not finished yet but finding your SQL teaching very very comprehensive indeed. Just wanted to thank you from the bottom of my heart for demystifying this!!
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 😀
Great video! Watching through it now and just finished practice problem 5 at the end of the fundamentals section (1:23:00). Turns out the second left join used in the answer should actually be an inner join. I was getting different numbers for number of job postings than what was being shown in the video. With a little help from ChatGPT I found that the issue was the second left join needing to be switched to an inner join. Not sure if this has been addressed by another comment but hope this helps anyone else following along!
33:38 My fun pneumonic for remembering the order or SQL code is: Seven (Select) Fun (From) Werewolves (Where) Get (Group By) Happy (Having) Over (Order by) Lunch (Limit)
Hi @josephletner5066, I'm a student cant afford to buy extra materials. Could you please share me practice questions? It would be really helpful. Thanks!
Thank you Luke. You made video just in time that I’m looking for SQL full deep dive course. I used to learn Data science boot camp before, but the boot camp just provided SQL basic thing and course time limit
I recently started working with Tableau and had troubles understanding how to query our database for data. This is incredibly helpful, and your teaching style is admirable. Well done and thank you.. you're changing my life at my job!
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.
Hey jay, what's your thought on 60+ practice problems. I'm thinking to purchase to practice more but 25$ is lot for me in India. Can you advise me what should I do or if possible ,share practice problems with me? I found this particular course really helpful, and want to practice more. Thank you
Thank you so much @LukeBarousse for the amazing content on Python, SQL, and Excel! Your tutorials have been incredibly helpful in my journey to becoming a data analyst. The step-by-step explanations and clear examples make complex topics much easier to understand. I truly appreciate all the effort you put into creating these resources. Keep up the great work - you're making a huge difference for so many of us learning these skills! 🙏
It’s only 25.usd to support, that’s a small contribution, happy to “help” but it’s you helping the world. Hoping you’ll find the time to do this also for Python, love to follow that one as well. Keep on doing what you are doing, thanks Luke!
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!
I subscribed after 30 mins of watching and learning from your video. I most recently decided to change careers and thusfar this has been the most productive learning SQL video I've come across. I will be purchasing the supporter resources. ✨ Thank you!
30 minutes into your video I subscribed. I've recently transitioned careers to become an Data Analyst and this has been the best teaching of SQL video I've come across. I will be purchasing the supporter resources ✨. Thank you!!
32:25 the pnemonics i'm using is Some =Select Delusional = Distinct French = From Waiters = Where Grow = Group By Healthy = Having Orange & = Order By Lemons = Limit
I was waiting for something like this !!!!! That's what I and all of us will ever need to understand the SQL. I was at coursera, udemy, but it cannot compare with this masterpiece. Just practise !
That's a very helpful content. SQL is easy as someone from an engineering background dealt with SQL for a few months I thought I'm still a beginner, but as I skimmed through this video I found I already know everything. All by practicing real case problem solving and self-learning.
Just want to say that I think that your teaching and editing style for this SQL course was very effective. Clear teaching and nice editing, transitions and course structure. Might be the most effective course that I've gone through yet.
This course has been really helpful to me. I am at a point where I need to take my data analysis skills to the next level and I would not have been able to learn without this course. I have reached the advanced level and I am really learning. Thank you so much. I encourage everyone to purchase this course and do the exercises ;)
Ok although I'm not a beginner I'm still going to watch this because yeah, I've been waiting for you to release this. You need to do more courses really. There are a lot of these course out there yes, but to me, I believe in YOUR skills and YOIR knowledge so I would love to watch your course. I enjoy your way of teaching a lot. so this video means a lot to me. You're amazing for putting this out for free. I'm planning to switch careers again soon and when I do, I'll be joining to help pay yoir bills lol. Anyway, much respect ! Keep up the good work.
Probably one of the best 25$ i spent in my entire life. Problems are harder than capstone project itself and you also greatly outlined all the important topics and introduction to the github. Really appreciate Luke, thank you and Kelly for your amazing work!
@@amagwen7528 yes on youtube. Not really downloading the and savw it somewhere else. It allows you to play the video while offline. Download button is found under the video.
Thanks for this content. I'm using this as a refresher course after learning SQL last summer as part of a data analyst bootcamp. The job market is difficult in my region (South of France) but I've got to keep "buggering on" 😅 if I'm going to land a job...
Thank you so much for this great video. I wanted to start learning SQL and it was kind of scary for me, but you explained everything with great detail and everything was perfect.
@LukeBarousse, many thanks for doing this. I have been following through the video/course but I have encountered a problem. When I published the repository to Github, I cannot see the folders sql_load on Github. Furthermore, when I did the push example "project_sql (query_1.sql)" the vscode output shows "No remote found in the git config file" error message and I am not sure how to resolve this. Any guidance would be appreciated. Thank you.
So I bought his course love it. And will buy python course from him. Is there anyone else that does this or makes courses like him other than Coursera which I also have done. Like the 60+ problems are so great just want more in excel and power bi
How is this FREE?!? Holy moly, this is fantastic. I've been looking into Data Analyst stuff this evening (looking for career change/expansion) and you and this course were referenced in two different places I ended up. And I can see why. And your "paid" stuff is $25??? THANK YOU for what you're doing.
Dude! halfway through this course. I love the depth and detail you and Kelly have put into this course! I also like that you use VS Code for the second part of the course. I will be setting it up to learn Python when your Python course is out. Please continue making courses of similar quality and depth. I will be buying them as soon as they are available.
Hi Luke! Thanks for the great content! I got a question as I approach toward the end of this video. I need an explanation on why even though the group by clause does not contain the column "skills", the query works normally without any errors in postgre sql. I know that whatever is in the select statement besides aggregate functions, must be in the group by statement too. ChatGPT gave me some insights on this like "In PostgreSQL and some other database systems, there's a feature called "functional dependency" or "functional determinant" that can allow a query to execute successfully even if the GROUP BY clause does not explicitly include all non-aggregated columns from the SELECT clause". I do get the understanding that even if this works here because "each unique skill_id corresponds to only one skills value" , this is something to be avoided when querying databases as it is likely to give us back an error. Please provide some feedback! Thanks so much Man
for quarters of a year, try extract(quarter from ........) = 2 for example for second quarter (filter second quarter) instead of extract month and check if it is between ... and ...
Luke, THANKS FOR THAT! You guys did such a great job. We’ll never be able to express our gratitude enough 🎉🎉 Such an amazing way to hone my SQL skills 💪🏻
i must say that i learned more form this video than the google analyst, w3school and udemy, yeah, i've tried everything, still recommend but this is a more realistic approach, thank you, you're great
I really like your courses Luke and decided to take a look at this, regardless of being an SQL professional for ~18 years. I am still getting a headache whenever I see joins written like this: SELECT ... FROM a LEFT JOIN b ON a.column = b.column It should be: LEFT JOIN b ON b.column = a.column Still I cannot comprehend how with complex join conditions spanning multiple rows one keeps referencing the first table on the right of the expressions without a cringe :)
1:30:40 who gets error when installing POSTGRESQL, do not check 'default locale'. Instead, choose something like 'United States English'. For some reason, the default doesn't work.When prompted for locale, do not check 'default locale'. Instead, choose something like 'United States English'. For some reason, the default doesn't work.
Hi Luke, I hope you're doing well. I was reviewing the SQL query and I came across something that I think might be a mistake. You suggested using AND in the WHERE clause at 53:00 to filter job titles containing 'data', 'business', 'analyst', or 'Analysis'. However, based on my understanding, it seems like using OR than AND at the part '%Analyst%' would be more appropriate for this scenario to match any of these keywords and it really confused me but anyways I've learnt a lot from you and you might be the best instructor I've watched at RUclips regarding in SQL.❤
Looks good. Made perfect sense to me, but I am concerned about beginners. Fortunately you keep saying "we will come back to this later", if beginners can set aside panic, this should be a very rapid, but thorough introduction to SQL. Future versions may want to mention a path from SQLite to DuckDB. Although SQLite is standard now, DuckDB has targeted analytic workloads (CSV) as opposed to transactional workloads (forms). DuckDB SQL is also closer to Postgres SQL (built with Postgres interpreter). DuckDB has amazingly fast loading of CSV files and SQL SELECT queries!
Than you for the course Luke. I am a little confused though. In the operations section at around 59:22, you included a column alias in the where section, but if we follow the order of execution, the extra_hours column should not exist. I am using Postgres inside VSCode and it gives me a column does not exist error, yet, in the SQLiteviz, it does work. To stay consistent with the order of execution, would it not be better to include the operation in the WHERE clause. I am new at this, so I might be missing something. Thank you. Also, sorry if you mentioned it and I missed it. WHERE (hours_spent BETWEEN 8 AND 16) AND hours_spent % 8 > 0
Pro Tips & Troubleshooting:
⏪ Use the "J" key to rewind 10 secs
⏩ Use the "L" key to fast-forward 10 secs
🪡 Precise Seeking:
- Tap the screen to see the progress bar
- Slide up from the scrubber (red dot) to see a row of thumbnails
- Swipe on the thumbnails to find a specific moment in the video
Updates for Video 👇
===========================================================================
2:06:55 - Database Load Issues
WATCH THIS VIDEO FOR A WALKTHROUGH OF THESE INSTRUCTIONS: lukeb.co/sql_error
NOTE: If you are having issues with permissions. And you get an error like: "could not open file
"C:\file_path\job_postings_fact.csv" 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. Open pgAdmin
4. In Object Explorer (left-hand pane), navigate to `sql_course` database
5. Right-click `sql_course` and select `PSQL Tool`
- This opens a terminal window to write the following code
6. 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”
7. 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 "C:\Users\...\company_dim.csv" 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.email "you@example.com"
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
Solved it! I found the solution on stack overflow.
'Assuming the psql command-line tool, you may use \copy instead of copy.
\copy opens the file and feeds the contents to the server, whereas copy tells the server the open the file itself and read it, which may be problematic permission-wise, or even impossible if client and server run on different machines with no file sharing in-between.
Under the hood, \copy is implemented as COPY FROM stdin and accepts the same options than the server-side COPY.'
I used SQL Shell (psql). Make use you typed \copy instead of COPY
@@LukeBarousseI've encountered the same issue with Mac but the solution you've posted also worked. Thank you very much!
I have the same problem on MAC. I'm a fresher, please help! @LukeBarousse
yea same
@@attiquetahir
@@mrbartuss1 Thanks for this solution I updated this as the new solution
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.
completely agree with you!
Absolutely 💯
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
Great job, I use alias with my Select statement.
I can’t really understand this, because no syntax is “ultimate”.
I have seen syntaxes such as :
WITH X as (
Var1 as defined..
Var2 as defined..
…)
Select Y FROM X
LIMIT Z
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!
schools never helped in anything man.
they just want our money
I have two bachelor's degree and graduated at the top of both my classes for both degrees, dropped out of two grad programs and I firmly believe that skills are more marketable than degrees and certifications. It's more about what you can do than what you claim you can do.
Stop it Luke Stop it! I watched the first 5 minutes without meaning to! and its a video about SQL.... bravo!
Ha! thanks for the kind words Tim! (and also for checking it out 😜)
You guys are doing such a great job. I watched Tim's courses on LinkedIn Learning, it was a Gold for sure and now I am getting another gold thing from Luke.
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.
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!! 😄
I wish you success on your journey!
Same here, but i'm the beginning. But I started a SQL course from University Davis and I find it so complete.
Im halfway through the Google data analytics course on Coursera and it has more SQL than Python
Can u provide more info on Davis course?@@alicecooper2473
So the IBM one has Python
I am a beginner who often gets confused with whether GROUP BY should come first or ORDER BY. One way to remember this is 'G' comes before 'O' alphabetically (HAVING is used in combination with GROUP BY) and finally as Luke mentioned in the video LIMIT will always be the last statement.
Your pinned tips of using "J" key for rewind was a big saver, Luke.
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!! 🎉❤😊
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! 😎
Pure excelence! Started just now the full course and really looking forward to improving my SQL skills. Thanks once again Luke. 🙌
i have waited for such course from you for my whole life. Thank you
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! 🤓
🖖🏼
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??
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.
Heck yeah, i'm glad it was able to help you go deep er with learning SQL
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!!
How’s it going?
Absolutely spectacular video! Not finished yet but finding your SQL teaching very very comprehensive indeed. Just wanted to thank you from the bottom of my heart for demystifying this!!
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 😀
Having a career change to Business Analysis. This is superb & so is your enthusiasm. Much appreciated.
Great video! Watching through it now and just finished practice problem 5 at the end of the fundamentals section (1:23:00). Turns out the second left join used in the answer should actually be an inner join. I was getting different numbers for number of job postings than what was being shown in the video. With a little help from ChatGPT I found that the issue was the second left join needing to be switched to an inner join. Not sure if this has been addressed by another comment but hope this helps anyone else following along!
33:38 My fun pneumonic for remembering the order or SQL code is:
Seven (Select)
Fun (From)
Werewolves (Where)
Get (Group By)
Happy (Having)
Over (Order by)
Lunch (Limit)
For me, except W, just look at the keyboard. They are pretty much in order accdg to the command.😊
You sir are a godsend. Will definitely work towards supporting the course.
Well worth the $25. Thanks for putting this course together!! 🎉
You're so welcome!
Hi @josephletner5066, I'm a student cant afford to buy extra materials. Could you please share me practice questions? It would be really helpful. Thanks!
Clear, Easy, Simple. You really made me feel confident about this. Thanks a bunch
This is much better than the boring 20 hour course i followed on Udemy.
This is Absolute GOLD. Thank you Luke and Kelly for providing us with this for anyone. You Guys are awesome!!
Something is strange here: this course is working for me. Something is magically not right. Thank you Luke!
🙌
Thank you Luke. You made video just in time that I’m looking for SQL full deep dive course. I used to learn Data science boot camp before, but the boot camp just provided SQL basic thing and course time limit
Thanks for doing this ! My SQL skillset was thouroughly refreshed 👍
I recently started working with Tableau and had troubles understanding how to query our database for data. This is incredibly helpful, and your teaching style is admirable. Well done and thank you.. you're changing my life at my job!
I was looking for a SQL tutorial from a professional data analyst and here it is..🎉
Will start soon..
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.
Heck yeah! Appreciate the feedback Jay! Glad to hear you'd recommend it!
Hey jay,
what's your thought on 60+ practice problems.
I'm thinking to purchase to practice more but 25$ is lot for me in India.
Can you advise me what should I do or if possible ,share practice problems with me?
I found this particular course really helpful, and want to practice more.
Thank you
Thank you so much @LukeBarousse for the amazing content on Python, SQL, and Excel! Your tutorials have been incredibly helpful in my journey to becoming a data analyst. The step-by-step explanations and clear examples make complex topics much easier to understand. I truly appreciate all the effort you put into creating these resources. Keep up the great work - you're making a huge difference for so many of us learning these skills! 🙏
I'm learning to be a data analyst and this course has been great. Thanks Luke.
It’s only 25.usd to support, that’s a small contribution, happy to “help” but it’s you helping the world. Hoping you’ll find the time to do this also for Python, love to follow that one as well. Keep on doing what you are doing, thanks Luke!
A few minutes in, I am already excited. Can't believe how excited I am. Thanks for taking the time
Thank you Luke, I can say awesome tutorial before watching! appreciate it
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!
I hanged it to hours_spent - 8 AS extra_hours and it works okay.
Glad that someone else also noticed this problem
@@anka67173 Arguably the easiest solution...
I subscribed after 30 mins of watching and learning from your video. I most recently decided to change careers and thusfar this has been the most productive learning SQL video I've come across. I will be purchasing the supporter resources. ✨ Thank you!
Whoever is making your RUclips thumbnails is doing a stupendously great job 👏
30 minutes into your video I subscribed. I've recently transitioned careers to become an Data Analyst and this has been the best teaching of SQL video I've come across.
I will be purchasing the supporter resources ✨. Thank you!!
Thank you Luke. Took me around a month to finish this but now I know SQL very well!
Only video on youtube for advance SQL queries. Really helpful
Ive been working as an analyst for over a year now and I keep learning new things everyday thank you Luke.
This is the best video of sql that i found and i searched a lot. Thank you!!!
Hey! From Brazil here, please make more of those videos bro, they´re better than most expensive courses that we have here ! Thanks!
Amazing content! This course is exactly what I was looking for, can't thank you enough !
Thank you so much for this amazing tutorial Luke.
Thank you Luke. I am going to (hopefully) get my first data job analyst thanks to you. I just have to continue putting the work. Thanks a lotttt!!
32:25 the pnemonics i'm using is
Some =Select
Delusional = Distinct
French = From
Waiters = Where
Grow = Group By
Healthy = Having
Orange & = Order By
Lemons = Limit
I was waiting for something like this !!!!! That's what I and all of us will ever need to understand the SQL. I was at coursera, udemy, but it cannot compare with this masterpiece. Just practise !
Thank you!!
That's a very helpful content. SQL is easy as someone from an engineering background dealt with SQL for a few months I thought I'm still a beginner, but as I skimmed through this video I found I already know everything. All by practicing real case problem solving and self-learning.
Just want to say that I think that your teaching and editing style for this SQL course was very effective.
Clear teaching and nice editing, transitions and course structure.
Might be the most effective course that I've gone through yet.
Thanks David!!
Thank you for posting this video, Luke. I appreciate your hard work! I bet it took you ages to edit this!
Ha! Actually had to hire an editor to help edit this; way more then I could handle
This is what I wanted all my life
01:53:21 The manipulation part where the following code has been inserted, feel free to copy and paste:
INSERT INTO job_applied (
job_id,
application_sent_date,
custom_resume,
resume_file_name,
cover_letter_sent,
cover_letter_file_name,
status
)
VALUES (
1,
'2024-02-01',
true,
'resume_01.pdf',
true,
'cover_letter_01.pdf',
'submitted'
),
(
2,
'2024-02-02',
false,
'resume_02.pdf',
false,
NULL,
'interview scheduled'
),
(
3,
'2024-02-03',
true,
'resume_03.pdf',
true,
'cover_letter_03.pdf',
'ghosted'
),
(
4,
'2024-02-04',
true,
'resume_04.pdf',
false,
NULL,
'submitted'
),
(
5,
'2024-02-05',
false,
'resume_05.pdf',
true,
'cover_letter_05.pdf',
'rejected'
);
i was wondering why my code wasn't being executed properly
The best video for learning SQL, that I have watched so far... thank you Luke... ;)
I was literally gonna start learning SQL within an hour. Well, no excuses now.
Me too! gotta put the work now
None lolz
This course has been really helpful to me. I am at a point where I need to take my data analysis skills to the next level and I would not have been able to learn without this course. I have reached the advanced level and I am really learning. Thank you so much. I encourage everyone to purchase this course and do the exercises ;)
Everyone purchase the additional resources to support Luke work please.
Appreciate the shoutout Tess!
Ok although I'm not a beginner I'm still going to watch this because yeah, I've been waiting for you to release this.
You need to do more courses really. There are a lot of these course out there yes, but to me, I believe in YOUR skills and YOIR knowledge so I would love to watch your course. I enjoy your way of teaching a lot. so this video means a lot to me. You're amazing for putting this out for free. I'm planning to switch careers again soon and when I do, I'll be joining to help pay yoir bills lol. Anyway, much respect !
Keep up the good work.
Thanks for the kind words!! 🙌
Dear Luke, I am very happy that you shared this free training. Thank you very much and I am grateful. I am waiting for a similar Python course.🥰
Python coming soon!
Just wanted to add a comment and say this along with your other videos are superb! Great learning opportunity for everyone.
Probably one of the best 25$ i spent in my entire life. Problems are harder than capstone project itself and you also greatly outlined all the important topics and introduction to the github. Really appreciate Luke, thank you and Kelly for your amazing work!
Thank you for enabling download so I can watch this with no internet while at work. Bless you Luke!!
Any time!
Sorry for asking, Please but how were you able to download this video on youtube?
@@amagwen7528 yes on youtube. Not really downloading the and savw it somewhere else. It allows you to play the video while offline. Download button is found under the video.
Can I use POPSqL on this course? Thank you Luke for making this course available
Holy cow, need to set aside some time to walkthrough this beast! thanks Luke
Thank you soo much Luke
God bless you for your wonderful efforts
Also the starting tune 1:09 is similar to the tune Played in Indian Railway Station
I was thinking to learn sql today and you dropped this like what are the chances damn. Thank you
Thank you for taking the time to Share. Wish I had this video years ago in my IT youth!
Full outer joins I use to troubleshoot organic key mismatches, I can see which ones didn’t link from either table and diagnose the failures
Such a good course and project! Really appreciated!
This is incredible! Thank you so much!
Thanks for this content. I'm using this as a refresher course after learning SQL last summer as part of a data analyst bootcamp. The job market is difficult in my region (South of France) but I've got to keep "buggering on" 😅 if I'm going to land a job...
Excellent and useful work, Luke. Thank you so much for providing all this.
Thank you so much for this great video. I wanted to start learning SQL and it was kind of scary for me, but you explained everything with great detail and everything was perfect.
Currently on Project 5. I really enjoyed watching and doing the projects. It wasn't all smooth but it came out nicely
@LukeBarousse, many thanks for doing this. I have been following through the video/course but I have encountered a problem. When I published the repository to Github, I cannot see the folders sql_load on Github. Furthermore, when I did the push example "project_sql (query_1.sql)" the vscode output shows "No remote found in the git config file" error message and I am not sure how to resolve this. Any guidance would be appreciated. Thank you.
So I bought his course love it. And will buy python course from him. Is there anyone else that does this or makes courses like him other than Coursera which I also have done. Like the 60+ problems are so great just want more in excel and power bi
Starting to learn sql and this just comes very handy at the right time!!
Great job, thanks, Luke, so helpful. I am the PM and going to include SQL into my resume.
How is this FREE?!? Holy moly, this is fantastic. I've been looking into Data Analyst stuff this evening (looking for career change/expansion) and you and this course were referenced in two different places I ended up. And I can see why.
And your "paid" stuff is $25??? THANK YOU for what you're doing.
Dude! halfway through this course. I love the depth and detail you and Kelly have put into this course! I also like that you use VS Code for the second part of the course. I will be setting it up to learn Python when your Python course is out. Please continue making courses of similar quality and depth. I will be buying them as soon as they are available.
Hi Luke! Thanks for the great content! I got a question as I approach toward the end of this video. I need an explanation on why even though the group by clause does not contain the column "skills", the query works normally without any errors in postgre sql. I know that whatever is in the select statement besides aggregate functions, must be in the group by statement too.
ChatGPT gave me some insights on this like "In PostgreSQL and some other database systems, there's a feature called "functional dependency" or "functional determinant" that can allow a query to execute successfully even if the GROUP BY clause does not explicitly include all non-aggregated columns from the SELECT clause".
I do get the understanding that even if this works here because "each unique skill_id corresponds to only one skills value" , this is something to be avoided when querying databases as it is likely to give us back an error. Please provide some feedback!
Thanks so much Man
your content is fresh and pure gold love you man !
for quarters of a year, try extract(quarter from ........) = 2 for example for second quarter (filter second quarter) instead of extract month and check if it is between ... and ...
Luke, THANKS FOR THAT!
You guys did such a great job.
We’ll never be able to express our gratitude enough 🎉🎉
Such an amazing way to hone my SQL skills 💪🏻
Thank you so much for this great video. Really enjoy the 4 hours ride. Much of beneficial knowledge to gain. Enjoy every single second of the video.
i must say that i learned more form this video than the google analyst, w3school and udemy, yeah, i've tried everything, still recommend but this is a more realistic approach, thank you, you're great
Great to hear!
Great content and so generous of you to make it free!!! Bought your notes & problem sets to support. Looking forward to more interesting contents🤩
I really like your courses Luke and decided to take a look at this, regardless of being an SQL professional for ~18 years. I am still getting a headache whenever I see joins written like this:
SELECT ...
FROM a
LEFT JOIN b ON a.column = b.column
It should be:
LEFT JOIN b ON b.column = a.column
Still I cannot comprehend how with complex join conditions spanning multiple rows one keeps referencing the first table on the right of the expressions without a cringe :)
1:30:40
who gets error when installing POSTGRESQL, do not check 'default locale'. Instead, choose something like 'United States English'. For some reason, the default doesn't work.When prompted for locale, do not check 'default locale'. Instead, choose something like 'United States English'. For some reason, the default doesn't work.
Hi Luke,
I hope you're doing well. I was reviewing the SQL query and I came across something that I think might be a mistake. You suggested using AND in the WHERE clause at 53:00 to filter job titles containing 'data', 'business', 'analyst', or 'Analysis'. However, based on my understanding, it seems like using OR than AND at the part '%Analyst%' would be more appropriate for this scenario to match any of these keywords and it really confused me but anyways I've learnt a lot from you and you might be the best instructor I've watched at RUclips regarding in SQL.❤
Got my Sunday covered for this week!!
Looks good. Made perfect sense to me, but I am concerned about beginners.
Fortunately you keep saying "we will come back to this later", if beginners can set aside panic, this should be a very rapid, but thorough introduction to SQL. Future versions may want to mention a path from SQLite to DuckDB. Although SQLite is standard now, DuckDB has targeted analytic workloads (CSV) as opposed to transactional workloads (forms). DuckDB SQL is also closer to Postgres SQL (built with Postgres interpreter). DuckDB has amazingly fast loading of CSV files and SQL SELECT queries!
Please keep linking this, so I can come back once I am done with my Google Data Analytics Certificate.
Than you for the course Luke. I am a little confused though. In the operations section at around 59:22, you included a column alias in the where section, but if we follow the order of execution, the extra_hours column should not exist. I am using Postgres inside VSCode and it gives me a column does not exist error, yet, in the SQLiteviz, it does work.
To stay consistent with the order of execution, would it not be better to include the operation in the WHERE clause. I am new at this, so I might be missing something. Thank you. Also, sorry if you mentioned it and I missed it.
WHERE
(hours_spent BETWEEN 8 AND 16) AND
hours_spent % 8 > 0
One of the best course I met around😍 Thanks @Luke
Thank you Luke. This is a very helpful video. I have learned a lot from it.
2 mins in and i already love you! thank you brother Luke