MySQL and PostgreSQL Training
As the two most popular open source relational databases in use today, experience and knowledge of MySQL and PostgreSQL can provide ongoing benefits to individual database administrators and teams alike.
With expert, hands-on MySQL and PostgreSQL training from OpenLogic, your team learns how to implement, scale, and optimize MySQL and PostgreSQL.
Talk to an expert to start planning your training course today.
About the MySQL and PostgreSQL Training Course
The OpenLogic MySQL and PostgreSQL training course is designed to give database administrators the knowledge necessary to work with open source RDBMS in the enterprise.
What Will You Learn?
In this course, we expand on our one-day course to provide students with an even deeper dive into the administration, security, and production-hardening of open source databases. You will walk out of this course with the knowledge to tackle production PostgreSQL issues with hands-on experience.
Standard Course Agenda
The OpenLogic MySQL and PostgreSQL training course is provided in a series of modules – accompanied by lab time to give your team hands-on experience.
MySQL Architecture Review
Including a review of data models, structure, requirements, management tools and software, and physical vs. logical modeling.
MySQL Deep Dive
Including an intro to Postgres; monitoring and auditing; and backup/restore.
PostgreSQL Tactical Training
Including installation; local security; and PGAdmin.
Lab: How to use PostgreSQL in your environment
PostgreSQL Theory
Including architecture; system catalog; database processes; SQL compliance; tablespaces; and best practices.
Lab: Creating and Interacting With a Database
PostgreSQL Administration Deep-Dive
Including command line administration; PGAdmin administration; Config Files; users and roles, and testing against profiles; and backup and restore options.
Lab: Creating Production-Ready Postgres
PostgreSQL at Scale
Including security auditing; monitoring solutions; vertical scaling; high availability options; and WAL Streaming/DR.
How is the Course Delivered?
The OpenLogic MySQL and PostgreSQL training course is delivered on-site or via online classroom format over the course of two and a half (2.5) days. The minimum class size is 5 participants, and we recommend no more than 15 attendees to accommodate corresponding lab work for an optimal training experience.
Before finalizing your training agenda, we schedule a 30-minute introductory call with you to establish any custom elements you may require.
Meet Your Instructor
OpenLogic has a team of enterprise architects (EAs) who average 15 years of experience. Each one of our EAs has deep expertise with traditional open source databases — with many specializing in PostgreSQL and MySQL. Our EAs have developed database applications, created reporting systems, assisted data scientists, and saved the day during critical outages. With their depth and breadth of experience, you can be confident they are the right people to have in the room to train your team on MySQL and PostgreSQL.
Request Training for Your Team Today
Enhance user and team productivity, accelerate learning, and achieve success faster with MySQL and PostgreSQL through instructor-led training from OpenLogic.