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

Introduction

Learning to use MySQL
How to get started with MySQL

Database Basics

What is a database
SQL, a declarative language
Databases vs. flat files and spreadsheets
Common database terms
Database best practices

Exploring MySQL

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

Creating Tables

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

Selecting Data

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

Updating and Deleting Data

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

Joining Tables

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