Learning Resources
Introduction
- Evolution of data mining and warehousing
- Basic Terminologies Data marts data stores etc
- Architecture Types
- Components and Metadata role
Value Proposition
Strategy and Planning
Requirements
Design
Dimensional Modeling in Data Warehousing
- Data design and dimensional modeling
- Star Schema star schema keys and advantages
- Snowflake schema aggregate fact tables and families of stars
Metadata for Data Warehousing
ETL Extraction Transformation and Loading
- ETL Need and factors
- Data Extraction Techniques
- Data Transformation types and dimensional attributes
- Data Loading types and modes
Data Quality
OLAP Online analytical processing
Data Mining
Decision Trees for Data Mining
Association Rules Mining
Neural Networks and Data Mining
Cluster Discovery
Implementation
- Physical Design
- Physical Storage SAN RAID etc
- Indexing B Tree Clustered etc
- Data partitioning and clustering for performance
Post Implementation
- Security Policy user privileges and security tools
- Backup and Recovery
- Monitoring and managing data growth
Apply for Certification
https://www.vskills.in/certification/Certified-Data-Mining-and-Warehousing-Professional