Complex SQL Query: Watch Me Write It
6.3 هزار بار بازدید -
2 سال پیش
-
📝 Get my free SQL
📝 Get my free SQL Cheat Sheets: www.databasestar.com/get-sql-cheat-sheets/?utm_sou…
🎓 Learn and become confident in SQL: databasestar.mykajabi.com/sql-simplified/?utm_sour…
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: github.com/bbrumm/databasestar/blob/main/videos/76…
HackerRank question: www.hackerrank.com/challenges/full-score/problem
2 سال پیش
در تاریخ 1401/11/04 منتشر شده
است.
6,365
بـار بازدید شده