Conceptual Modeling: Structuring Databases

by Technologia IT Group Inc Claim Listing

When talking about data it is important to understand the role of databases and modeling. With this training you will see how to evaluate the quality of a data organization in order to establish possible improvements to be made. 

$995

Contact the Institutes

Fill this form

Advertisement

Technologia IT Group Inc Logo

img Duration

2 Days

Course Details

When talking about data, it is important to understand the role of databases and modeling. With this training, you will learn how to evaluate the quality of a data organization in order to establish possible improvements to be made.

This requires having a clear understanding of modeling as a whole: the objectives, the integration into the development process, the formalisms, the stages... there are so many points to anticipate in order to build data models.

 

Training Aims

Be able to describe the stages and levels of modeling, present the main approaches, build data schemas, and evaluate the quality, weaknesses, and improvements of a data organization.

 

Target Customers

All development positions (except supervision), Web specialist positions, all network positions (except security), and purchasing and marketing positions

 

Prerequisites

  • Experience in systems development.

 

 

Training Architecture

  • Introduction: databases and architecture

  • Levels of data modeling: conceptual, logical and physical

  • Techniques, objectives, benefits and limits of modeling

  • Conceptual model: entities, properties, identifiers, relationships, cardinalities, rules and construction activities

  • Normalization (1FN, 2FN, 3FN)

  • Rules for constructing diagrams

  • Design activities and strategies

  • Miscellaneous advice: generalization, personalization and grouping

  • Logical model: tables, columns, connectors, primary, alternate and foreign keys, integrity and derivation rules

  • Rules for constructing a relational diagram

  • Transforming entities

  • Physical model: internal organization of data and access methods

  • Relationships: 1:1, 1:n, n:m, association attributes

  • Current directions

  • Montreal Branch

    1626, boulevard St-Laurent, Montreal

Check out more Data Structures and Algorithms courses in Canada

Calgary Learning Institute Logo

Data Structures and Algorithms in Python

Use the Data Structures and Algorithms in Python course and lab to master all the concepts associated with Data Structures algorithms. The lab is cloud-based, device-enabled, and can easily be integrated with an LMS.

by Calgary Learning Institute [Claim Listing ]
Sault College Logo

Data Analytics in Business Decision-Making

This data provides organizations with the information they need to respond quickly to organizational and market changes and opportunities.

by Sault College [Claim Listing ]
Launchpad Learning Logo

Data Structures

Data structures course training is offered by Launchpad Learning for adults. Launchpad Learning has a lot to offer. We have many years of experience helping students from Mount Royal University, University of Calgary and SAIT. 

by Launchpad Learning [Claim Listing ]
Q Academy Logo

Data Structure With Python (Intro)

This course aims to provide a thorough understanding of fundamental data structures and their implementation in Python. Students will learn how to work with arrays, linked lists, stacks, queues, trees, and more, as well as gain a foundational knowledge of algorithm analysis.

by Q Academy [Claim Listing ]
Teen Programming Logo

Algorithms

Evaluate the most practical industry technologies and teach the best languages, best tools, and best practices. Provide courses that lead to a technical certificate or a vocation.

by Teen Programming [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy