What are the best resources for learning SQL?

Question

MySQL

Please advise resources for learning SQL - tutorials, resources, video tutorials.
Previously, I took a course at codeacademy - it turned out to be not enough information. At the moment I use sql-ex.ru.

Answer 1

1. Create a test database with 2 tables: company and products.
2. Fill it with test data for 5-10 lines.
3. Manual for MySQL.
Only by applying something you will receive such knowledge that you can use in practical life. Everything else is air.
PS Advise books Welling and Thomson. Personally, I haven't read it. I watched the MySQL Specialist courses, but they are also sooo rich and redundant for beginners.

Answer 2

You can look at books on ozone on SQL, but again, the implementation of the SQL standard itself differs in different DBMS, so you must first select the database with which you will work and then learn SQL specifically for this database.

Answer 3

SQL is basically normal forms. Those. you need to understand how to avoid duplication of data and when it is appropriate, and when it is not appropriate and a denormalized database will do.
Any book (even the smallest one) that deals with normal forms will do.
You can look at these articles on database design
https://habrahabr.ru/post/193136/

Answer 4

> video tutorials
off docks!

Answer 5

I can recommend a good blog with useful articles about SQL Server, there is information for both beginners and experienced users https://codingsight.com/