7 Mistakes Beginners Make with SQL

Опубликовано: 19 Апрель 2022
на канале: Database Star
19,695
583

📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-...
🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql...

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


Смотрите видео 7 Mistakes Beginners Make with SQL онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Database Star 19 Апрель 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 19,695 раз и оно понравилось 583 людям.