arrow_back
MySQL Installation
V1 Win MySQL Installation
V2 MacOS MySQL Installation
V3 AWS Cloud MySQL Installation
Creating Databases and Introduction to Queries
V1 Power of Databases
V2 Database and Schemas
V3 Intro to tables and conventions
V4 Working with tables
V5 Inserting Rows of Data
V6 Select
V7 Concat and Substring
V8 Homework Challenge Bowling Scores
V9 Homework Challenge Bowling Scores_ Alternative Solution (1)
V10 Homework Challenge Bowling Scores_Solutions
V11 MySQL Oracle SQLServer
V12 Limit, order by and distinct
V13 Count, Like and Groupby
V14 Min and Max
V15 Code Challenge Project - Create a new report
Logical Operators and Dates
V1 Data types in MySQL
V2 Where and not equal
V3 Comparison Operators
V4 Or
V5 Null and Blanks
V6 Case Statements
V7 Dates and Times
V8 Date, Time and Math
V9 Project_Create a report on Birthdays
Update and Delete Rows
V1 Update
V2 Update based on comparison
V3 Delete
Multiple Tables and JOINS
V1 Primary keys and foreign keys
V2 Data Prep for Joins
V3 Joins and Aliasis
V4 More about Joins
V5 Inner, Left, Outer, Right Joins
V6 Left Outer Joins
V7 Fix a bad Join Challenge
V8 Subselects
V9 More Subselects
V10 Final Project Part 1
V11 Final Project Part 2
