Course Overview
MySQL & PostgreSQL Administration provides a strong foundation in managing two of the most widely used open-source database systems. This mentor-led course introduces learners to essential DBA responsibilities across both platforms, with a focus on real-world operational tasks.
Through practical scenarios, participants will gain hands-on experience installing database servers, managing users and permissions, and implementing backup and recovery strategies. The course also introduces replication concepts, indexing, and query performance basics to support efficient database operations.
By the end of the programme, learners will be able to confidently manage MySQL and PostgreSQL environments, troubleshoot common issues, and support application teams effectively. The course is aligned with industry expectations for entry-level database administrators working with open-source technologies.
Hands-On Learning
Practical labs on MySQL and PostgreSQL setup, backups, and performance basics
Mentor-Led Sessions
Guided sessions covering real-world database administration scenarios
Career-Ready Skills
Open-source database administration for production environments
Learning Outcomes
Design basic database environments
Implement database and user management
Analyse backup and recovery approaches
Evaluate query performance issues
Communicate database operations effectively
Lead basic administration tasks
Prerequisites
Basic IT or Linux knowledge
Familiarity with databases
Basic command-line experience
Detailed Syllabus
Step-by-step learning journey from basics to professional practice
Topics Covered
- Overview of MySQL and PostgreSQL
- Installation requirements and tools
Skills You'll Gain
Master these in-demand skills through hands-on practice
Career Progression
A clear view of the roles this programme supports, what typically comes next, and where learners progress over time
Ways to Learn
Choose the learning format that works best for you and your team
Live Online
Instructor-Led Training
Join live instructor-led sessions from anywhere. Interactive, engaging, and flexible.
- Live instructor interaction (real-time)
- Trainer-led walkthroughs and real examples
- Guided resources and session notes provided
- Structured Q&A and practical discussion
Price per person
Group enrolments and early planning options available.
All prices are exclusive of VAT where applicable. Group enrolments and custom packages available on request.
Prefer a Faster, Personalised Route into IT?
Not everyone learns best in a group. If you want focused guidance, faster clarity, and confidence you can use on the job, our 1-to-1 Fast-Track Training gives you private, mentor-led support tailored to your experience and goals.
"Many learners choose 1-to-1 when they want understanding, not memorisation."
Exam & Certification Information
Everything you need to know about the certification exams
Important Information
You will receive an Xcademia certificate of completion based on participation and successful completion of labs and scenario simulations.
Credential
Certificate of Completion
On successful completion of MySQL & PostgreSQL Administration, learners receive an Xcademia Certificate of Completion. This standalone certificate is issued directly by Xcademia and is aligned with globally recognised frameworks and best practices.
Frequently Asked Questions
Everything you need to know about this course
Yes, it is designed for those starting with open-source databases.
Ready to Start Your Learning Journey?
Take the next step in your professional development