Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Database - MySQL, PostgreSQL, RDS & Aurora
Welcome
What to expect in this course
About the instructor
Resources
Module 1 Part 1: Pre-Requisite and Resources
General Information
System Requirements
How to create AWS account? (5:13)
Account Creation
How to create billing alerts? (6:59)
Budget Notification
Budget Creation (3:51)
How to use Chime (3:48)
Module 1 Part 2: AWS IAM Fundamentals- IAM User, Group, Policy and Role
IAM Fundamentals (59:22)
IAM Identities and Policies (51:49)
Singing In to AWS Management Console (10:21)
IAM Identity - User (66:54)
Lab 1: IAM Users
IAM Identity - User Group (54:09)
Lab 2: IAM User Groups and Users
Module 1 Part 3: AWS Fundamentals
AWS Infrastructure (15:43)
AWS Public & Private Services : S3 + EC2 (18:07)
Revision
Lab 1.1: Region
Lab 1.2: S3 Basics
Lab 1.3: EC2 Basics (22:22)
Module 2: MySQL Introduction
MySQL Client Server Architecture
Installing MySQL
Lab 2.1 - Installing MySQL 8.0
Connecting to and Disconnecting from the Server
Lab 2.2 - Accessing MySQL Server
Importing and Installing Datasets I
Lab 2.3 - Importing and Installing Datasets
Getting information about databases and tables
Lab 2.4 - Collecting database and tables information
MySQL Commands
Entering Queries
Lab 2.5 Basic Querying and Syntax
Module 3: Querying Table Data
Understanding Databases and RDBMS
SELECT Statement
LAB 3.1
LAB 3.2
LAB 3.3
SELECT DISTINCT
Lab 3.4: SELECT DISTINCT
Module 4: Filtering Row - SELECT with WHERE
Filtering Rows
Filtering Rows: Comparison
Filtering Rows: Logical
Filtering Rows: Additional Options
Sorting Rows
Liming Rows
LAB 4.1
LAB 4.2
LAB 4.3
Module 5: Data Types
Data Types
Data Types - String
Data Types - Numeric
Data Types - Temporal
Lab 5.1
Module 6: Functions
Functions - Introduction
String Functions
Date and Time Functions
Aggregate Functions
Numeric Functions
Lab 6.1
Lab 6.2
Lab 6.3
Module 7: Joins and Unions
Introduction and Challenges Querying a Single Table
INNER JOIN
INNER JOIN - Part 2
OUTER JOIN
UNION
Lab 7.1
Lab 7.2
Lab 7.3
Lab 7.4
Lab 7.5
Lab 7.6
Lab 7.7
Lab 7.8
Lab 7.9
Lab 7.10
Lab 7.11
Lab 7.12
Module 8: Subqueries
Subqueries
Lab 8.1
Lab 8.2
Lab 8.3
Lab 8.4
Lab 8.5
Lab 8.6
Module 9: Databases and Tables
Lab 9.1 - Creating Databases
Lab 9.2 - Dropping Databases
Lab 9.3 - Creating Tables
Lab 9.4 - Creating Tables with NO NULL
Lab 9.5 - Primary Key
Lab 9.6 - Dropping Table
Lab 9.7 - SHOW CREATE TABLE
Lab 9.8
Lab 9.9
Lab 9.10
Module 10 Part 2: Workbench
Lab 15.1 Download and Install
Lab 15.2
Lab 15.3
Lab 15.4
Lab 15.5
Lab 15.6
Lab 15.7
Lab 15.8
Lab 15.9
Module 15 - Project - Web Server, RDS DB Instance and Snapshot
Lab 5.1: A Web Server and an Amazon RDS DB Instance (61:55)
Lab 5.2: An ALB, a Web Server and RDS DB Instance
Lab 5.3; Creating a DB Snapshot
Lab 5.4: Restoring from a DB Snapshot
Getting information about databases and tables
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock