Overview:
Data modeling is the act of exploring data-oriented structures. When building a database, data modeling implies the creation of a model for data within that database. Data models can be used for a variety of purposes, from high-level conceptual models to physical data models.
In this class, get hands-on practice modeling requirements through entity relationship diagrams, supertypes and subtypes, and attributive and associative entities. You will learn to use logical data modeling to work directly with business users to accurately define requirements.
Audience:
Systems analysts, business analysts, IT project managers, associate project managers, project managers, project coordinators, project analysts, project leaders, senior project managers, team leaders, product managers, and program managers.
Pre-Requisite:
exposure of RDBMS concepts, working knowledge of basic SQL.
Course Curriculum
| Data Modeling in today’s world | |||
| The value of data modeling Details | 00:00:00 | ||
| Where does data modeling fit? Details | 00:00:00 | ||
| Role and responsibilities of the data modeler Details | 00:00:00 | ||
| Choice and creativity in data modeling Details | 00:00:00 | ||
| What makes a good data model? – Quality criteria and trade-offs Details | 00:00:00 | ||
| What makes a good data modeler? Details | 00:00:00 | ||
| Data modeling and object oriented techniques Details | 00:00:00 | ||
| Data modeling and extended RDBMSs Details | 00:00:00 | ||
| Data modeling and packaged software Details | 00:00:00 | ||
| Working with Generalization | |||
| Subtypes and Supertypes Details | 00:00:00 | ||
| Exploring alternatives Details | 00:00:00 | ||
| Tradeoffs and implementation options Details | 00:00:00 | ||
| Generalization of attributes Details | 00:00:00 | ||
| Attributes and Columns | |||
| Getting attributes under control Details | 00:00:00 | ||
| Domains and types Details | 00:00:00 | ||
| Dealing with complex attributes Details | 00:00:00 | ||
| Keys and identity | |||
| What makes a good primary key? Details | 00:00:00 | ||
| Issues with structured keys Details | 00:00:00 | ||
| Independent and Dependent Entities Details | 00:00:00 | ||
| Weak and Regular Keys Details | 00:00:00 | ||
| Surrogate keys Details | 00:00:00 | ||
| Issues with foreign keys (split, derivable, multiple) Details | 00:00:00 | ||
| Normalization Revisited | |||
| Normalization – myths and misunderstandings Details | 00:00:00 | ||
| Beyond Third Normal Form Details | 00:00:00 | ||
| Problems that normalization won’t fix Details | 00:00:00 | ||
| Alternatives and Extensions to Notations | |||
| Practical issues with notations Details | 00:00:00 | ||
| UML vs E-R and other alternatives Details | 00:00:00 | ||
| Transferability Details | 00:00:00 | ||
| The Time Dimension | |||
| Key principles Details | 00:00:00 | ||
| The audit trail approach Details | 00:00:00 | ||
| The snapshot approach Details | 00:00:00 | ||
| The Data Modeling Project | |||
| Stages and Deliverables – defining the boundaries Details | 00:00:00 | ||
| A project planning check list for data modelers Details | 00:00:00 | ||
| Choosing the right tools Details | 00:00:00 | ||
| Managing change Details | 00:00:00 | ||
| Understanding User Requirements | |||
| How do we document requirements? Details | 00:00:00 | ||
| Effective interviews and workshops Details | 00:00:00 | ||
| Using a class hierarchy Details | 00:00:00 | ||
| Conceptual Modeling | |||
| The conceptual modeler’s tool-kit Details | 00:00:00 | ||
| Business rules Details | 00:00:00 | ||
| Using patterns Details | 00:00:00 | ||
| Verifying the model with users Details | 00:00:00 | ||
| Logical Database Design | |||
| Conceptual to Logical – understanding and managing the mapping Details | 00:00:00 | ||
| Implementing Subtypes Details | 00:00:00 | ||
| Dealing with Classifications Details | 00:00:00 | ||
| Common problems and solutions Details | 00:00:00 | ||
| Physical Design and the Data Modeler | |||
| Overview of tradeoffs Details | 00:00:00 | ||
| Making an effective contribution to the physical design phase Details | 00:00:00 | ||
Course Reviews
No Reviews found for this course.