We move! Starting September 1st, our QUEBEC CITY training center will be located at 5400, des Galeries Blvd, Suite 500, 5th Floor, Québec (Quebec) G2K 2B4
BD101

Conceptual Data Modeling

Well-structured modeling for well-structured databases

90%

overall satisfaction for this course

?Average calculated from scores obtained from 725 participants who took this course.
See the training dates
  • Duration 2 days
  • Regular fee 955
  • Preferential fee 860?
  • Locations
    • Quebec City
    • Montreal
  • Laboratory
    course

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.

Training Details

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

Customer Testimonials

Very good training course that focuses on the essentials and the practical issues.

Gouré Henri S. / Président, Exergie Nord-Sud

Select the training date*

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

    October 9 to October 10 2019

  • Montreal

    December 9 to December 10 2019

  • Montreal

    May 11 to May 12 2020

  • Quebec City

    May 13 to May 14 2020

Trainer(s) assigned(s)

Other course(s) in this category