Relational Database Design for Performance and Scalability

Course Summary

Training levelSQL Server Database Design Course
Duration2 days / 16 Hours
Delivery methodIn Class
List price450 Euro VAT Excl.

Click Tabs for Detailed info

The design of relational database is an important and inseparable part of the solution development. Those are knowledge and skills which every DB Dev or DB Designer should have. A huge part of the problems in production environment occur due to a bad modelling practises. The relational database classes of SQL Master Academy focus on mastering of the relational design and the good modelling of the subject area, and last bit not least on applying good practices in modelling a scalable database

This workshop is reach of discussions of common database design problems as scalability and performance. The workshop is intended for those who design and develop SQL Server database solution at different levels – logical and physical. Some worst practices are shown as well as advices and examples of how to avoid them. The workshop style of the training guarantees the sharing of ideas and knowledge, intensive problem solving discussions scenarios.

  • Identify main issues of database design and schemas
  • Optimize relational schemas in order to fain more performance and to scale the workload
  • Identify main issues of physical database design and bad coding practices
  • Avoiding the pitfalls in database design that create problems in database performance and scalability.

Module 1: Logical Database Schema Optimizations

Module 2: Physical Database Design Principles

Module 3: Physical database optimization techniques

Module 4: Clustering Index Debate

Module 5: Partitioning Principles

Module 6: Business Logic inside the database – common debate

News planned dates:

Trainer: Magi Naumova


Reserve your seat

Subscribe me to your mailing list

Reserving a seat does not imply any obligations for payment

Next training starts in:
Stay tuned for the next training date