👨‍💻Databases

I'm planning to go back to SQL databases for better long-term benefits such as complex analytics queries where NoSQL technologies might have hiccups.

Why Postgres?

• Better on complex queries

• Perfect for enterprise

• Open source

Why MySQL?

• Great for web apps

• Ease of use

• Optimized

• Small to Medium

• Owned by Oracle

Tutorials

📽️ Set Up a Postgres on Amazon RDS with PGAdmin: https://www.youtube.com/watch?v=XDMgXZUfa10

📽️ Set Up a Postgres on Amazon RDS with DBeaver: https://www.youtube.com/watch?v=XF1ZADfH0EQ

📽️ Creating an RDS PostgreSQL Database on the AWS Free Tier: https://www.youtube.com/watch?v=I_fTQTsz2nQ

📽️ AWS RDS vs AWS Aurora for MySQL: https://www.youtube.com/watch?v=yHCwjAbwS6M

📽️ AWS RDS vs AWS Aurora for Postgres SQL: https://www.youtube.com/watch?v=rQlp2PzklYE

Comparisons

📽️ MySQL vs Postgresql vs Microsoft SQL Server by Alex The Analyst: https://www.youtube.com/watch?v=Q7i6zxHVj2Q

📽️ SQL vs NoSQL: https://www.youtube.com/watch?v=ruz-vK8IesE

📽️ SQL vs NoSQL: https://www.youtube.com/watch?v=t0GlGbtMTio

📽️ PostgreSQL vs MySQL: https://www.youtube.com/watch?v=btjBNKP49Rk

📽️ How to Choose a Database on AWS: https://www.youtube.com/watch?v=eK_umMYxZfM