Dear friends!

Advise on how best to start learning about the SQL database environment, if you already have experience in programming. =) Thanks a lot.

Sincerely, DataRs.

Closed due to the fact that it is necessary to reformulate the question so that it was possible to give an objectively correct answer by the participants Nick Volynkin ♦ , aleksandr barakin , Aries , ermak0ff , Visman 21 Sep '15 at 7:11 .

The question gives rise to endless debates and discussions based not on knowledge, but on opinions. To get an answer, rephrase your question so that it can be given an unambiguously correct answer, or delete the question altogether. If the question can be reformulated according to the rules set out in the certificate , edit it .

    4 answers 4

    Here you can read, here you can decide. For starters - quite to yourself;)

    • one
      And not for starters, too, quite to myself. :-) - msi
    • one
      hehe) I sent 200 donations there in due time; D - Tim Rudnevsky
    • one
      @Tim Rudnevsky Resource is free, evolving. So do not regret. :-) - msi

    Think of some small, for a start, subject area and formalize it as a database:

    • Iron or software list
    • Artists and albums
    • Phonebook
    • Price list
    • cookbook
    • D & Ds monster / spellbook

    In general, anything with which you are familiar, and that will keep you interested. Make a database wrapper in the language in which you have experience. Fill the base. See what you can add. Gradually increase the functionality. Think up what kind of reporting and statistics can be collected by the database (in any data set you can calculate and group something).

    Perhaps the easiest thing to start is to understand this with MS Access. Here and ready designers of forms and reports. If you program confidently, then you can write right away in your own language. In this case, choose a DBMS: MS SQL, MySQL / MariaDB, PostgreSQL. If you are afraid to immediately contact the database servers, there is a simpler file DBMS: SQLite, DerbyDB, H2.

    Be sure to learn the theory. Just now there was an open Stanfood course on databases , if you are not afraid of English, I highly recommend it. Or a textbook in Russian from the same professor: Database systems. Full course . If you immediately master the theory of relational databases, then you will ask less trivial questions here. )

    Successes.

      I mastered SQL on the basis of Ms Access from Office 97. There was a complete and understandable help in Russian, and in their SQL constructor it is even easier to understand!

        You can also start with the SQLite database there is a fairly simple syntax, I also advise you to start by reading the book "SQL" by Martin Graber. It is very simple and clear.