Make Your Database Secure and Performant. Start Today  

Database Performance & Security Training

In the words of those I've worked with


During this database performance & security training, you will discover the sorts of actions, minor and major, that degrade databases so that you can identify, fix, and ultimately preempt them. Your databases sometimes act according to their own rules, and this training will help you keep your databases working on your terms. At the same time, you will learn to optimize your backup and recovery procedures, determine when and which data to index to achieve maximum performance, and choose the best database configurations, among other essential skills.

The training is based on MySQL and is taught by Lukas Vileikis, the founder of BreachDirectory, former DevRel engineer @ Severalnines (former MySQL staff), international speaker, security evangelist, and the author of the book Hacking MySQL: Breaking, Optimizing, and Securing MySQL for Your Use Case.

The price of the training for a single individual is 750 EUR and the exact details of the database training are provided upon contact.

The training can be performed remotely or in an accredited training center.

The preliminary structure of the database training can be seen below. The structure of the training can change depending on specific requests.

Module About
Preface An overview of the workshop and what's to come.
The Architecture of MySQL & MariaDB A walkthrough of the architecture of MySQL and MariaDB.
MySQL & MariaDB Storage Engines An overview of the storage engines available in MySQL and MariaDB.
Types of Queries in Relational Databases A deep dive into the types of SQL queries in relational databases.
Optimizing SQL Queries in Relational Databases Methods to optimize query performance when inserting, updating, selecting, or deleting data.
Structuring Databases & Tables for High Performance A deep dive into the structure of your databases and tables. Normalization, things to avoid, etc.
Indexing for Performance A deep dive into the indexes in relational database management systems. You will know when and what data to index to achieve maximum performance.
Character Sets & Collations A deep dive into the character sets and collations that make databases tick.
Partitioning A deep dive into the ins and outs of partitioning.
Replication Replication in database management systems.
Backups A deep dive into physical and logical backup types & more.
Security A deep dive into security measures you can employ when working with relational & NoSQL databases.
Wrap-up Key takeaways are presented to the attendees & the workshop is wrapped up.

Ready to take your databases to the next level?