What book on databases to choose?

I want to get a response from the person who is proektirovaniem databases, and who loves their job. If you vaguely know what it is, or used a few times please refrain.

Need a book almanac, where you can get real the knowledge you need to start.
July 2nd 19 at 18:08
6 answers
July 2nd 19 at 18:10
knowledge from beginning to end

When I was just starting to get acquainted with SQL in parallel with this documentation www.mysql.ru/docs read a book SQL for dummies https://www.ozon.ru/context/detail/id/29482320/
After practicing on several projects with the complicated structure of the database (this is important) I bought a book for high availability systems based on MySQL https://www.ozon.ru/context/detail/id/7353438/ there's even contents can be understood that this information is fundamentally different level to any other level of readiness.
Along with all this it would be nice to see ruhighload.com/server/%D0%91%D0%B0%D0%B7%D1%8B%20%...

involved in database design

For that would be good to design it is desirable to understand how it works from the inside, because the books do not always write about the shortcomings of the technology and pitfalls. This will help you, for example, VIDOS with conferences, for example, Andrei Aksenov (Creator of Sphinx):

Next is in DB, it is possible to see, for example PostgreSQL
Docks: www.postgrespro.ru/doc
Team https://www.commandprompt.com/ppbook/
Installation developer-remarks.blogspot.ru/2012/07/postgresql.html
About pgadmin developer-remarks.blogspot.ru/2012/07/postgresql-p...
Official site pgadmin www.pgadmin.org/index.php
How to get started with PostgreSQL https://habrahabr.ru/post/301808/
Indexes in PostgreSQL and MySQL https://habrahabr.ru/post/302706/
Old book postgresql.leopard.in.ua/html
Hacking PostgreSQL https://www.youtube.com/playlist?list=PLaFqU3KCWw6...
Administration https://www.youtube.com/playlist?list=PLaFqU3KCWw6...

To support all this you can meet other resources:

Why uber switched from postgresql to mysql https://eng.uber.com/mysql-migration/
Differences from MySQL PostgreSQL eax.me/postgresql-vs-mysql
The basics of replication habrahabr.ru/post/56702
The differences between PostgreSQL and MySQL (an old article, 2010) www.ibm.com/developerworks/ru/library/os-mysql-pos...
Very detailed and interesting, thank you. - Demarcus64 commented on July 2nd 19 at 18:13
What a delightful article "Why uber switched from postgresql to mysql"! Starting with the title of the class "Scientist raped journalist" :) Uber is not moved to MySQL, they developed their own decision - Schemaless, for which MySQL is the backend. Yes, is better than PostgreSQL, as used in the form of key/value-store. The article has a great answer. Very detailed and very polite. But the General sense can be reduced to the fact that the programmers are Indians Uber'not mastered all the standard SQL:2008, and decided to confine it to a subset of the SQL-92 standard and a simple DBMS, forgiving stock settings and errors in queries. - samir39 commented on July 2nd 19 at 18:16
: Thanks for the complement, I was expecting that someone will notice and comment on this link )) 'll be happy to read the response to the article. - Abdullah commented on July 2nd 19 at 18:19
July 2nd 19 at 18:12
Here is the book that suggest mega Pro to explore the database, honestly haven't gotten to her, but she's in the queue:
K. Dzh. J. date - Introduction to database systems.
July 2nd 19 at 18:14
I was reading in the University this forcoder.ru/sql/professionalnoe-rukovodstvo-po-tra...
I had enough of it (and of the course database at the University) to understand the basis of all designs. Started with MS SQL. Take from below, not 2008 R2. Express fit.

Well, then the documentation for the appropriate DBMS. Vaughn Dmitri described a ton under muscul.
Understand at once, there is the ANSI SQL standard and have many implementations (DBMS). Duck's implementation is not always standard, not always in full and always with some of its bells and whistles.

So anyway you need to learn standard dialects (specific implementation).
The standard is called ANSI SQL. But T-sql is the implementation by Microsoft. - Demarcus64 commented on July 2nd 19 at 18:17
: Yes, sorry. it was not right. - samir39 commented on July 2nd 19 at 18:20
July 2nd 19 at 18:16
Mysql Oreally
July 2nd 19 at 18:18
DBMS for the programmer. Databases from within Author:Sergei Tarasov

A great book
July 2nd 19 at 18:20
I like these:
1. Bill Carwin - Programming SQL DB. Typical errors and their elimination
2. O RELLY - MySQL. Performance optimization
In addition, they are in Russian

Find more questions by tags Databases