Learn pros, cons, and options for different databases: PostgreSQL, MySQL, Mongo (a NoSQL database), and several cloud-based options.
Overview
Syllabus
Introduction
- Choosing the right data platform
- Comparing database options
- Setting up the environment
- PostgreSQL explore
- PostgreSQL commands
- Inheritance and data types
- Features
- MySQL explore
- Dialect nuances in MySQL
- MySQL Workbench
- Mongo explore
- Dialect nuances
- Mongo tools
- Snowflake
- Snowsight by Snowflake
- Amazon Web Services
- Amazon Redshift and S3
- Google Cloud Platform
- Microsoft Azure
- Recap
Taught by
Amataverna Lee