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)

Student Reviews

Adrian says:

Not very good  

We don't work in actual MySQL program, I'm little disappointed

Nathan Rajkumar says:

Amazing!  

A great way to get started into the huge world of production databases! Trevors videos are meaningful and provide insight good for any beginner or intermediate programmer! Highly recommend if your looking for a way to enhance your db skills!

gustavo rodrigues dos santos says:

great quality and unbeliveble cheap  

u have made a great work and fantastic videos and tutoriais

© Proffesso 2017
Version: 1.6.0.10 (beta)
Privacy Policy | Terms of Service