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.
Duration
2 days
Schedule
9h to 16h
Regular fee
$1,035
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$930
Objectives of the training
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.Targeted audience
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.Trainers
Course architecture
- 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
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quoteDuration
2 days
Schedule
9h to 16h
Regular fee
$1,035
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$930
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote