Wenn Sie sich für diesen Kurs anmelden, werden Sie auch für diese Spezialisierung angemeldet.
Lernen Sie neue Konzepte von Branchenexperten
Gewinnen Sie ein Grundverständnis bestimmter Themen oder Tools
Erwerben Sie berufsrelevante Kompetenzen durch praktische Projekte
Erwerben Sie ein Berufszertifikat zur Vorlage
In diesem Kurs gibt es 3 Module
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.
Das ist alles enthalten
7 Videos3 Lektüren1 Aufgabe1 Unbewertetes Labor
Infos zu Modulinhalt anzeigen
7 Videos•Insgesamt 35 Minuten
MySQL Overview Demo•3 Minuten
MySQL from the Terminal Demo•4 Minuten
Archive and Drop a Database Demo•6 Minuten
Import the Sakila Database Demo•8 Minuten
Modify the Sakila Database Demo•5 Minuten
Bash Pipelines with mysql -e Demo•5 Minuten
MySQL to Python Web Server Demo•4 Minuten
3 Lektüren•Insgesamt 30 Minuten
About This Course•10 Minuten
Key Terms: MySQL Fundamentals•10 Minuten
Reflection: MySQL Fundamentals•10 Minuten
1 Aufgabe•Insgesamt 5 Minuten
MySQL Fundamentals•5 Minuten
1 Unbewertetes Labor•Insgesamt 60 Minuten
MySQL Sandbox With Sakila Dataset•60 Minuten
Sakila Schema, JOINs, and Indexes
Modul 2•1 Stunde abzuschließen
Moduldetails
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.
Das ist alles enthalten
3 Videos2 Lektüren1 Aufgabe
Infos zu Modulinhalt anzeigen
3 Videos•Insgesamt 7 Minuten
Sakila Schema Walkthrough•2 Minuten
JOINs Visualization: INNER vs LEFT•3 Minuten
Index B-tree and EXPLAIN ANALYZE•2 Minuten
2 Lektüren•Insgesamt 20 Minuten
Key Terms: Sakila Schema, JOINs, and Indexes•10 Minuten
Reflection: Sakila Schema, JOINs, and Indexes•10 Minuten
1 Aufgabe•Insgesamt 5 Minuten
Sakila Schema, JOINs, and Indexes•5 Minuten
Typed Rust Client with sqlx
Modul 3•1 Stunde abzuschließen
Moduldetails
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.
Das ist alles enthalten
2 Videos5 Lektüren1 Aufgabe
Infos zu Modulinhalt anzeigen
2 Videos•Insgesamt 5 Minuten
Rust to MySQL Type Mapping•2 Minuten
sqlx Rust Demo Walkthrough•3 Minuten
5 Lektüren•Insgesamt 50 Minuten
Key Terms: Typed Rust Client with sqlx•10 Minuten
Reflection: Typed Rust Client with sqlx•10 Minuten
Capstone: Multi-Report sqlx Binary•10 Minuten
Before You Go•10 Minuten
Next Steps•10 Minuten
1 Aufgabe•Insgesamt 15 Minuten
Final Graded Quiz•15 Minuten
Erwerben Sie ein Karrierezertifikat.
Fügen Sie dieses Zeugnis Ihrem LinkedIn-Profil, Lebenslauf oder CV hinzu. Teilen Sie sie in Social Media und in Ihrer Leistungsbeurteilung.
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.