Introduction to the course and MySQL
  • Introduction
  • Introduce yourself and learn how to get FREE LIVE HELP!
  • Development environment overview
  • IMPORTANT: Development Environment Setup - Overview
  • Windows - Install/setup MySQL, users and create databases
  • Mac - Install/setup MySQL, users and create databases
  • AWS Cloud - Setup MySQL, users and create databases
Creating Databases and Introduction to Queries
  • Power of Databases
  • Create a Database/Schema
  • Create a Database/Schema - Text lecture
  • Intro to tables and conventions used
  • Working with tables
  • Working with tables - Text lecture
  • Inserting rows of data
  • Inserting rows of data - Text lecture
  • Select
  • Select - Text lecture
  • Concat and substring
  • Concat and substring - Text lecture
  • Homework challenge - bowling scores!
  • Homework challenge - Text version
  • Solution - bowling score challenge
  • Solution - Text
  • Alternate method of homework solution - script
  • Alternate method of running queries - script - Text version
  • MySQL, Oracle, SQL Server
  • Limit, order by and distinct
  • Limit, order by and distinct - Text lecture
  • Count, like and group by
  • Count, like and group by - Text lecture
  • Min and max
  • Min and max - Text lecture
  • Code challenge project - create a new report
  • Code challenge project - Text version
Logical operators and dates
  • Data types in MySQL
  • Data types in MySQL - Text lecture
  • Where and not equal
  • Where and not equal - Text lecture
  • Comparison operators
  • Comparison operators - Text lecture
  • Or
  • Or - Text lecture
  • Null and blanks
  • Null and blanks - Text lecture
  • Case statements
  • Case statements - Text lecture
  • Dates and times
  • Dates and times - Text lecture
  • Date, time and math
  • Date, time and math - Text lecture
  • Section 3 final project - Create a report on birthdays
  • Text solution to final project on birthday reporting
Update and delete rows
  • Update
  • Update - Text lecture
  • Update based on comparison
  • Update based on comparison - Text lecture
  • Delete
  • Delete - Text lecture
Multiple tables and JOINS
  • Primary keys, foreign keys
  • Primary and foreign keys - Text lecture
  • Data prep for joins
  • Data prep for joins - Text lecture
  • Joins and aliases
  • Joins and aliases - Text lecture
  • More about joins
  • More about joins - Text lecture
  • Inner, Left, Outer, Right joins
  • Inner, Left, Outer and Right joins - Text lecture
  • Left outer joins
  • Left outer joins - Text lecture
  • Fix a bad join challenge
  • Fix a bad join challenge - Text lecture
  • Subselects
  • Subselects - Text lecture
  • More subselects
  • More subselects - Text lecture
  • Section 5 - Final Project Part 1
  • Final Project Part 1 - Text solution
  • Section 5 - Final Project Part 2
  • Final Project Part 2 - Text solution
Web apps - Data collection from a survey
  • Introduction to Web App Development
  • HTML and CSS
  • HTML and CSS - Text lecture
  • Start form collector project
  • Project start - Text lecture
  • Add styling to form
  • Add styling to form - Text follow-up
  • Create table
  • Create table - Text follow-up
  • Learn php basics
  • Config and other php
  • Config and other php - Text follow-up
  • Complete receiver
  • Complete receiver - Text follow-up