Classroom/Online Training in Datawarehousing


View AD / Training Features in Detail

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
Database Objects
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.
Data Staging
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
SQL Server

Seats are limited!


recently viewed ads/training

Classroom/Online Training in Datawarehousing

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 ba..


JAVA /J2EE Training
.NET Training
BI / Reporting Tool
Data Warehousing Training
Project Management Training
Business Analyst IT (BA) Training
QA / Testing tools
ERP Training
CRM Training
Database Training
All Trainings
SAS Training
SAP Training
Other Training
Tibco Training
Configuration Management Training
ORACLE Training
System Admin /Sys Admin Training
Six Sigma Training
SOX Sarbanes-Oxley Training
SOA / BPEL Training
SEO/ SEM--Search Engine Optimization /Marketing Training
Microsoft Technologies Training
Adobe Flex Training
Biz Talk Server Training
Ajax training
Visual Basics training
PHP training
VMware Training
Ruby on rails Training
Embedded Systems training Training
PeopleSoft Training
Google Technologies Training
Open source Training Courses
iPhone / iPad Applications Training
Web Development & Internet Training and Courseware
Clinical Training
WebSphere Training
ILOG JRules Training
SQL Server Training
Microsoft Collaboration Courses
Microsoft Database and Development Course
Microsoft Server and OS Administration Course
Recruiter / Staffing Specialist
Oracle Demantra training
ORACLE Database training
ORACLE eBusiness Suite (11i/R12) training
ORACLE Fusion Middleware training
ORACLE Database Administration training
ORACLE Datawarehouse training
Sharepoint Training
BizTalk Training
System / Network Administration Training
Hadoop Training
Big Data Training
Cloud Computing Training
Storage Area Network(SAN ) Training
BPM Training
ETL Training
Oracle Warehouse Builder (OWB) Training
spark training
apache hadoop training
Ambari Training
Cassandra training
greenplum training
hbase training
couchbase training
Mahout training
zookeeper training
avro training
chukwa training
MapReduce training
hdfs training
mongodb training
dynamodb training
nosql training
Hue Training
Oozie Training
Yarn Training
Mobile Development Training
Closed Source Development Training
kafka Training
Open Source Software/Web Training
OS Environments Training
Popular Frameworks training
Development Methods training
WebLogic Training
IBM Websphere MQ Training
IBM Websphere Server Training
Jboss AS7 EAP 6 Administration Training
Jboss 7 Administration Training
Jboss 8 Wildfly Administration Training
Oracle SOA Suite Training
SOA for Architects Training
Big Data Hadoop Development Training
Big Data Hadoop Administration Training
Big Data Hadoop Combo (Hadoop Dev+Admin+NoSQL+Solr+Lucene) Training
ServiceNow Training
Workday Training
DevOps Training
Mulesoft Training

Featured Trainings

 sap hybris   silk test   soa    coded ui   testcomplete   sap ess mss training   sap lso training   sap hana training   sap testing training   quality center training   webdynpro   sap pi   sap bi   sap ep   sap xi   sap fscd   sap scm   sap hcm   sap testing   sap mdm   sap e-recruitment   sap investment management   sap treasury training   sap pm training   sap hr-abap   abap hr curriculum   abap workflow   sap plm training   selenium training   java logging tools training   java power tools training   jdbc training   java messaging service   java security training   servlets training   spring mvc training   j2ee training   hibernate training   ejb training   eclipse training   agile training   websphere live online training   apache tomcat training   design patterns training   jsf training   java me training   software design training   java ee frameworks training   java web services training   jboss training   spring framework training   struts training   jsp training   java training   core java training   sap fscm training   sap sd-crm training   sap pp-qm training   sap bo training   sap portals training   sap is retail training   sap wm training   sap is oil & gas training   oracle project accounting   spring and hibernate training   java with flex training   sap grc training   sap fsm training   sap bobj training   sap is utility training