Data Analysis and Data Modeling Online Training|Training|Support- 3092003878

[Davidjhon]

21st Century Software Solutions Private Limited is the best Online Training providers worldwide with real time experts

Course Outline:

 

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

 

You can reach us @   3092003878 or Email us: [email protected]

 

[racharambola8]

On 9/3/2016 at 5:09 AM, Davidjhon said:

21st Century Software Solutions Private Limited is the best Online Training providers worldwide with real time experts

 

Course Outline:

 

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

 

You can reach us @   3092003878 or Email us: [email protected]

 

i tried many times..call was not connecting.