When you enroll in this course, you'll also be enrolled in this Specialization.
Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate
There are 3 modules in this course
MySQL from Zero is a hands-on three-module course that teaches you to install MySQL, import the Sakila sample database, query it from the terminal, and build a Bash to Python to Rust pipeline that surfaces the same answer through three increasingly type-safe layers.
Module 1 starts you in `mysql -u user -p` with `SHOW DATABASES`, `USE sakila`, and `SELECT ... LIMIT`, then walks through `mysqldump` for safe backups, INSERT/UPDATE/DELETE on a real schema, and the `INTO OUTFILE` to `http.server` to `curl` pipeline that turns a SQL query into an HTTP endpoint with zero new packages.
Module 2 dives into the Sakila schema itself: the customer to rental to inventory to film traversal that drives most queries, INNER vs LEFT JOIN with row-by-row materialization, and B-tree indexes paired with `EXPLAIN ANALYZE` so you can predict query cost before you ship.
Module 3 closes with a typed Rust client: `sqlx::MySqlPool` against the same Sakila, the `FromRow` derive mapping rows to a struct, and four runtime `assert!` contracts that fail loudly when data drifts. By the end you can pick the right query for a real database problem and ship it as a single static Rust binary.
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
Show info about module content
7 videos•Total 35 minutes
MySQL Overview Demo•3 minutes
MySQL from the Terminal Demo•4 minutes
Archive and Drop a Database Demo•6 minutes
Import the Sakila Database Demo•8 minutes
Modify the Sakila Database Demo•5 minutes
Bash Pipelines with mysql -e Demo•5 minutes
MySQL to Python Web Server Demo•4 minutes
3 readings•Total 30 minutes
About This Course•10 minutes
Key Terms: MySQL Fundamentals•10 minutes
Reflection: MySQL Fundamentals•10 minutes
1 assignment•Total 5 minutes
MySQL Fundamentals•5 minutes
1 ungraded lab•Total 60 minutes
MySQL Sandbox With Sakila Dataset•60 minutes
Sakila Schema, JOINs, and Indexes
Module 2•1 hour to complete
Module details
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
Show info about module content
3 videos•Total 7 minutes
Sakila Schema Walkthrough•2 minutes
JOINs Visualization: INNER vs LEFT•3 minutes
Index B-tree and EXPLAIN ANALYZE•2 minutes
2 readings•Total 20 minutes
Key Terms: Sakila Schema, JOINs, and Indexes•10 minutes
Reflection: Sakila Schema, JOINs, and Indexes•10 minutes
1 assignment•Total 5 minutes
Sakila Schema, JOINs, and Indexes•5 minutes
Typed Rust Client with sqlx
Module 3•1 hour to complete
Module details
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
Show info about module content
2 videos•Total 5 minutes
Rust to MySQL Type Mapping•2 minutes
sqlx Rust Demo Walkthrough•3 minutes
5 readings•Total 50 minutes
Key Terms: Typed Rust Client with sqlx•10 minutes
Reflection: Typed Rust Client with sqlx•10 minutes
Capstone: Multi-Report sqlx Binary•10 minutes
Before You Go•10 minutes
Next Steps•10 minutes
1 assignment•Total 15 minutes
Final Graded Quiz•15 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.