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.
Objectives
To provide the knowledge and skills required to identify the types of models, to understand the principal approaches, to construct schemas, and to evaluate the strengths, weaknesses and possible improvements of a data model.
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...
Prerequisite
Experience developing systems.
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
Détails + / -
- 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.
💡 Useful information
Our training sessions are offered in Montreal or Quebec City, in person or in virtual format. Dates and locations are provided when you select your session below. If you have any questions regarding registration, schedules, the language of instruction, or cancellation policies, please consult our FAQ .
Trainers
Private or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quote