How to practice SQL, MySQL?

Question

MySQL

I want to start learning SQL, along with this, take such a DBMS as MySQL. What literature can you recommend? It is desirable that there was practice immediately. I found Gramer's book "Understanding SQL" and I can't figure out how I understood the theory, but how do I put everything into practice? As far as I know, you need a DBMS, for example, MySQL. I found the site mysql.ru, there was a FAQ, where there was a link to download the DBMS, downloaded, in the end, it turned out that everything happens in the console - is this the norm or are there any environments for this business? I'm not familiar with these databases at all, can someone poke their nose at what to download and install? I'll install MySQL, what's next? It would be ideal if you could share a resource where such things will be described in detail.

Answer 1

Here you can practice sql-ex.ru

Answer 2

You can try our sql courses at https://ru.hexlet.io/categories/db/courses Each lesson has practice in a real environment.

Answer 3

Learning SQL And it was convenient for me to write / study queries in IntelliJ tools. (PHPStorm, PyCharm, IDEA, depending on the programming language) There, auto-completion works, and hints and database structure can be viewed immediately.

Answer 4

I recommend downloading from here:
dev.mysql.com/downloads
You need to download MySQL Community Server and MySQL Workbench.
Install test bases during installation and go...

Answer 5

CodeCademy SQL Course - theory with practical tasks, course length 2-4 hours.

Answer 6

I studied at www.chtivo.ru/book/1307630
Very light, clear, understandable.
Installing and configuring MySQL is described in detail.
Threat I was pleased that for the entire time (about a month) of "passing" the book, the mysql process (I did not turn off the laptop, but fell asleep) consumed only 1 second of processor time.

Answer 7

>> I found the site mysql.ru, there was a FAQ, where there was a link to download the DBMS, downloaded, in the end, it turned out that everything happens in the console - is this the norm or are there any environments for this business?
Norm, there are many clients / ide for comfortable work with any sql. For example, for free mysql it is heidisql . From commercial - this is a recently released IDE for working with various sql datagrip from JetBrains, but it probably shouldn't be used yet - first figure out "what's what".
Actually, about download / poke, etc.: ideally (since you are on win), then either put yourself some kind of openserver or denver - there will be everything you need right now, and the guide is exhaustive. Well, or you can put Linux on a virtual machine, install mysql (mariadb) normally there, and on Windows, through the same heidi that I wrote about above, connect to the virtual machine and voila! All this is elementary googling. If I were you, I would choose the second option ;)
In other words, do not underestimate the console: if the whole thing drags on, you will have to work in it from time to time, and, possibly, regularly.

Answer 8

If SQL practice is important to you, just google "SQL practice". My first link was proglib.io/p/sql-practice-sites . And look at some online courses kursfinder.ru/sql/. Stepik, Coursera, LABA seem to have free programs and with practice, you can practice.