Sansa Technology is starting next Datawarehousing training and SQL Server Training batch in Fremont, CA(close to San Jose,Santa Clara).
We offer quality learning for your success. Our courses are based on a strong, systematic curriculum. You will learn from industry experts.
Proven training programs with excellent track record.
Excellent placement record.
Courses tailored for job placements and Interview success.
One of the finest instructors in the Bay Area.
Exceptional marketing staff.
Excellent Opportunity for all F-1 / OPT/ CPT/ and L2 / H4 residents.
Small Class Room for Personalized Attention.
Resume and Interview Preparation.
Now Available in a new facility with lab, remote access 24/7, day/evening sessions, classroom/live online training available.
Please email to find more details.
DWH Syllabus Highlights
Data Warehouse concepts.
What is OLAP and OLTP?
What is Data Warehouse?
OLTP Vs Data Warehouse?
Where was this Data Warehouse before?
How is Data Warehouse evolved?
Why do you need Data Warehouse?
How do you build Data Warehouse?
Data Warehousing Technology Overview – Part I
Definitions and descriptions
Data Warehouse Architecture
Storing Values in any database
Introduction to BI tools
Introduction to ETL tools
Introduction to different Database
Data Warehousing Technology Overview – Part II
Data Warehouse – Infrastructure
Top Down Vs Bottom Up Approach
Data Warehouse Vs Data Marts
Standalone Data Marts
Enterprise Data Warehouse
Operational Data Store (ODS)
Front end architectures—OLAP, ROLAP, MOLAP, HOLAP
What is Data Modeling?
Relational Data Modeling Vs Dimensional Data Modeling?
Physical Vs Logical Modeling?
Reverse Engineering Vs Forward Engineering?
Physical Database Design
Star Schema Vs Snow Flake Schema
Facts & Dimensions
Type 1, Type 2 and Type 3 SCD updates.
Surrogate key Concept.
Basic ETL Techniques
Data Warehousing Management
Identify warehouse requirements
Plan and create a data warehouse
Maintain a data warehouse
Choose warehouse features based on requirements
Provide the proper hardware and software support for a data
Match business requirements to warehouse features
Overview of few popular Databases
Seats are limited!
Recents Ads for Data Warehousing Training..