selfpacedtech123 Posted November 5, 2018 Report Posted November 5, 2018 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] Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.