Learn how to design robust data models to efficiently structure your databases and ensure consistency.
When it comes to data, it is important to understand the role of databases and modeling. With this training you will see how to evaluate the quality of a data organization, in order to establish the possible improvements to be made. This requires a clear understanding of modeling as a whole: objectives, integration in the development process, formalisms, steps... so many points to anticipate to build data models.
Is it for you ?
Developers (other than supervisors), Web specialists, network specialists (other than security specialists) as well as those who work in purchasing and marketing...
Prerequisites
Experience developing systems.
Training content
- Introduction to databases and architecture
- Data models: conceptual, logical and physical
- Techniques, objectives, benefits and limitations of modeling
- The conceptual model: entities, properties, identifiers, relationships, cardinalities, rules and designing procedures
- Normalization (1FN, 2FN, 3FN)
- Rules for constructing schemas
- Design procedures and strategies
- Tips and tricks: generalization, customization, grouping
- The logical model: tables, columns, join tables, primary keys, foreign keys, integrity constraints
- Rules for constructing a relational schema
- Transforming entities
- The physical model: internal organization of data and access methods
- The cardinality of relationships (1:1, 1:n, m:n), and attributes of associations
- Current trends.
📌 Practical information
Our training sessions are offered in Montreal or Quebec City, in person or in a virtual classroom. Dates and locations are specified when you select your session below. If you have any questions, check out our FAQ.
