BD101

Conceptual Data Modeling

Well-structured modeling for well-structured databases

89%

overall satisfaction for this course

?Average calculated from scores obtained from 695 participants who took this course.
  • Duration 2 days
  • Regular fee 945
  • Preferential fee 795?
  • 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

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.

Customer Testimonials

Provides an excellent opportunity to acquire knowledge in data modeling in a short time.

Luciano M. / Associé de recherche, École Polytechnique de Montréal

Content

  • 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

DATES*

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

    January 8 to January 9 2018

  • Quebec City

    January 15 to January 16 2018

  • Montreal

    April 9 to April 10 2018

Trainer(s) assigned(s)

Other course(s) in this category