https://www.postgresql.org/docs/current/tutorial.html https://pgexercises.com/ https://www.postgresqltutorial.com/ More on reddit.com

I have learned a lot from this book. To me, it is masterpiece. Dimitri not only teach Postgresql but also he teaches SQL. https://theartofpostgresql.com/ Highly recommended. The other masterpiece is Markus's book: https://sql-performance-explained.com More on reddit.com

The first thing you'll probably notice is surface level stuff. If you're used to the CLI, there are plenty of differences: No "show create table" etc, just use \d and related shortcuts. Then you might find case sensitivity works differently. Postgres values are case-sensitive by default, but identifiers are all folded to lower case and the original case is not preserved. If you were used to camelCase or PascalCase identifiers before, don't try to fight it and just adopt snake_case. Hopefully you were running MySQL in strict mode or there will be more surprises like this. Single quotes and double quotes work differently. doubles are for column names, singles are for literal values. Placeholders are different, ? vs %. Query plans (explain select ...) will look different but you'll get used to it. https://explain.dalibo.com/ helps. Postgres doesn't have different storage engines, but InnoDB is closest to Postgres. MySQL is just slightly more efficient for primary key lookups than for secondary indexes. For Postgres, it doesn't matter. Postgres adds a lot of features around JSON and full text search that you should read up on. It can change the way you approach schema design problems. Some things that MySQL couldn't use an index for, Postgres can (including LIKE queries). Don't use varchar anymore. Postgres' TEXT columns are faster and practically unlimited in size. There's actually a whole lot of "don't do that anymore" notes here: https://wiki.postgresql.org/wiki/Don%27t_Do_This I created a GPT for leveling up on Postgres. It might be helpful to you: https://chat.openai.com/g/g-uXYoYQEFi-sql-sage More on reddit.com

https://postgrespro.com/community/books/internals Just base stuff is covered (no extensions etc), and version 14 is not the last one, but the book is free and it explains internals in great detail. I also made a similar jump some time ago. Remember there's no single do-it-all tool like SSMS (pgadmin may look like it, but you'll quickly discover it is not). For backups take a look at PGBackrest. Pay attention to MVCC and Autovacuum - these are arguably the most important differences. More on reddit.com