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

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 ]
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

Algorithms

Algorithms 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 ]
Centre For Continuing Education And Professional Studies Logo

Data Analysis Applications

In this course, you will learn how to use data analysis tools for enterprise data analysis and reporting while also exploring key aspects of governing and administering a data analytics environment.

by Centre For Continuing Education And Professional Studies [Claim Listing ]
Practicum Canada Logo

Data Structure

Data Structure courses are offered by Practicum Canada. Practicum Canada has highly skilled and proficient professionals with over 20 years of industry and academic experience. We are equipped with innate abilities to instill academic and professional expertise.

by Practicum Canada [Claim Listing ]
  • Price
  • Start Date
  • Duration

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