BD101

Conceptual Data Modeling

89%

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
    • Montreal
    • Quebec City
  • Laboratory
    course
Parcours

Formation path :

Databases Training Paths

View path
SUMMARY
DETAILS

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.

Targeted audience

Analysts, designers and database administrators.

Prerequisite

Experience developing systems.

Customer Testimonials

Very well-structured and rich information.

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

Content

  • 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

DATES*

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

    February 13 to February 14 2017

  • Quebec City

    March 13 to March 14 2017

  • Montreal

    May 10 to May 11 2017

Trainer(s) assigned(s)

Other course(s) in this category