Databases and SQL Course (Dedicated)

Created By: Trevor Page


$197

Pay with Card

Lessons: 32
Video: 9.6 Hours
Learn how to design, create and maintain your own MySQL databases.
  Supplemental material available for download.
  Videos are downloadable for offline viewing.

  Interact with the teacher and other students.

What's Inside This Offer?

Databases and SQL Course

Module 1 - Getting Comfortable with Databases

Lesson #4 - What is SQL? (09:35)
Lesson #5 - Using SQL Command Line (10:07)
Lesson #6 - SQL Data Types (15:09)
Lesson #7 - Create a Table (16:13)
Lesson #8 - CRUD Part I (27:50)
Lesson #9 - CRUD Part II (21:05)
Assignment #1

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

Lesson #10 - Relationships (10:08)
Lesson #11 - Normalization (25:28)
Lesson #12 - One to Many Relationship (10:48)
Lesson #13 - One to One Relationship (10:51)
Lesson #14 - Many to Many (11:49)
Lesson #15 - Tools (20:51)
Assignment #2

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

Lesson #16 - Joins (36:16)
Lesson #17 - Grouping (27:03)
Lesson #18 - Aggregate Functions (14:30)
Lesson #19 - Having Keyword (23:41)
Lesson #20 - Ordering (07:16)
Lesson #21 - Select Into (25:09)
Assignment #3

Module 4 – Advanced Database Topics

Lesson #22 - Alter Tables (19:12)
Lesson #23 - Views (17:54)
Lesson #24 - Subqueries (26:17)
Lesson #25 - Indexes (39:34)
Lesson #26 - Backups (29:11)
Assignment #4

Bonus Videos

Bonus Video #1 - How to Read the MySQL Documentation (16:34)
Bonus Video #2 - Stored Procedures and Functions (01:03:44)
© Proffesso 2017
Version: 1.5.2.16 (beta)
Privacy Policy | Terms of Service