📝 Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpkj-sql-cheat-sheets/?video=zuE-ICxf03k
🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql-simplified/?video=zuE-ICxf03k
Learning SQL can be hard with the number of places to learn from and the functionality of the language.
As you learn more and get more experienced, you realise some of the things you learned when you were a beginner weren’t the best way to do something.
But what if you're a beginner?
What are those things you should avoid?
In this video, I’ll explain 7 areas or mistakes that I see being made as a beginner, why they should be avoided, and what to do instead.
Timestamps:
00:00 What are we learning?
00:27 Mistake 1 - Using SELECT *
02:48 Mistake 2 - Writing one query per table
03:51 Mistake 3 - Not using functions
05:13 Mistake 4 - Using reserved words for table and column names
06:30 Mistake 5 - Not using WHERE with DELETE or UPDATE
08:17 Mistake 6 - Comparing with NULL using =
09:03 Mistake 7 - Not saving queries to use again
