Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

First Look: MySQL 8 for Developers

via LinkedIn Learning

Go to class Write review

Details

Provider

LinkedIn Learning
Pricing

Free Trial Available
Languages

English
Certificate

Certificate Available
Duration & workload

1 hour 56 minutes
Sessions

On-Demand
Level

Beginner

Found in

Boot.dev

The Most Addictive Python and SQL Courses

Coursera

Coursera Plus Annual Nearly 45% Off

Overview

Coursera Flash Sale

40% Off Coursera Plus for 3 Months!

Learn how to use MySQL to build databases and power data-driven applications.

Syllabus

Introduction

Learn to use MySQL
How to get started with MySQL

1. Database Basics

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

2. 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

3. Creating Tables

Create a database
Create a table
Use CREATE and ALTER to define a table
Primary keys and foreign keys
Display database relationships with reverse engineering
Load bulk data
Challenge: Create a normalized movies table
Solution: Create a normalized movies table

4. 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

5. 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

6. 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

Conclusion

Level up your MySQL knowledge

Taught by

Ami Levin

Reviews

4.5 rating at LinkedIn Learning based on 87 ratings

Start your review of First Look: MySQL 8 for Developers