Learning MySQL Development (2020)

Course details

Are you brand new to database development? After 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. Find 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. By the end of this course, you'll have the basic skills you need to create and maintain your own MySQL databases—and take your applications to a whole new level of sophistication.

Topics include:
Understanding the structure of a database
Database best practices
Creating tables
Importing data
Writing SELECT queries
Filtering results
Inserting data
Updating data
Deleting data
Joining tables

Concepts

0. Introduction

01 - Learning 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 - Load bulk data
19 - Challenge - Create normalized movies table
20 - Solution - Create normalized movies table

4. Selecting Data

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

5. Updating and Deleting Data

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

6. Joining Tables

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