| |
TERADATA
|
| |
DATA WAREHOUSING CONCEPTS |
| |
|
| |
- About Data Warehouse & Data Warehousing
- Active Warehouse & Passive Warehouse
- Data Warehouse Usage Evolution
- OLTP,DSS,OLAP & OLCP
- SDLC ( DWD Life cycle )
- Schema Types ( Star, Snow etc....)
- Characteristics of Dimension & Fact tables
- ETL Process & Cleansing ( Parsing,Correcting,standardize,matching and Consolidate)
- ER & Dimensional Model Overview
|
| |
|
| |
INTRODUCTION TO TERADATA |
| |
|
| |
- Unique Features of Teradata
- Teradata System
- Node Components
- SMP & MPP
- BYNET Hardware & Software
- Communication Between Nodes
- Teradata maximums
|
| |
|
| |
TERADATA ARCHITECTURE |
| |
|
| |
- Architectural Flow
- Shared Nothing Architecture
- PE with Explain
- Visual Data Layout
|
| |
|
| |
PRIMARY INDEX |
| |
|
| |
- Purpose of Primary Index
- Non Unquie Primary Index
- Unique Primary Index
|
| |
|
| |
SECONDARY INDEX |
| |
|
| |
- Purpose of Secondary Index
- Unquie Primary Index
- Non Unique Primary Index
|
| |
|
| |
|
| |
CREATING TABLES SYNTAX |
| |
|
| |
- Purpose of Primary Index
- Non Unquie Primary Index
- Non Unique Secondary Index
|
| |
|
| |
CREATING TABLES SYNTAX |
| |
|
| |
- General Create Table Syntax
- Teradata Create Table Syntax
- Create Set Tables
- Create MultiSet Tables
- Copy Table to Table
- Partitio Primary Index Tables
- Partition With CASE ,RANGE
|
| |
|
| |
TERADATA SQL |
| |
|
| |
- SQL Basics
- Teradata Punctuation
- Help,Show,Explain
- Working With Nulls
- And,Or, Not,Between & Like
- Aggregates
- Sub Queries & Co-related Sub Queries
- Aliasing,Title,Cast & Format
- Interrogating Data
|
| |
|
| |
TYPES OF TABLES |
| |
|
| |
- Set and Multiset Tables
- Volatile Tables
- Derived Tables
- Global Temporary Tables
|
| |
|
| |
TERADATA SPACE |
| |
|
| |
- Perm Space
- Spool Space
- Temp Space
- Performance Tuning with Spaces
|
| |
|
| |
JOINS |
| |
|
| |
- Join Types (Inner,Outer & self)
- Join Strategies (Merge, Nested,Exclusion & Product Joins )
- Join Index ( Single & Multi Table )
|
| |
|
| |
SET OPERATORS |
| |
|
| |
- Union/Union All
- Intersect
- Except or Minus
|
| |
|
| |
VIEWS |
| |
|
| |
- Purpose of View
- Create View Syntax
- Usage
|
| |
|
| |
MACROS |
| |
|
| |
- Purpose of Macro
- Create Macro Syntax
|
| |
|
| |
DATE AND TIMES |
| |
|
| |
- Teradata Key words
- Storage of dates on Disk
- DATEFORM
- ADD_MONTHS Command
- EXTRACT Command
- System Calender
- System Calender with Date Comparison
- INTERVAL Processing with Date and Time
|
| |
|
| |
RANK FUNCTION AND QULIFY USAGE |
| |
|
| |
- Rank Functions
- Qualify Usage
- Rank with OLAP functions
|
| |
|
| |
OLAP FUNCTIONS |
| |
|
| |
|
| |
|
| |
TERADATA UTILITIES |
| |
|
| |
- MLOAD
- FLOAD
- FAST EXPORT
- BTEQ
|
| |
|
| |
LOCKS |
| |
|
| |
- Exclusive
- Write
- Read
- Access
|
| |
|
| |
PROTECTION FEATURES |
| |
|
| |
|
| |
|
| |
STORED PROCEDURE |
| |
|
| |
PERFORMANCE TUNING
|
| |
|
| |
PROJECT EXPLANATION |
| |
|
| |
- Spec's Overview
- Working with All Utlities
- SCD Implementations
|
