Database Performance & Security Training

In the words of those I've worked with

As a database expert myself, I found Lukas's book perfect for both junior database admins looking to build foundational knowledge and experienced DBAs seeking fresh insights. There’s a piece of wisdom for everyone, and every developer or database admin should have it in their book collection.
This cornerstone book is a must-read for anyone serious about mastering MySQL performance, securing their database, and protecting it against malicious users.
In two words: Read it! You won't regret it. 5/5.

Overall, "Hacking MySQL" is a must-have for anyone serious about mastering MySQL.
Vileikis' expertise shines through in every chapter, making this book an indispensable guide for optimizing and securing MySQL databases.
Highly recommended!

Lukas explained what the "bin" folder consists of, his speech improved my knowledge of indexing in general, especially how it works in MariaDB. Speaking was clear, enough to understand the topic and didn't have too many details that can distract from the main subject.

Nice and detailed presentation for the time you've got allocated.

During the event, their performance was outstanding. They demonstrated excellent skills and a strong commitment, contributing significantly to the success of the event.

Lukas has made extensive security tests and disclosed several issues (CSRF, XSS) on our site. He is professional, kind, and responsive. It is a pleasure working with him!

<...> A great resource for a generalist that needs to get things done and start the journey that is MySQL mastery. <...>

<...> This book presents some concepts of MySQL databases, making it an introduction for beginners. <...>
While some topics are slightly outdated—such as MyISAM and MySQL 5.7—it still provides valuable insights, especially for those new to MySQL.
The author's background in development is evident, particularly in the well-explained sections on queries and indexes.
Overall, while not the most up-to-date resource, this book is still a valuable reference that I keep on my shelf.

The book has a wonderful mix of mixing both technical explanations (especially for configurations which I always get lost in) and conceptual topics especially in the Big Data domain.
If you are a developer striving to upskill in backend development this will book will guide you through using MySQL properly has a developer and I dare say prepare you for other RDBMSs.

Get Started

Your database instances are probably broken. Many developers face slow-running queries, issues related to database architecture, replication, or database security—and that's only the beginning.

Enter exclusive MySQL security & performance training: during the training, you will discover the sorts of actions, minor and major, that degrade databases so you can 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 will be based on MySQL and it will be conducted 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.

The price of the training for groups of people is adjusted based on the number of participants and specific needs. The training can be performed in-person in an accredited training center or remotely and the exact details of the training will be provided upon contact.

The preliminary structure of the training can be seen below. The structure 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.

Database Performance & Security Training

In the words of those I've worked with

Ready to take your databases to the next level?

Secure Your Database