Section : Introduction to MySQL and Cloud Databases

 

. Introduction

 

 

. What is Relational Databases and MySQL?

 

 

. Relational Databases (Article)

 

 

. Install MySQL Database

 

 

. MySQL Workbench

 

 

. MySQL Database on Microsoft Azure

 

 

. MySQL MySQL Database on AWS

 

 

. Summary

 

Section : Schema, Users and Privileges in MySQL

 

. Create and Drop Databases

 

 

. Create Users

 

 

. Exercise : Create Database and User

 

 

. Summary

 

Section : Database Tables, Primary Keys and Foreign Keys in MySQL

 

. Introduction to The Chapter

 

 

. Database Tables

 

 

. Data Types in MySQL

 

 

. Primary Keys

 

 

. Constraints

 

 

. Exercise : Create Tables : Employees and Jobs

 

 

. Foreign Keys

 

 

. Exercise : Create Tables : Previous Experience

 

 

. Exercise : Import Data (Employees and Cities)

 

 

. Create table using Table Data Import Wizard

 

 

. Exercise : Primary and Foreign Keys For Status Table

 

 

. Export Data out of Database

 

 

. Entity Relationship Diagram (ERD)

 

 

. Summary

 

Section : Basic Select Statements in MySQL

 

. Introduction to The Chapter

 

 

. Select

 

 

. Exercise : Select

 

 

. Where

 

 

. Exercise : Where

 

 

. Order by

 

 

. Exercise : Order By

 

 

. And, Or, Not, Is Null

 

 

. Like and Wildcards

 

 

. Exercise : Like and Wildcards

 

 

. Summary

 

Section : Advanced Select Statements Techniques in MySQL

 

. Introduction to The Chapter

 

 

. Distinct

 

 

. In

 

 

. Between

 

 

. Exercise : Between and in

 

 

. Union Operator

 

 

. Exercise : Union Operator

 

 

. Case Statement

 

 

. Exercise : Case Statement

 

 

. Exists

 

 

. Subquery

 

 

. Exercise : Subquery

 

 

. Summary

 

Section : Aggregate Functions in MySQL

 

. Introduction to The Chapter

 

 

. Aggregate Functions –  and Max

 

 

. Aggregate Functions – Count

 

 

. Exercise : Create Table Budget with Some Queries

 

 

. Aggregate Functions – Avg and Sum

 

 

. Group By

 

 

. Having

 

 

. Exercise : Aggregate Functions

 

 

. Summary

 

Section : Data Manipulation in MySQL

 

 

. Introduction to The Chapter

 

 

. DML and DDL

 

 

. Insert Into Statement

 

 

. Exercise : Insert Into Statement

 

 

. Cloning a Table

 

 

. Delete Statement

 

 

. Update Statement

 

 

. Exercise : Update Statement

 

 

. Exercise : Update Status of Employees

 

 

. Summary

 

 

. The Final Lecture