Database Design and MySQL

Course Curriculum

Chapter 1: Database Design and Normalization

Lecture 1: What is a Database?

Lecture 2: Introduction

Lecture 3: Basic Terms

Lecture 4: Advanced Terms

Lecture 5: Primary Key

Lecture 6: Foreign Key

Lecture 7: Relationships

Lecture 8: 1 to 1 Relationships

Lecture 9: 1 to Many Relationships

Lecture 10: Many to Many relationships

Lecture 11: Why Many to Many relationships can be bad

Lecture 12: Designing relationships

Lecture 13: 1nf (First Normal Form)

Lecture 14: 2nf (Second Normal Form)

Lecture 15: 3nf (Third Normal Form)

Lecture 16: Starting the Design and Normalization

Lecture 17: MySQL Workbench

Lecture 18: Building Our Database and 1nf

Lecture 19: Designing a Library for Books

Lecture 20: Building a Library for Books Pt1 – Following the Forms

Lecture 21: Building a Library for Books Pt2

Lecture 22: Building a Library for Books pt3 and 2nf pt2

Lecture 23: Building a Library for Books pt4 and 2nf/3nf

Lecture 24: Building a Library for Books Pt5 – Finishing the Database

Lecture 25: Concluding Lecture: Where to go from Here. Final Video!

Chapter 2: MySQL Datatypes

Lecture 1: Char and Varchar

Lecture 2: Text Types

Lecture 3: Enum and Set

Lecture 4: Binary, Varbinary, and Blobs

Lecture 5: Integers

Lecture 6: Decimals, Floats, and Doubles

Lecture 7: Bit, Boolean, and Serial

Lecture 8: Date, Datetime, Time, and Year

Lecture 9: Timestamp (Last Video)!

Chapter 3: Complete MySQL Series

Lecture 1: What is MySQL?

Lecture 2: How Data is Organized and Normalization

Lecture 3: Relationships

Lecture 4: Keys

Lecture 5: String Datatypes

Lecture 6: Numeric Datatypes

Lecture 7: Date and Time Datatypes

Lecture 8: Column Features and Extra Settings

Lecture 9: Indexes

Lecture 10: Quotes and Escaping Special Characters

Lecture 11: How to Build a Database

Lecture 12: Altering Data and More Advanced Queries

Lecture 13: Joins (MySQL in English)

Lecture 14: How to install XAMPP and start Using PhpMyAdmin

Lecture 15: How to Define Your Database Structure

Lecture 16: Programming Our Database

Lecture 17: Comments, Semi Colons, Deleting or Dropping Tables

Lecture 18: How to add Columns and Drop(Delete) Columns

Lecture 19: How to Insert and Update Data in a Table Using SQL

Lecture 20: How to use the Insert and Select Commands

Lecture 21: How to do Show Commands

Lecture 22: How to do Alter Commands

Lecture 23: How to be Consistent with MySQL

Lecture 24: How to use a Where Clause and Select Statement

Lecture 25: How to use an Order by Clause

Lecture 26: How to use a Limit Clause

Lecture 27: How to Properly Update Columns

Lecture 28: How to Delete Data

Lecture 29: Introduction to Character Sets and Collations

Lecture 30: How to search your Database using Like and Wildcards

Lecture 31: Introduction to MySQL Storage Engines

Lecture 32: How to Set and Alter Your Storage Engine

Lecture 33: Comparison Operators

Lecture 34: Foreign Key Constraints for the InnoDB Storage Engine

Lecture 35: Introduction to Joins

Lecture 36: Inner Joins

Lecture 37: Left Joins

Lecture 38: How to do an Inner Join and Useful Tips

Lecture 39: How to do Left Joins (outer joins) and Unions

Lecture 40: What is a Function? Introduction to Functions

Lecture 41: Aliases

Lecture 42: How to use Aliases with Joins and Functions

Lecture 43: String Functions PART 1!

Lecture 44: String Functions PART 2!

Lecture 45: How to Use Math Operators

Lecture 46: Numeric Functions PART 1!

Lecture 47: Numeric Functions PART 2

Lecture 48: Date and Time Functions

Lecture 49: Formatting the Date

Lecture 50: What is Encryption?

Lecture 51: How to Encrypt Databases with 1-Way Encryption

Lecture 52: How to Encrypt Data with 2-Way Encryption

Lecture 53: Normalizing a Bank System

Lecture 54: Datatypes of a Bank System

Lecture 55: Indexes and Foreign Key Constraints for our Bank System

Lecture 56: Programming Our Bank System with phpMyAdmin

Lecture 57: Aggregate Grouping Functions and how they work!

Lecture 58: Keyword Distinct

Lecture 59: Group By

Lecture 60: How to use Aggregate Functions

Lecture 61: Comparison Functions

Lecture 62: if Function

Lecture 63: Case Operator