Relational Database Design Fundamentals

Course Summary

Training levelSQL Server Database Design Course
Duration2 days / 16 Hours
Delivery methodIn Class
List price350 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

Solution Architects, consultants and IT professionals who want to gain knowledge necessary to make architectural decisions in SQL Server Platform.

Designers and developers who start their career in the database field.

Developers who are responsible for changing database design or responding to database change requirements.

  • Understand the concepts of relational database theory
  • Understand attribute relationships and relations
  • Understand normal forms and perform normalization of a model
  • Avoid some well-known bad practices in designing a database
  • Analyse subject area requirements and build a conceptual and logical design
  • Explain the good database model properties
  • Make well-grounded decisions related to DB design
  • Create a logical model of a database

Module 1: Relational DB Fundamentals

Module 2: Attributes and Relationships

Module 3: Database Constraints and logical Integrity

Module 4: Normalization

Module 5: ER Modeling Principles

Module 6: ER Modeling Case Study

Next 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