MySQL Foundations
Work with MySQL: install it, design tables and write everyday queries.
What you'll learn
- Install MySQL and use Workbench
- Create tables with the right types and keys
- Write queries with joins
- Import and export data
About this course
You set up MySQL and build a database for a small online store. You write queries, add indexes and learn tools such as MySQL Workbench.
Course curriculum
4 modules and 12 lessons over 3 weeks. Plan for about 9 learning hours.
01SetupWeek 1 · 3 lessons
- Installing MySQL
- Workbench
- Users
02TablesWeek 1 · 3 lessons
- Types
- Keys
- Indexes
03QueriesWeek 2 · 3 lessons
- Joins
- Grouping
- Views
04Store databaseWeek 3 · 3 lessons
- Schema
- Sample data
- Export and import
Project
Store database. A MySQL store database with tables, sample data and report queries.
Who this course is for
Developers working with MySQL, including WordPress and PHP projects.
Prerequisites
You know basic SQL.
What's included
- 120-day course access
- Step-by-step lessons
- Practice files
- Reusable code templates
- A graded final exercise
- A digital completion certificate
Learning format
Self-paced practical course, part of our self-paced courses. Graded final exercise with written feedback.
Access and delivery
- Enrollment is activated within 15 minutes after payment.
- Final exercise feedback is delivered within 2 business days of submission, and the completion certificate is issued within 2 business days after passing the final exercise.
Certificate
You receive a digital completion certificate. Final exercise feedback is delivered within 2 business days of submission, and the completion certificate is issued within 2 business days after passing the final exercise.
Frequently asked questions
When does access start?
Enrollment is activated within 15 minutes after payment.
Is payment taken on this website?
No. After you submit your enrollment request, we reply by email with payment details and enrollment confirmation.
Does this course guarantee a job or income?
No. It is an education and training service and does not include employment, income or placement guarantees.
Can I cancel?
Our Refund and Cancellation Policy lists the terms for self-paced course programs.
