Introduction to MySQL

Select your learning method

Overview Learning objectives What you’ll learn Key facts FAQs What our customers say Get in touch

Learn essential skills

Course overview

Just starting out with SQL? This course helps you build your skills from the ground up using MySQL. You’ll learn how to write queries, manage data, and use Workbench, plus it supports Oracle’s MySQL certification (1Z0‑909). The exam isn’t included, but the course gets you ready.

Navigate MySQL like a pro

This three-day course gives you practical skills in using MySQL, from writing basic queries to building and managing databases. You'll get stuck in with real tools and examples, so by the end, you'll feel confident working with data in any role.

Learning objectives

Familiarise yourself with the MySQL environment
Write basic and advanced SQL queries
Link data across multiple tables
Use functions to shape your query results
Create, edit and remove tables
Build and manage views
Set access rules for different users
Move data in and out of the system

What you’ll learn

Across three packed days, you’ll get plenty of hands-on practice with MySQL. You’ll go from basic queries to building and editing your own databases, learning how to organise, manage, and move data with tools like Workbench and the MySQL client.

Getting started with MySQL

Get set up with the right tools, connect to a database, and get comfortable in the MySQL environment.

Querying your data

Use SQL statements like SELECT, WHERE, and JOIN to pull together useful info from different tables.

Working with functions

Tidy up your results with text, date, and number functions. Perfect for reports or dashboards.

Handling your tables

Build tables, make changes, and manage the data inside them. Includes views, indexes, and constraints.

Access and permissions

Set up users, manage logins, and control who can see or edit your data.

Bringing data in and out

Learn how to import and export data using MySQL tools or the command line.

What’s included

3-day live course
Led by an expert trainer
Practical lab sessions
Access to MySQL Workbench & client tools
Course notes and support materials
ILX certificate of completion
Aligned with MySQL 8.0 Developer exam
Flexible delivery options available

Key facts

Ideal for

Perfect if you’re new to databases or want to brush up on core SQL skills. Great for entry-level devs, analysts, support staff, or anyone switching into tech.

Prerequisites

You don’t need any database background. Just bring curiosity and a bit of general IT know-how, and we’ll walk you through the rest.

Learning experience

Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.

FAQs

Not sure where to start with SQL or databases? This course keeps things simple. It’s hands-on, trainer-led, and gives you a proper understanding of how MySQL works, so you can start using it straight away.

Is this beginner-friendly?

Yes! We assume you’re starting from scratch. No SQL knowledge needed, we teach you everything from the basics up.

Do I get a qualification from this course?

Not directly, but it’s mapped to the MySQL 8.0 Developer Oracle Certified Professional exam (1Z0‑909), so it’s solid prep if you plan to get certified.

What kind of tools will I be using?

You’ll work with MySQL Workbench and MySQL command-line, tools you’ll likely use on the job.

Will I receive a certificate?

Yes, once you finish the course, ILX will issue a certificate of completion.

Can I arrange training for a team?

Yes, we can run private sessions for your team, either virtually or on-site, and tweak the content to match your goals.

What’s the next step after this course?

You can go deeper with MySQL for Developers if you're into building apps, or MySQL Database Administration if you're more into backend support.

What our customers say

‘Tarn is an excellent instructor. Everything was clearly communicated. One of the best courses I have attended in recent years.’

Simon, Senior DBA – Government

‘Very knowledgeable instructor, well paced, not rushed. Everything was explained clearly.’

Kimberley, Community Risk Reduction IT Systems - Fire

Why study with ILX

500,000+ learners

Join the half a million learners developing their skills with our training

5,000+ businesses

A trusted partner to thousands of organisations worldwide

96% customer satisfaction

Our passionate team goes above and beyond to support customer needs

Similar courses

MySQL

Course

Relational Databases & Data Modelling Overview

From $1,610.00