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.
Developers (other than supervisors), Web specialists, network specialists (other than security specialists) as well as those who work in purchasing and marketing...
Experience developing systems.
- 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
Very good training course that focuses on the essentials and the practical issues.
Gouré Henri S. / Président, Exergie Nord-Sud