Teradata Class Room / Online Training From Elegant IT Servic

Teradata Class Room / Online Training From Elegant IT Service.

1) Introduction to Teradata Warehouse
 Basics
 Parallel Design and Architecture

2) Data Distribution in Teradata
 Primary Index and its Types
 Secondary Index and its Types
 Partition Primary Index and its Types
 No Primary Index

3) Teradata Space
 Perm Space, Spool Space and Temp Space

4) Teradata Data Protection
 Concept of Transient Journal
 FALLBACK
 Clusters
 Down AMP Recovery Journal (DARJ)
 RAID
 CLIQUES

5) Teradata Locks
 Different Types of Locks and their Compatibility

6) Teradata Utilities
 Fast Export
 Fast Load
 TPUMP
 Multiload
 TPT

7) Teradata Utilities Commands
 SHOW
 HELP

8) Teradata-Basic SQL
 SELECT Command
 Usage of NULL in Comparison Operator
 Usage of IS NULL and IS NOT NULL
 Usage of IN and NOT IN
 Range search – BETWEEN Operator
 Creating Aliases
 Derived Columns
 Usage of GROUP BY, ORDER BY and HAVING CLAUSE

9) Teradata SQL – Five Aggregate Functions
 Usage of SUM function
 Usage of AVG function
 Usage of MIN function
 Usage of MAX function
 Usage of COUNT function

10) Teradata SQL – Interrogating Data / Data Transformations
 Data Formatting
 CAST
 NULLIFZERO, ZEROIFNULL and NULLIF
 COALESCE function
 CASE function

11) Formatting Date and Time
 Display Current Date, Time and Timestamp
 Extract function

12) Teradata SQL – String Manipulation
 TRIM function
 SUBSTRING function
 POSITION function
 INDEX function
 Concatenation function

13) Teradata OLAP functions
 CUMULATIVE function
 MOVING AVERAGE function
 Usage of OVER/Partition BY Clause
 RANK function
 SAMPLE function
 RANDOM function

14) Teradata DDL, DML, DCL
 CREATE TABLE – SET and MULTISET
 Constraint – UNIQUE and CHECK
 Data Compression
 CREATE Table with existing table
 ALTER, DROP, RENAME a table
 INSERT, UPDATE, DELETE command

15) Temporary Tables – Volatile and Global
 Volatile Temporary Table with example
 Global Temporary Table with example

16) Teradata – View, MACROS and Stored Procedures

17) Displaying TOTALS and SUBTOTALS in Reports
 Totals and SubTotals
 Total using WITH
 Subtotals using WITH BY clause

18) Teradata JOINS
 Why Joins ?
 LEFT OUTER JOIN
 RIGHT OUTER JOIN
 INNER JOIN
 CROSS JOIN
 SELF JOIN
 Join Strategies :
• Duplication – Big Table Small Table
• Redistribution – Big Table Small Table
• Same AMP Join

19) Join Index – Denormalization in Teradata
 Single Table Join Index
 Multi-Table Join Index
 Aggregate Join Index
 Sparse Join Index
 Global Join Index
 Hash Index

20) Collect Statistics and Explain
 Collect Statistics
 Sample Collect Statistics
 Usage of Diagnostic HELP ON
 Explain – Decrypting the Optimizer Plan

21) Performance Tuning in Teradata – ‘TIPS and TECHNIQUES’

Thanks&Regards
Elegant IT Services,
#352, 2nd Floor,Aswath Nagar
Varthur main road,Near Railway Fly Over
Maratha halli,Land mark : Chemmunar Jewellers,
Bangalore - 560037.Ph:-9886541264/87