Video Duration : 21 hours
Quizes : ( 70+ Questions)
ONE Mock Test ( 40 questions)
ONE Month Video View Access.
PDF Material for each topic can be downloaded.
Check out Course Contents given below:
- Dimensional Data Modeling Concepts
- Data Modeling Introduction
- Data Modeling - Application Development Cycle
- Introduction to Data Warehouse
- Operational Data Store
- Data Mart
- Difference between OLTP Database & Warehouse Database
- Normalization
- First normal form
- Second Normal Form
- Third Normal Form
- Design levels
- Conceptual model
- Logical model
- Physical model
- Subject area model
- Case Study for Design Levels
- Types of Dimensional Data Model
- Star Schema
- Snow Flake
- Introduction to Dimension Tables
- Slowly Changing Dimensions
- SCD-Type 1
- SCD-Type 2
- SCD-Type 3
- Fast changing dimensions
- Junk Dimensions or Garbage dimensions
- Measures and Facts
- Facts
- Additive
- Semi-additive
- Non-additive
- Factless Fact Tables
- Hierarchies & Levels
- Identify the Grain
- Validating model for standards
- FAQ
- Case Study
------------------
Erwin Tool:
----------------------
- Introduction to Erwin Tool
- Installation and configuration of Erwin and Notation
- Creation of Entities and attributes
- Creation of Relationships, Degree, Cardinality
- Understanding constraints (PK,FK) in Erwin tool
- Creation of Domains , Default Values, Validation rules
- Creating Diagrams, Themes
- Creating Conceptual model
- Creating Logical model
- Creating Physical model
- Creating Subject area model
- Generating Scripts from Physical Model
- Naming standards Implementation
- Datatype Standards Implementation
- Building reports and Printing in erwin
- Forward Engineering
- Reverse Engineering
- Complete compare of models/schema
- Bulk Editor
- Generating diagram in Picture format
- Adding auditing columns using -Forward Engineering Template
- Adding auditing columns using -Script Template
- Vertical Partitioning in Erwin
- import excel into erwin using erwin api/macro
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Contact :
info@dbvidya.com
+91 991 2323 000(whats app also)
www.dbvidya.com
www.dbvidya.com/blog
