This 18-hour instructor-led course offers an in-depth look at data modeling. You gain hands-on experience in building a Data Model and will be better prepared to determine how to design and implement the best data structures through a formal process from the conceptual, logical, and physical phases of data modeling to support business processes.
At the end of this course, you should be able to:
How data modeling and data mapping are used to represent expert business knowledge
Develop a relational database design from a simple entity relationship diagram
Query, manipulate, and report on data stored using leading database
Create and maintain tables and views
WHO SHOULD ATTEND?
Understanding of entity-relationship modeling
The Value of Modeling
Data Modeling Concepts
Data Entity Types
Conceptual Data modeling for Business Requirements
Entities, Attributes and Relationships
Cardinality and Domains
Supertypes, Subtypes and their proper use
Integrating Data Models and Use Cases
Logical Data Modeling
Creating physical models based on logical models
Reverse Engineering Databases
Creating DDL and DML
Working with Indexes and Views
Transforming XML Schemas
Enrollment is limited to 20 attendees.
The program course contents are delivered either only evening time or at the weekends or in combination of both.