Complex SQL Query: Watch Me Write It
📝 Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpk...
🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql...
If you need to write an SQL query and you think it will be pretty complex, don't fear!
Writing a complex SQL query is about starting small and iterating until you get the result you want.
In this video, I'll demonstrate a problem that needs to be solved with SQL, load some sample data, and write the query step-by-step.
The demo is shown in MySQL, but the concepts can be applied to any SQL database.
Hopefully you can use this approach with your own complex query.
If you like this style of video, let me know in the comments below.
⏱ TIMESTAMPS:
00:00 - What we will cover
00:29 - The problem
01:45 - Create tables and sample data
03:34 - The first SELECT query
07:56 - Finding the top scores
09:53 - Changing what we see
13:40 - Advice if you want to do this yourself
🔗 VIDEO LINKS:
GitHub script for sample data: https://github.com/bbrumm/databasesta...
HackerRank question: https://www.hackerrank.com/challenges...
On this page of the site you can watch the video online Complex SQL Query: Watch Me Write It with a duration of hours minute second in good quality, which was uploaded by the user Database Star 24 January 2023, share the link with friends and acquaintances, this video has already been watched 7,617 times on youtube and it was liked by 272 viewers. Enjoy your viewing!
