# 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>