Should I learn SQL before PostgreSQL?

Question

Even though you may have never heard of these words, you'll have to use those concepts at some point. I strongly suggest you to start with PostgreSQL, then you can learn what "real" SQL is. Then, you can decide if MySQL is sufficient or not. 30 окт. 2010 г.

Should I start with SQL or PostgreSQL?

If you want to learn something that has the greater market share in hopes of finding more works easier, then MySQL would probably be a good choice. It's still open source, does a good job with relational models. If you want to learn something about ANSI SQL, Postgresql would be your best choice of the three.

Should I learn PostgreSQL or MySQL first?

In general, PostgreSQL is best suited for systems that require execution of complex queries, or data warehousing and data analysis. MySQL is the first choice for those web-based projects which require a database merely for data transactions and not anything intricate.

What should I learn before PostgreSQL?

Postgress is mostly a relational database. So you would need to learn a little about databases in general, what's the difference between relational and non-relational (a.k.a. noSQL) and how that applies to Postgress (e.g. Is Postgres NoSQL Better Than MongoDB? )

Which is better SQL or PostgreSQL?

But when it comes to different features PostgreSQL is always at the upper hand. It is an advanced version of SQL and hence provides many additional features. All these features are for free, unlike SQL server. Also, it is cross-platform and can be used with any operating system.

Expert · Answer