V
V
Valeriu Vodnicear2019-03-01 02:40:03
PostgreSQL
Valeriu Vodnicear, 2019-03-01 02:40:03

How to learn PostgreSQL?

How to learn PostgreSQL if I have been working with MySQL for 5 years?
If you have good video materials in Russian, please share the links.
I installed PostgreSQL and PhpPgAdmin on the server, I also created the database.
I noticed that the data types are much larger than in MySQL.
And in general, there is more functionality.
MySQL learned from the course from WebForMySelf, if there was such a course only for PostgreSQL it would be great.
It's hard for me to understand the documentation only, I watched the reports from HighLoad.

Answer the question

In order to leave comments, you need to log in

6 answer(s)
Y
Yerlan Ibraev, 2019-03-01
@vodnicear

The easiest and cheapest option is just to read the official PostgreSQL documentation.
Written simply and to the point, without water.

M
Melkij, 2019-03-01
@melkij

MySQL learned

You know, even an experienced DBA can be really surprised by something that has been in the database for ten years.
Therefore, the phrase "MySQL learned" is not perceived as something other than an admission of ignorance. I have been working with mysql for many years, it turns out to be the top3 user for this tag on the toaster. Do I know mysql? Nothing like this. Even the source opened only 1 time.
What meaning did you put in the phrase "MySQL learned"? How can it be learned?
Is this the reprint that describes functionality that mysql still doesn't know how to do? mysql_query when no such extension exists in PHP at all?
I hope 5 years ago when you studied it was more decent.
As a sightseeing tour of the PostgreSQL device, I can recall a good lecture by Vladimir Borodin , look for Ilya Kosmodemyansky's notes.
The manual at least once must be read from beginning to end
And practice. Without a manual, you won’t know what opportunities there are, without practice, you won’t understand how (and, by the way, why) to use them.

S
sim3x, 2019-03-01
@sim3x

Translation material https://postgresql.leopard.in.ua/html/
But better of the docks

A
Artem Cherepakhin, 2019-03-01
@AltZ

Start with https://postgrespro.ru/education/courses

N
Nick V, 2019-03-01
@half-life

https://postgrespro.ru/education/courses/DEV1

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question