Read more
2Months/20 Hours Price:35,000
30,000
How to Setup Data Warehouse
Database Management Essentials provides the foundation you need for a career in database development, data warehousing, or business intelligence, as well as for the entire Data Warehousing for Business Intelligence specialization. In this course, you will create relational databases, write SQL statements to extract information to satisfy business reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy. As you develop these skills, you will use either Oracle or MySQL to execute SQL statements and a database diagramming tool such as the ER Assistant to create ERDs. We’ve designed this course to ensure a common foundation for specialization learners. Everyone taking the course can jump right in with writing SQL statements in Oracle or MySQL.
Data Warehouse Basics
Data Warehouse architectureData Warehouse infrastructure
Data Modeling
Setting up an ETL process
EDW – Enterprise Data Ware House
Operational System
Data Ware HouseDefinition
Characteristics
Features
Benefits
Application Areas
Data Ware House ArchitectureDetails of different layers
Implementation
DWH Vs Operational Data Sources
Data MartsDW Key Business Needs
Features
Types
Advantages
Data Modelling techniques – High LevelFacts and Dimensions
Surrogate Keys
Slowly changing dimensions
Star Vs Snowflake Schema
Understanding ETL Tool
Data Transformation
Basics of Meta Data
Basics of BI
Who Should Attend
IT Analyst / Data Analyst / Business Consultants
IT Managers / DBA / SQL Developers
Enterprise Architects / Database Architects
Training Track: DW – Corporate
Job Interview Preparation (Questions & Answers)
Tough Open-Ended Job Interview Questions
What to Wear for Best Job Interview Attire
Job Interview Question- What are You Passionate About?
How to Prepare for a Job Promotion Interview
Stay Connected Even When You’re Apart
0 Reviews