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.

Join this database performance and security training to learn how to identify, fix, and prevent actions that degrade your databases, optimize backups, indexing, configurations, and keep your databases running smoothly on your terms.

The training is based on MySQL and is taught by Lukas Vileikis, the founder of BreachDirectory, ex-Severalnines (former MySQL staff) developer relations engineer, international speaker, security evangelist, and the author of Hacking MySQL.

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.

Get Started

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?

Exchange CS2 Skins for Access to BreachDirectory