Introduction to Course
  • Course Introduction
  • Introduction to MySQL
  • Few Instructions to Students
Getting the Development Environment Ready
  • Installation of MySQL Database Server in WIndows
  • Installation of MySQL Database Server in Ubuntu [Linux]
  • Installation MySQL Database Server in MAC OSX
  • Introduction to MySQL Console in WIndows
  • Introduction to MySQL Console in Ubuntu [Linux]
  • Introduction to MySQL Console in MAC OSX
  • Sectional Wrap-up
  • Wrap-up Document
  • Test your MySQL Installation Knowledge
Beginning with MySQL Basics
  • Creating a Database - CREATE DATABASE
  • Creating a Table - CREATE TABLE
  • Inserting Values into Table - INSERT INTO
  • Retrieving Values from Table - SELECT
  • Selecting Distinct Values from Column - DISTINCT
  • Selecting a Specific Data using WHERE Clause
  • Selecting with Multiple Identifiers Using AND
  • Selecting with One of Many Identifiers Using OR
  • Sorting the Data Using ORDER BY
  • Limiting the Data Retrieved Using LIMIT
  • Updating or Modifying Data in a Table Using UPDATE
  • Deleting a Data from a Table Using DELETE
  • Deleting a Table - DROP TABLE
  • Deleting all values in Table - TRUNCATE TABLE
  • DESCRIBE TABLE
  • Altering Table Structure - ALTER TABLE
  • Sectional Wrap-up
  • Wrap-up Document
  • Testing your Basic Knowledge on MySQL
Time to Jump in for More
  • Selecting Data with a Range - BETWEEN
  • Creating Alias Name for a Column - AS
  • Selecting Data which has one of Multitple Values - IN
  • Using LIKE and WILDCARDS
  • Copy Table with INSERT INTO SELECT
  • Copy a Table Struture - CREATE TABLE LIKE
  • Copy Table with Certain Columns - INSERT INTO SELECT
  • Combine the Tables - UNION
  • Sectional Wrap-up
  • Wrap-up Document
Few things that Keeps the Database in Shape
  • Keeping Database in Shape
  • PRIMARY KEY
  • UNIQUE KEY
  • FOREIGN KEY
  • NOT NULL
  • AUTO_INCREMENT
  • DEFAULT
  • Sectional Wrap-up
  • Wrap-up Document
Using Joins to Combine Tables
  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL JOIN
  • Sectional Wrap-up
  • Wrap-up Document
Concluding the MySQL with More to Come
  • Don't Stop Now
  • A Set of Requests
  • Lets Connect to Each Other
  • Thank you Students