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.
Course Content:
- OLTP vs OLAP – terminology
- EDW – Enterprise Data Ware House
- Operational System
- Data Ware House
- Definition
- Characteristics
- Features
- Benefits
- Application Areas
- Data Ware House Architecture
- Details of different layers
- Implementation
- DWH Vs Operational Data Sources
- Data Marts
- DW Key Business Needs
- Features
- Types
- Advantages
- Data Modelling techniques – High Level
- Facts 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
Flexible Class Options
- Morning | Evening Classes | Workshops | Fast-Track
- Week End Classes For Professionals SAT | SUN
- Online Classes – Live Virtual Class (L.V.C), Online Training