Advanced Database Design For a Relational DB w/ MySQL

Real Project | Database Design | Normalization | Indexing | Partitioning | Modeling | Security | SQL Server

Created by: Michal Panasiuk
Senior Software Engineer

What Will I Learn?

• 60+ HANDS-ON sessions
• 140+ slides and 20+ sql migrations scripts available for download
• Understand how to choose the right data type for your index
• Choose the right indexing strategy to boost query performance
• Apply advanced data modeling techniques to handle complex data scenarios
• Master table partitioning—both horizontally and vertically—to efficiently manage large datasets
• Design databases for multilingual applications without sacrificing speed
• Model and implement hierarchical data structures for intuitive data organization
• Prevent index fragmentation with smart design choices from the start
• Implement table inheritance to model complex relationships effectively
• Know when to normalize to improve data integrity, and when to denormalize to optimize performance

Requirements

• Students should have a basic understanding of design concepts such as normalization, indexes, triggers, and stored procedures.

Target audience

• Database developers and architects who are looking to level up their database design skills with advanced techniques
• Full-stack developers, and junior DBAs who understand basic SQL Server concepts and can write simple SQL queries
• SQL Server professionals who want to optimize performance, scalability, and maintainability in real-world projects
• Software engineers working with large datasets who need to implement effective partitioning and indexing strategies
• Data professionals tasked with designing complex database systems, including support for hierarchical data, multi-language applications, and table inheritance