–  Introduction to SQL

–  What is SQL?

–  SQL vs NoSQL

SQL Syntax and Standards

–  Introduction to MySQL

–  What is MySQL?

–  Installing MySQL and MySQL Workbench

–  MySQL Workbench Overview

–  Database Basics

–  Database vs Table

–  Keys: Primary Key, Foreign Key, Unique Key

–  Creating Databases and Tables

–  CREATE DATABASE Syntax

–  CREATE TABLE Syntax with Examples

–  Data Types in MySQL (Numeric, String, Date/Time)

–  Altering Databases and Tables

–  ALTER TABLE: Adding, Modifying, and Dropping Columns

–  Renaming Tables

–  Dropping Databases and Tables

–  DROP DATABASE

–  DROP TABLE

–  Constraints

–  Primary Key, Foreign Key

–  NOT NULL, UNIQUE, CHECK, DEFAULT

–  Inserting Data

–  INSERT INTO Syntax

–  Bulk Inserts

–  Retrieving Data