Choosing a Database: PostgreSQL, MySQL, Mongo, and Cloud

Focused View

Amataverna Lee

1:21:12

0 View

01 Introduction

001 Choosing the right data platform.mp4

01:15

002 Comparing database options.mp4

01:37

003 Setting up the environment.mp4

02:46

02 PostgreSQL

001 PostgreSQL explore.mp4

07:51

002 PostgreSQL commands.mp4

08:18

003 Inheritance and data types.mp4

04:27

004 Features.mp4

03:19

03 MySQL

001 MySQL explore.mp4

01:12

002 Dialect nuances in MySQL.mp4

07:01

003 MySQL Workbench.mp4

05:32

04 Mongo

001 Mongo explore.mp4

04:44

002 Dialect nuances.mp4

06:46

003 Mongo tools.mp4

06:08

05 Cloud-Based Databases

001 Snowflake.mp4

01:16

002 Snowsight by Snowflake.mp4

07:01

003 Amazon Web Services.mp4

02:09

004 Amazon Redshift and S3.mp4

06:57

005 Google Cloud Platform.mp4

01:25

06 Conclusion

001 Recap.mp4

01:28

Description

There are a lot of different databases out there with their own pros and cons. It’s important to know what your options are. In this course, instructor Amataverna Lee covers PostgreSQL, MySQL, Mongo (a NoSQL database), and several cloud-based databases, to help you choose what will be best for you. You’re likely to encounter PostgreSQL in your career, so it’s important to be familiar with this type of database and how it differs from other types. MySQL is one of the most popular SQL dialects used today, so this is another important one to understand. Amataverna introduces you to Mongo, a nonrelational database that does not use SQL, and shows you some tools that you would need to use in Mongo. She also goes over several popular cloud-based options: Snowflake, Snowsight, Amazon Web Services (Redshift and S3), and Google Cloud Platform. With an understanding of these options, you can make a more informed choice on what is best for you.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

MongoDB

PostgreSQL

Cloud Computing

Amataverna Lee

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.