The Complete MySQL Developer Course

Course Curriculum

Chapter 1: Introduction to the course and MySQL

Lecture 1: Introduction

Lecture 2: Introduce yourself and learn how to get FREE LIVE HELP!

Lecture 3: Development environment overview

Lecture 4: IMPORTANT: Development Environment Setup – Overview

Lecture 5: Windows – Install/setup MySQL, users and create databases

Lecture 6: Mac – Install/setup MySQL, users and create databases

Lecture 7: AWS Cloud – Setup MySQL, users and create databases

Chapter 2: Creating Databases and Introduction to Queries

Lecture 1: Power of Databases

Lecture 2: Create a Database/Schema

Lecture 3: Create a Database/Schema – Text lecture

Lecture 4: Intro to tables and conventions used

Lecture 5: Working with tables

Lecture 6: Working with tables – Text lecture

Lecture 7: Inserting rows of data

Lecture 8: Inserting rows of data – Text lecture

Lecture 9: Select

Lecture 10: Select – Text lecture

Lecture 11: Concat and substring

Lecture 12: Concat and substring – Text lecture

Lecture 13: Homework challenge – bowling scores!

Lecture 14: Homework challenge – Text version

Lecture 15: Solution – bowling score challenge

Lecture 16: Solution – Text

Lecture 17: Alternate method of homework solution – script

Lecture 18: Alternate method of running queries – script – Text version

Lecture 19: MySQL, Oracle, SQL Server

Lecture 20: Limit, order by and distinct

Lecture 21: Limit, order by and distinct – Text lecture

Lecture 22: Count, like and group by

Lecture 23: Count, like and group by – Text lecture

Lecture 24: Min and max

Lecture 25: Min and max – Text lecture

Lecture 26: Code challenge project – create a new report

Lecture 27: Code challenge project – Text version

Chapter 3: Logical operators and dates

Lecture 1: Data types in MySQL

Lecture 2: Data types in MySQL – Text lecture

Lecture 3: Where and not equal

Lecture 4: Where and not equal – Text lecture

Lecture 5: Comparison operators

Lecture 6: Comparison operators – Text lecture

Lecture 7: Or

Lecture 8: Or – Text lecture

Lecture 9: Null and blanks

Lecture 10: Null and blanks – Text lecture

Lecture 11: Case statements

Lecture 12: Case statements – Text lecture

Lecture 13: Dates and times

Lecture 14: Dates and times – Text lecture

Lecture 15: Date, time and math

Lecture 16: Date, time and math – Text lecture

Lecture 17: Section 3 final project – Create a report on birthdays

Lecture 18: Text solution to final project on birthday reporting

Chapter 4: Update and delete rows

Lecture 1: Update

Lecture 2: Update – Text lecture

Lecture 3: Update based on comparison

Lecture 4: Update based on comparison – Text lecture

Lecture 5: Delete

Lecture 6: Delete – Text lecture

Chapter 5: Multiple tables and JOINS

Lecture 1: Primary keys, foreign keys

Lecture 2: Primary and foreign keys – Text lecture

Lecture 3: Data prep for joins

Lecture 4: Data prep for joins – Text lecture

Lecture 5: Joins and aliases

Lecture 6: Joins and aliases – Text lecture

Lecture 7: More about joins

Lecture 8: More about joins – Text lecture

Lecture 9: Inner, Left, Outer, Right joins

Lecture 10: Inner, Left, Outer and Right joins – Text lecture

Lecture 11: Left outer joins

Lecture 12: Left outer joins – Text lecture

Lecture 13: Fix a bad join challenge

Lecture 14: Fix a bad join challenge – Text lecture

Lecture 15: Subselects

Lecture 16: Subselects – Text lecture

Lecture 17: More subselects

Lecture 18: More subselects – Text lecture

Lecture 19: Section 5 – Final Project Part 1

Lecture 20: Final Project Part 1 – Text solution

Lecture 21: Section 5 – Final Project Part 2

Lecture 22: Final Project Part 2 – Text solution

Chapter 6: Web apps – Data collection from a survey

Lecture 1: Introduction to Web App Development

Lecture 2: HTML and CSS

Lecture 3: HTML and CSS – Text lecture

Lecture 4: Start form collector project

Lecture 5: Project start – Text lecture

Lecture 6: Add styling to form

Lecture 7: Add styling to form – Text follow-up

Lecture 8: Create table

Lecture 9: Create table – Text follow-up

Lecture 10: Learn php basics

Lecture 11: Config and other php

Lecture 12: Config and other php – Text follow-up

Lecture 13: Complete receiver

Lecture 14: Complete receiver – Text follow-up