Pragmatic AI Labs

MySQL From Zero

Noah Gift

Instructor: Noah Gift

Included with Coursera Plus

Gain insight into a topic and learn the fundamentals.
Beginner level

Recommended experience

4 hours to complete
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
Beginner level

Recommended experience

4 hours to complete
Flexible schedule
Learn at your own pace

What you'll learn

  • Connect to MySQL from the terminal, import the Sakila sample database, and query it with `SELECT`, `INNER JOIN`, and `LEFT JOIN`

  • Read an `EXPLAIN ANALYZE` plan to tell whether your query uses an index (`type=ref` / `type=range`) or scans the whole table (`type=ALL`)

  • Connect to MySQL from a typed Rust client using `sqlx::MySqlPool`, map result rows to a `FromRow`-derived struct, and embed runtime `assert!`

Details to know

Shareable certificate

Add to your LinkedIn profile

Recently updated!

May 2026

Assessments

3 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

 logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 3 modules in this course

Covers MySQL as the OLTP workhorse, the mysql terminal client, the mysqldump backup-and-restore pattern, importing the Sakila sample database, INSERT/UPDATE/DELETE on a real schema, mysql -e shell pipelines, and a Python http.server backed by a live database.

What's included

7 videos3 readings1 assignment1 ungraded lab

Tours the 16-table Sakila schema spine (customer to rental to inventory to film), contrasts INNER and LEFT JOINs on the same query, and reads EXPLAIN ANALYZE to predict whether a query will scale. Builds the mental model of a B-tree index and the type column that signals ref, range, or full-table scan.

What's included

3 videos2 readings1 assignment

Ports a Python customer-rental analytics script to a typed Rust binary using sqlx::MySqlPool plus the FromRow derive. Names the three type-mapping traps (f64 for money, String for nullable, bool against TINYINT(N)) and enforces four runtime assert! contracts that fail loudly when the data drifts.

What's included

2 videos5 readings1 assignment

Instructor

Noah Gift
Pragmatic AI Labs
45 Courses3,181 learners

Offered by

Why people choose Coursera for their career

Felipe M.

Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Frequently asked questions