Our beginner-level course provides a structured introduction using MySQL. You will learn how to write queries, manage and update data, and create relational databases with tools such as MySQL Workbench. The course also helps you prepare for the MySQL 8.0 Database Developer Oracle Certified Professional exam (1Z0-909) exam.
Introduction to MySQL
Get confident working with real data
Over three days, you'll get stuck into the practical side of MySQL: writing queries, creating databases, and using real tools to do it. You'll build up your skills in a logical way even if you're new to it. It's a solid start for anyone dealing with data.
Learning objectives
- Connect to a MySQL database
- Run basic queries
- Join tables and write subqueries
- Use built-in functions
- Create and update tables
- Manage views and indexes
- Work with permissions
- Import and export data
What you’ll learn
You’ll learn how to use MySQL in a hands-on way. From writing queries to managing tables and users, this course gives you proper skills you can use at work—or just to understand how databases really work.
Getting started with MySQL
Get familiar with MySQL tools, connect to a database, and find your way around the interface.
Writing queries
Learn how to pull the right info from a database with SELECT, WHERE, JOIN, and more.
Functions and formatting
Tidy up your results using number, text, and date functions. Great for reporting and analysis.
Managing data and structure
Add, update, and remove rows. Create and change tables, indexes, and views as your data grows.
Permissions and access
Understand how to create users and control who can see or change what.
Import and export
Bring in and send out data using built-in tools and command line options.
What’s included
- 3 days of hands-on training
- Instructor-led sessions
- Practical examples and labs
- Use of Workbench and mysql client
- All materials provided
- StayAhead certificate of attendance
- Aligned to the MySQL 8.0 Dev exam
- Delivered virtually or at your location
Key facts
Ideal for
Anyone starting out with databases. Perfect for beginners in IT, support, admin, or development.
Prerequisites
No experience needed. It helps if you’ve seen a database before, but we start from the ground up.
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 a database whizz yet? No problem. This course is a great way to get started with MySQL. It’s hands-on, beginner-friendly, and gives you the skills you need to write queries and manage data with confidence.
Do I need any experience to join this course?
Not at all. This course is designed for people who are completely new to MySQL and databases. We’ll guide you through everything step by step.
Is this course linked to a qualification?
Yes, it lines up with the Oracle Certified Professional: MySQL 8.0 Developer exam (1Z0‑909). We don’t include the exam, but you’ll be well prepared if you want to take it.
What tools will I be using?
You’ll use MySQL Workbench and the mysql command-line tool. Both are widely used and great for building real-world skills.
Will I get a certificate?
You will. You’ll get a StayAhead certificate at the end of the course to show you’ve completed the training.
Can I book this for my team?
Of course. We run private sessions for teams and can adjust the content to match what your group needs, online or in person.
What can I do after this course?
If you want to keep going, we’d recommend MySQL for Developers or MySQL Database Administration next. It depends on whether you want to focus on building applications or managing systems.
What our customers say
‘The course was particularly good and certainly took my PL/SQL to another level. A lot of extremely useful stuff beyond programming. And certainly gave ideas what is possible. The instructor was particularly good and very knowledgeable and anything he didn't know he would investigate and come with the explanation. That is not my first class with him and one of the reasons I actually book with this company.’
Caroline, Government
‘John was a great, kind instructor and thoroughly explained SQL concepts/commands alongside the use of multiple examples to demonstrate. He was very helpful in answering any questions that arose with detailed explanations and/or examples when relevant.’
Jessica, Systems Developer - IT
Why study with StayAhead
96% customer satisfaction
We combine experience and passion to deliver training that meets the highest standards
30+ years’ experience
Industry-leading specialists delivering high-impact IT training
Experiential instructor-led training
Courses are delivered by experienced instructors using hands-on, practical live labs