Data Analysis and Data Modeling online training | Data Analysis and Data Modeling | SelfpacedTech

[selfpacedtech123]

 

Data Analysis and Data Modeling Course Content

SQL

• Introduction to SQL
• SQL Operators
• SQL Constraints
• SQL JOINS
• SQL Aggregate Functions
• SQL Sub Queries
• SQL Index, View and Stored Procedure
• SQL Normalization
• SQL Analytic Functions

Data warehouse

• Introduction to Data warehouse
• OLTP
• OLAP
• Fact and Dimension
• Data warehouse Schema
• Star and Snowflake Schema
• EDW Environment
• Staging Area
• ETL mechanism
• E-R Model
• Dimensional Model
• Slowly Changing Dimension

Data Analysis

• Introduction to Data Analysis
• Understanding Data analysis process
• Understanding how to convert raw data into information useful information
• Data inspection
• Data Cleansing
• Data transformation
• Meta Data Management

 Data Profiling

• Data Profiling Introduction
• Data Profiling using manual method
• Data Profiling using database scripts
• Data Profiling using data profiling tool

 Mapping Document

• Purpose of mapping document
• Creating mapping document between source and target databases

Data Modeling Concepts

• Data Modeling Development Cycle
• Data Modeling Standards
• Steps to Create a Data Model
• Data Modeler Role
• Enterprise Data Modeling
• Conceptual Data Modeling
• Logical Data Modeling
• Physical Data Modeling
• Data Modeling Reports using Erwin
• Logical V/s Physical Data Modeling
• Relational Data Modeling / OLTP
• Dimensional Data Modeling / OLAP
• Relationships
• Data Model Versioning
• Working with Data Models
• What Is An Entity?
• What Is An Attribute?
• What Is A Relationship?
• What Is A Foreign Key?
• Creating a Data Model
• Enhance Your Data Model
• Splitting a Logical/Physical Data Model
• Derive a New Model
• Reverse Engineering
• Forward Engineering
• Creating New Design Layers
• Splitting a Model
• Deriving a Model
• Naming Standard

 Contact details: +1 416-834-6577 / +1 201-905-1656

 WhatsApp: 9030990003/9000444287

Mail: [email protected]/[email protected]