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