Build essential SQL skills with this three-day, interactive, beginner course. Whether you're learning MariaDB from scratch or transitioning from MySQL, once complete, you'll be able to manage and structure databases confidently.
Introduction to MariaDB
Practical MariaDB training to boost your confidence using SQL
Join this instructor-led course and gain practical experience using MariaDB. Through interactive examples and labs, you’ll learn how to query databases, manage data securely, and work with views and tables.
Learning objectives
- Connect to MariaDB using client applications
- Retrieve and filter data with SQL
- Design and modify tables and databases
- Use joins and subqueries to combine data
- Apply aggregate and scalar functions
- Edit and manage database records
- Configure access with user permissions
- Migrate data using import/export tools
What you’ll learn
Understand how MariaDB works and gain confidence using SQL to handle real tasks, with full guidance from your expert trainer. Build the competence to execute queries, manage schemas, and handle user permissions and transactions – skills that underpin effective database-backed application work.
Database concepts
Explore the core principles of relational databases, with a focus on how these apply within the MariaDB environment. You’ll learn the structure and purpose of a database and gain a clear understanding of terminology such as tables, columns, rows, primary keys, and foreign keys.
Writing and working with SQL queries
Gain hands-on experience in writing and refining SQL queries to retrieve meaningful data from relational databases. Starting with the basics of the ‘select’ statement, you’ll learn how to filter results with ‘where’ clauses, sort data using ‘order by’, and tailor queries to extract the information you need. The course introduces key SQL operators and expressions, as well as giving you familiarity with SQL functions.
Data manipulation
This course provides a practical understanding of data manipulation techniques essential for maintaining and updating database content. You’ll learn how to add new records, modify existing data, and remove unwanted entries. Each command is taught with real-life examples, helping you understand how changes to the data affect the wider database structure and integrity.
What's included
- Three days of expert-led StayAhead training
- Real-time exercises using Live Labs
- StayAhead course materials and exercises
- Flexible delivery formats
- Experienced trainers
- Post-course support materials
- Completion certificate from StayAhead
Key facts
Ideal for
Those currently using MariaDB or switching from MySQL. Also invaluable for data professionals, developers, and technical teams.
Prerequisites
There are no formal prerequisites, but some familiarity with IT is useful.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.
This StayAhead course offers guided training in SQL and database control. It will improve your skills and confidence with hands-on, instructor-led Live Labs.
Is this course suitable if I’ve used MySQL before?
Yes. MariaDB shares a lot of similarities with MySQL, and this course helps you adjust by highlighting where they differ, giving you the knowledge to move from one to the other.
What do I need to take part in the course?
You’ll just need a stable internet connection and computer. StayAhead provides all the course resources and lab access online.
Do I get a certificate?
Yes. You’ll earn a StayAhead certificate of completion, ideal for CVs, internal training records and as a recognition of your learning.
What happens if I can’t make the course dates?
If you can't make the course dates currently available, we can offer new dates or run closed sessions for your organisation. Get in touch and our team would be happy to organise this for you.
Are there more advanced MariaDB courses available?
Yes. StayAhead also offers MariaDB for Developers and MariaDB Database Administration as next-step options to help you progress your career.
What our customers say
“Really informative course, structured to support all forms of learning and at a good pace.”
Owen, Graduate Trainee Engineer – Utilities
“John was very knowledgeable about the subject and clearly explained everything.”
Kimberley, Community Risk Reduction IT Systems - Fire
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