Concepts that will teach in the duration.
*DWH Concepts*
Referrential integrity
What is DWH
What is Database
Char's of DWH
OLTP
OLAP
ETL Development process
DWH Build approaches
Datamart and types
DWH Logical Architectures(schema)
Dimensions and types
Facts and types of facts
Types of fact tables
ETL Architecture with stages
Types of operations performed in staging area
Data Model
ODs
Project Environment
Interview questions
*SQL
Types of statements
DDL
DML
DCL
TCL
It includes almost 13 statements
Select statement
Sorting
Distinct
Operatos
Arithmentic operators
Logical operators
Comparision operators
Functions
Which includes 18 statements
Aggregate functions
Combination of aggregate and non-aggregate functions
Constraints
Which includes 4
Few points to be noted
Types of Joins
Set Operators
OLAP Functions
*===============* DWH,SQL,HP-ALM,INFORMATICA,UNIX
Basics of UNIX
*=================*