I am running the below online Data Modeling basic course as Freelancer. If anybody interested contact me at my below personal email ID.
pandit.san@gmail.com
pandit_26@yahoo.com
Data Modeling Course
Part 1 : Data Modeling
Building
What is Model?
Example of models
Advantages of using models
Modeling activities
What is a Subject Area?
Subject Area example by diagram.
Create a Subject Area
Diagram based on case study: Practical
What is an Entity?
Identify an Entity
Entity examples
Example of entity definitions
Difference between Entity and Entity instances
Identify Entity or
Entity Instances: Practical
How to find the Entities
Where to look for an Entity
What is a Relationship?
Definition and examples of Relationships
Relationship Cardinality
Relationship Cardinality Examples
Optionality of a relationship
How to write Relationship statements
Relationship Types
Identify the
relationships and cardinality: Practical
What is an Attribute?
Finding attributes
Attribute values
Attribute Source categories
Identify the
attributes for entities: Practical
Normalization
Benefits of Normalization
The Solution: Normal Forms
Rules of Normalization
First Normal form
How to make a table in 1 NF by Example
Make the table in 1
NF : Practical
Second Normal form
How to make a table in 2 NF by Example
Make the table in 2
NF : Practical
Third Normal form
How to make a table in 3 NF by Example
Make the table in 3
NF : Practical
Use the Normal form
technique to make the table till 3rd Normal Form : Practical
Key Concepts
Primary Key definition with example
Foreign Key definition with example
Technical Key definition with example
Candidate Key definition with example
Surrogate Key V/S Natural key
Quiz for Data Modeling
Building
Part 2 : Data
Modeling Concepts
Data Modeling Overview
A Sample Data Model
Data Modeling Advantages
Need for developing a Data Model
Data modeling tools
Data Modeling life cycle
Formal steps to create data models
Role of a Data Modeler
Conceptual Data Model life cycle
Conceptual Data Model Example
Conceptual Data Model
Case Study
Logical Data Model life cycle
Logical Data Model Example
Logical Data Model
Case Study
Physical Data Model life cycle
Physical Data Model Example
Physical Data Model
Case Study
Logical data Model V/S Physical Data Model
Data Modeling Standards
Apply the Data
Modeling Standards in Physical Data Model
Part 3 :
Dimensional Data Modeling Concetps
OLTP Data Modeling
Example of OLTP Data Model
OLTP Data Model :
Case Study
What is Dimensional Modeling?
Example of Dimensional
Modeling
OLAP/Dimensional Data
Model : Case Study
OLTP V/s OLAP data Models ?
Dimension Table
Dimension Table Examples
Dimension Table :
Case Study
Fact Table
Fact Table Example
Fact Table : Case
Study
Slowly changing dimensions
Slowly changing dimension Type 1 example
Slowly changing dimension Type 2 example
Slowly changing dimension Type 3 example
Slowly changing
dimension Case Study
Star Schema
Star Schema Example
Star Schema : Case
Study
Snow flake Schema
Snowflake Schema Example
Snowflake Schema : Case
Study
Difference between Start Schema and Snow Flake schema
Fact Constellation
Fact Constellation Example
Fact Constellation :
Case Study
Conformed Dimensions
Conformed Dimension Example
Conformed Dimension :
Case Study
Fact less Fact Table
Fact less Fact Table Example
Junk Dimension
Junk Dimension Example
Junk Dimension : Case
Study
Degenerated Dimensions
Degenerated Dimensions Example
Degenerated
Dimensions Case Study
Additive, Non Additive and Semi Additive Facts
Examples of Additive, Non Additive and Semi Additive Facts
What is Data warehouse?
What is the overall end to end process to create the Data
warehouse?
Difference between the dependent and independent data
warehouses
What are data marts?
What are the approaches to create the Data Marts?
Part 4 : Quiz ,
Projects and Erwin tutorial
Quiz based on Part 1, Part 2 and Part 3
Erwin Tutorial
- Creation of Conceptual Data Model
- Creation of Logical Data Model
- Entities, Attributes and Relationships
- Identifying and Non Identifying relationships
- Creation of Physical Data Model
- Creation of Database with SQL Scripts
- Use of NSM file
- Generate the Data Dictionary
- Erwin reports
- How to convert Logical Data Model into Physical Data Model
Project 1: Creation of CDM,LDM, PDM,scripts based on given
business case
Project 2: Creation of Data warehouse Data Model/Dimensional
Data Model based on given business case
Briefing of Industry Specific Data Models : Any Industry
could be referred.
Quiz based on part 1 , 2 and 3
MS Access DB use for the Dimensional Modeling Exercises and
write the simple SQL
Any questions ?
