Maxtrain.com - info@maxtrain.com - 513-322-8888 - 866-595-6863
Data Modeling Workshop
Description
Data Modeling Workshop Introduction
Welcome to our Data Modeling Workshop, designed to elevate your expertise in crafting precise and effective data models. This comprehensive program is perfect for business analysts, data modelers, data analysts, data architects, and database administrators aiming to refine their skills.
Through hands-on training and insightful discussions, participants will gain the necessary skills to develop robust data models applicable in various database environments.
This workshop covers a wide range of data modeling methodologies and core concepts applicable to both traditional and modern database systems, including IBM DB2, Oracle, Microsoft SQL Server, MySQL, PostgreSQL, and more.
You’ll also explore advanced topics like object databases and legacy systems such as IMS and IDMS. The techniques taught are demonstrated using Oracle SQL Developer Data Modeler, but the skills are transferable to other popular tools like IBM InfoSphere Data Architect and Erwin Data Modeler.
Whether you are enhancing your existing skills or starting your journey in data modeling, this workshop is an invaluable resource. It promises a deep dive into the realm of data modeling, providing you with the tools to improve data management practices effectively.
Data Modeling Workshop Objectives:
In this Data Modeling Workshop, participants will:
- Master Core Data Modeling Techniques: Understand and apply core data modeling methodologies across various database systems.
- Learn Using Industry Tools: Gain practical experience with Oracle SQL Developer Data Modeler and understand how these practices apply to other major data modeling tools.
- Expand Database Knowledge: Explore a variety of database environments, from traditional relational systems to emerging technologies and legacy databases.
- Develop Transferable Skills: Equip yourself with transferable skills that enhance your ability to implement robust data models in diverse professional settings.
Prerequisites
- There are no mandatory prerequisites for this workshop. However, having a basic understanding of computer systems, business systems requirements, and database technologies can be helpful.
Audience
This workshop is designed for a diverse range of professionals, including:
- Business analysts
- Data modelers, data analysts, and data architects
- Senior application designers and developers
- Database administrators
Data Modeling Workshop Outline
Data Modeling Theory & Concepts
- Introduction to Model-Based Design
- Essential Data Modeling Concepts
- Understanding Data Model Diagrams
- Advanced Modeling Methodologies
Building an Initial Data Model
- Data Modeling Principles
- Step-by-Step Model Creation
- Identifying Entities, Attributes, and Relationships
- A Practical Modeling Scenario
Drawing a Model Using Software Engineering Tools
- Introduction to Data Modeling Tools
- Creating Data Model Diagrams
Increasing the Accuracy of the Model
- Starting with a Conceptual Model
- Enhancing Model Requirements
- Refining Relationship Definitions
Finding & Fixing Attribute Mistakes
- Capturing Missing Attribute Details
- Correcting Attribute Definitions
- Managing Unique Identifiers and Units of Measure
Semantic & Object-Oriented Modeling of Entities & Relationships
- Defining Supertypes & Subtypes
- Handling Entity Name Challenges
- Specialization, Generalization, and Constraints
- Exploring Relationship Arcs
Semantic & Object-Oriented Modeling of Domains & Types
- Defining Domains
- Working with Types, Including Collection Types
Time-Dependency & State-Dependency
- Understanding Time & State in Data Models
- Building Time-Dependent Sub-Models
- Handling Person / Individual Roles Sub-Models
Classic Structures & Patterns
- Mastering Master-Detail-Detail Relationships
- Navigating M:N Recursion (Bill-Of-Materials)
- Exploring Organization Unit Hierarchies, Locations, and Contacts
Logical / Physical Model Transformation
- Introducing Physical Data Models
- Performing Physical Relational Transformations
- Real-World Model Transformation Example
- Automatic Transformation and Supertype Handling
RDBMS Implementation of the Physical Model
- Reverse Engineering a Physical Model
- Understanding the Relational Database
- Forward Engineering into an Implementation Relational Database
$1495.00
|
3 Days Course |