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, a comprehensive program designed to equip you with profound insights and hands-on proficiency in the art of data modeling.
Whether you’re a seasoned business analyst, a skilled data modeler, an adept data analyst, an experienced data architect, or a proficient database administrator, this workshop is tailored to provide you with the indispensable skills necessary for crafting robust data models.
In our Data Modeling Workshop, we delve into a broad spectrum of methodologies and fundamental concepts that are directly applicable across diverse relational database environments.
These encompass well-known systems such as IBM DB2, Oracle, Microsoft SQL Server, MySQL, PostgreSQL, and many others. Furthermore, the expertise you acquire in this workshop extends beyond traditional relational databases, encompassing emerging technologies like object databases and even legacy IMS and IDMS databases.
Throughout the course, we’ll illustrate data modeling techniques using the versatile and freely available Oracle SQL Developer Data Modeler. However, the knowledge you gain is transferrable to other widely used data modeling tools, including IBM InfoSphere Data Architect, Erwin Data Modeler, and Embarcadero ER/Studio.
Whether you’re looking to hone your existing skills or embark on a journey to master the art of data modeling, our workshop promises to be an invaluable resource on your professional path. Join us to unlock the world of effective data modeling and elevate your proficiency in the realm of data management.
Workshop Objectives:
- Review model-based design, including process modeling, physical data modeling, and other related techniques.
- Compare data modeling concepts and theories, such as top-down and bottom-up data modeling, data normalization, and object-oriented modeling.
- Learn how to identify entities, attributes, and relationships crucial to a data model.
- Explore commercial data modeling tools in common use today.
- Understand the advantages of building a conceptual data model before diving into the logical model.
- Identify and rectify common mistakes in relationship definitions, attribute details, and unique identifiers.
- Dive into semantic and object-oriented modeling, including supertypes, subtypes, generalization, specialization, and more.
- Grasp time-dependency and state-dependency concepts within a data model.
- Explore classic data modeling structures and patterns, such as many-to-many recursion and organization unit hierarchies.
- Learn steps and options for transforming a logical data model into a physical data model.
- Gain proficiency in reverse engineering and forward engineering of a physical data model into an implementation relational database.
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 |