Conceptual Data Modeling


overall satisfaction for this course

?Average calculated from scores obtained from 690 participants who took this course.
  • Duration 2 days
  • Regular fee 895
  • Preferential fee 750?
  • Locations
    • Quebec City
    • Montreal
  • Laboratory

Formation path :

Databases Training Paths

View path


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

Analysts, designers and database administrators.


Experience developing systems.

Customer Testimonials

Very well-structured and rich information.

Saul P. / Technicien en informatique, Office national du film du Canada (ONF)


  • Introduction to databases and the architecture
  • Data models: conceptual, logical and physical
  • Techniques, objectives, benefits and limitations of modeling
  • The conceptual model: entities, properties, identifiers, relationships, cardinalities
  • 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 on associations
  • Best practices


*Unless stated otherwise, all sessions are in French.
  • Quebec City

    September 25 to September 26 2017

  • Montreal

    October 16 to October 17 2017

Trainer(s) assigned(s)

Other course(s) in this category