Learning MySQL Development

Course details

Are you brand new to database development? After more than 25 years, MySQL is still the most popular and approachable database management system—ideal for developers who want to start programming data-driven applications. This course provides an overview of MySQL tools and techniques for software development. Discover what a database is and how it's structured and explore the data types underlying MySQL records. Learn how to create tables, define primary and foreign keys, and load data from external sources. Instructor Brad Wheeler then takes you through the basics of writing queries and statements to select, update, delete, and transform data. Plus, get an introduction to advanced concepts such as joining existing tables. Along the way, test your knowledge with challenges and solutions in each chapter.

Join Brad in this course to gain the basic skills you need to create and maintain your own MySQL databases—and take your applications to a whole new level of sophistication.

Concepts

0. Introduction

01 - Learn to use MySQL
02 - How to get started with MySQL

1. Database Basics

03 - What is a database
04 - SQL, a declarative language
05 - Databases vs. flat files and spreadsheets
06 - Common database terms
07 - Database best practices

2. Exploring MySQL

08 - Advantages and disadvantages of MySQL
09 - Exploring MySQL Workbench
10 - MySQL data types - Part 1
11 - MySQL data types - Part 2
12 - Challenge - Explore the built-in databases
13 - Solution - Explore the built-in databases

3. Creating Tables

14 - Create a database
15 - Create a table
16 - Use CREATE and ALTER to define a table
17 - Primary keys and foreign keys
18 - Display database relationships with reverse engineering
19 - Load bulk data
20 - Challenge - Create a normalized movies table
21 - Solution - Create a normalized movies table

4. Selecting Data

22 - The basics of SELECT
23 - Refine SELECT queries
24 - Filter results with WHERE
25 - Display data with CASE
26 - Challenge - Filter movies by score
27 - Solution - Filter movies by score

5. Updating and Deleting Data

28 - Add data to tables with INSERT
29 - Update existing rows with UPDATE
30 - Remove data with DELETE
31 - Challenge - Clean up the movies
32 - Solution - Clean up the movies

6. Joining Tables

33 - The basics of JOIN
34 - Match fields with INNER JOIN
35 - Match all fields with outer joins
36 - Challenge - Find the best film
37 - Solution - Find the best film

Conclusion

38 - Level up your MySQL knowledge

Learning MySQL Development

Authors

Brad Wheeler