Good day, dear people!

In general, soon I will have to study SQL queries very closely, please advise books / manuals, where do I start this business?

I have not been in this area for a long time, I need a certain IDE to write a request and it graphically shows that I’ve been there (tables, connections, views, etc.) - is there such a thing? If so, which one is better? (paid / free - does not make a difference)

For earlier thanks for the advice :)

Closed due to the fact that off-topic participants Nick Volynkin ♦ , Aries , Visman , tutankhamun , BogolyubskiyAlexey 21 Sep '15 at 8:11 .

It seems that this question does not correspond to the subject of the site. Those who voted to close it indicated the following reason:

  • " Questionnaires are forbidden on Stack Overflow in Russian . To get an answer, rephrase your question so that it can be given an unambiguously correct answer." - Visman, tutankhamun, BogolyubskiyAlexey
If the question can be reformulated according to the rules set out in the certificate , edit it .

    3 answers 3

    Not much I did not understand exactly what you need, I will show with the example of MySQL.

    1. Download Workbench ;
    2. Download XAMPP [or something else];
    3. Install Workbench and XAMPP;

    4. Go to XAMPP to enable MySQL [Figure 1]; alt text

    5. Go to Workbench, create a new connection [Figure 2]; alt text

    6. Create queries [Figure 3]. alt text

    • Without XAMPP, over, muskul with a workbench can not be put ...) - Nofate ♦
    • @Nofate, I just wrote what I use myself, because it is more convenient for me. It is possible to paint all possible options, but it seems to me that this is not in this question, here we are talking about how to deliver something, and start writing requests. For I did not understand the question. - Zarochintsev
    • @ Kovalsky, thank you very much, everything worked fine, I am already starting to "code", in general, what I need, I was pleased that Apache can also be revived with one program, generally cool :) - Sashko

    You should start with relational algebra and other fundamental principles. Then there will be an understanding of what is happening and visualization is not required.

    From the literature I can recommend Database systems. Full course . It seems to be even fresher edition .

    • What kind of fashionable are I, what would I write there to “create a table” with such fields, etc and what would it be displayed graphically? - Sashko
    • Requests? Microsoft Access. - vkovalchuk88
    • Under different DBMS different IDE. For example: - Under MS SQL Server - MS SQL Server Management Studio. - Under MySQL - MySQL Workbench seems to be. - Nofate ♦
    • one
      if IDE, to hashcode.ru/questions/226645/… - Vfvtnjd

    Online Resources:

    SQL Interactive Tutorial

    SQL exercises