Learn how to use MySQL to build databases and power data-driven applications.
Overview
Syllabus
Introduction
- Learning to use MySQL
- How to get started with MySQL
- What is a database?
- SQL, a declarative language
- Databases vs. flat files and spreadsheets
- Common database terms
- Database best practices
- Advantages and disadvantages of MySQL
- Exploring MySQL Workbench
- MySQL data types, part 1
- MySQL data types, part 2
- Challenge: Explore the built-in databases
- Solution: Explore the built-in databases
- Create a database
- Create a table
- Use CREATE and ALTER to define a table
- Primary keys and foreign keys
- Load bulk data
- Challenge: Create normalized movies table
- Solution: Create normalized movies table
- The basics of SELECT
- Refine SELECT queries
- Filter results with WHERE
- Display data with CASE
- Challenge: Filter movies by score
- Solution: Filter movies by score
- Add data to tables with INSERT
- Update existing rows with UPDATE
- Remove data with DELETE
- Challenge: Clean up the movies
- Solution: Clean up the movies
- The basics of JOIN
- Match fields with INNER JOIN
- Match all fields with outer joins
- Challenge: Find the best film
- Solution: Find the best film
Taught by
Brad Wheeler
