Data Modeling
1 Courses 2 Projects 17 Hours
Overview
In this Data Modeling course, you will learn all the concepts from basics to advanced which include Data Base Concepts, Attributes and Normalization,Relational Data Modeling, data warehouse and dimensional modelling and more. You will also gain expertise with industry projects and case-studies. Enroll now and get certified in data modelling course.
Course Fee
Key Features
- Flexible Schedule
- 24 x 7 Lifetime Support
- Certification
- Instructor Led Training
Curriculum
- Data Base Concepts
- RDBMS
- Cardinalities
- Normalization
- First Normal Form
- Second Normal Form
- Third Normal Form
- ACID
- Atomicity
- Consistency
- Integrity
- Durability
- Data Model
- What is a Data Model?
- Characteristics of Data Model
- Entity Relationships
- Entity Types
- Data Modeling Development Life Cycle
- 4 Phases of Modeling
- Logical Data Model
- Model Scenarios
- Model 1
- Model 2
- Model 3
- Dimensional Modeling
- Physical Data Model
- Practical Sessions
- Logical Model
- Relationships
- Cardinalities
- Physical Modeling
- Model Reports
- Data warehouse Concepts
- Evolution of Data warehouse
- Characteristics of Data Warehouse
- ER Model vs. Dimensional Modeling
- Inmon vs. Kimball
- Introduction
- Industry Specific Models
- Different Olap Types
- Meta Data Management(MDM)
- Business Glossary
- Data Vault
- Life Cycle of Dimensional Modeling
- What is a Data Mart
- Different Schemas
- OLTP vs. OLAP
- Hub and spoke architecture
- Dimension Tables
- Fact Column Types
- Grain
- Bus Architecture
- Slowly Growing Dimensions
- Slowly Changing Dimensions
- Outrigger Dimension
- Hierarchies
- Handling M X N Relationship Tables
- Different Types of Fact Tables
- Reports Types
- Drill Across
- Drill Through
- Cross Sell
- Up Sell
- Summations
- Aggregates
- Model Reports
- Modeling Tools
- Naming conventions & Standards
- Hands on ERwin tool
- Hands on Dimensional Modeling Scenarios
Certification
Data Modeling Certification
SLearn certification is awarded, after successful completion of the project work which shows that trainee have learned, achieved skills and experiences from the project. All the acknowledged trainees are therefore eligible for challenging projects and better job opportunities in MNC's like TCS, IBM, Cisco, Cognizant, Wipro, Dell etc.
Faq's
Other Courses
Free Career Counselling
We are happy to help you
- About Us
- Careers
- Blog
- Become an Instructor
- Corporate Training
- Contact Us
Useful Links
Copyright © 2021 SLearn - All Rights Reserved.