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 quotePrivate 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