Databases and SQL Course Offer

Author: Trevor Page


$197


Lessons: 32
Video: 9.6 Hours
Learn how to design, create and maintain your own MySQL databases.

What's Inside This Offer?

Databases and SQL Course

Module 1 - Getting Comfortable with Databases

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