Introduction
  • Introducing MySQL
Getting Started
  • Installing MySQL and the Workbench
  • Using the Command Line
  • Creating Tables
  • Multiple Columns, int and Data Types
  • Null Values and Not Null
  • Mysql Storage Engines and Configuration
  • SQL Modes
  • Deleting All the Data in a Table
  • Primary Keys
  • Auto Increment
  • Narrowing Down Select Statements
Importing and Exporting Data
  • Exporting and Importing Data
  • Exporting Using the Command Line
  • Importing Using the Command Line
MySQL Operators
  • Some Test Data
  • Comparison Operators
  • Logical Operators
  • 018 Exclusive Or
  • Exercises Part 1
  • Solutions Part 1
Update, Order and Limit
  • Beginning Update Statements
  • Order By
  • Limiting Results
MySQL Data Types
  • Mysql Types
  • Text Types
  • Floating Point Types and Ints
  • The Bit Type
  • Bool
  • Blobs
  • Time, Date and Year
  • Timestamp and Datetime
  • Enumerations
  • Brackets and Conditions Revisited
  • Exercises 2
  • Solutions 2
Aggregate Functions and Grouping
  • The distinct keyword
  • Counting Distinct Values
  • Aggregate Functions
  • Arithmetic in MySQL
  • The Health Survey Dataset
  • Group By
  • Having- Restricting Groups By Aggregate Functions
  • Exercises 3
  • Solutions 3
Foreign Keys and Multiple Tables
  • Naming Columns and Tables
  • Foreign Keys
  • ER Diagrams
  • Joins and Cartesian Products
  • Inner Joins
  • Left and Right Outer Joins
  • Joins on Multiple Tables
  • Querying Chains of Tables
  • One to Many and One to One
  • Many to Many
  • Joining Tables to Themselves
  • Restrict Foreign Keys
  • Cascade Foreign Keys
  • Exercises 4
  • Solutions 4
Combining Queries
  • Union and Union All
  • Subqueries with "in"
  • Inline Views
Altering Schemas
  • Adding Columns
  • Adding Foreign Keys
  • Adding Indexes
  • Indexes on Multiple Columns
Users and Privileges
  • Creating Users
  • Granting Privileges
Views
  • Creating a Simple View
  • View Algorithms
  • With Check Option
Locks and Transactions
  • Exclusive Table Locks
  • Shared Table Locks
  • Using Variables
  • Setting Variables with Selects
  • A Select-Update Example
  • Fixing Select-Updates with Table Locks
  • ACID
  • A Simple Transaction
  • Start Transaction
  • InnoDB Row Locking and Isolation
  • ACID Isolation Levels
  • Serializable and Row vs Table Locking
  • Demonstrating the Other Isolation Levels
  • Rolling Back to Savepoints
  • The Account Transfer Problem