Proffesso

Module 1 - Getting Comfortable with Databases

Lesson #1 - What is a Database?

Lesson #2 - Rows and Database Keys

Lesson #3 - Installing your Database System

Lesson #4 - What is SQL?

Lesson #5 - Using SQL Command Line

Lesson #6 - SQL Data Types

Lesson #7 - Create a Table

Lesson #8 - CRUD Part I

Lesson #9 - CRUD Part II

Assignment #1

Module 2 – What Makes Databases “Relational” & Why It’s Cool

Lesson #10 - Relationships

Lesson #11 - Normalization

Lesson #12 - One to Many Relationship

Lesson #13 - One to One Relationship

Lesson #14 - Many to Many

Lesson #15 - Tools

Assignment #2

Module 3 – How to Write SQL “Like a Boss”

Lesson #16 - Joins

Lesson #17 - Grouping

Lesson #18 - Aggregate Functions

Lesson #19 - Having Keyword

Lesson #20 - Ordering

Lesson #21 - Select Into

Assignment #3

Module 4 – Advanced Database Topics

Lesson #22 - Alter Tables

Lesson #23 - Views

Lesson #24 - Subqueries

Lesson #25 - Indexes

Lesson #26 - Backups

Assignment #4

Bonus Videos

Bonus Video #1 - How to Read the MySQL Documentation

Bonus Video #2 - Stored Procedures and Functions