DolfinED

How to use this course

Introduction to Structured Query Language (SQL)

Introduction to Data Types in SQL

Setting Up The Environment

Introduction to MySQL Workbench

Connecting to the RDS Database Using MySQL Workbench

Querying Using MySQL Workbench

Introduction to Schemas

Resource Download

Hands-On Lab : Creating Our First MySQL Database on AWS RDS

Introduction to Data Definition Language (DDL)

Introduction to Tables

Hands-On Lab : Create A Table in MySQL Database

Hands-On Lab : Dropping Tables in MySQL Database

Knowledge In Action : Your First Database Assignment

A Sneak Peak Into The Course Capstone Project

Resource Download

Data Query Language (DQL) - SELECT Statement

Hands-On Lab : Querying The First Set Of Data

Introduction To Sub-Query

Using Sub-Query To Query And Filter Data

Introduction To Query Joins

Hands-On Lab : Executing A Query Join With Two Tables

Knowledge In Action

Resource Download

Data Modification Language (DML) - INSERT Statement

Hands-On Lab : Inserting Data In Tables

Introduction To Update Statement

Hands-On Lab : UPDATE Data In A MySQL Table

Introduction To DELETE Statement

Introduction To TRUNCATE Statement

Hands-On Lab : DELETE and TRUNCATE Statements

CRUD Operations in MySQL

Knowledge In Action : CRUD Operations

Project Milestone II - Setup Amazon Lightsail With Bitnami AMI Package

Hands-On Lab : Amazon Lightsail Setup With Bitnami