TERADATA QUALITY TRAINING && COACHING IN ELEGENT IT SE IN INDIA

Teradata Quality training && coaching in elegent it services 1)Introduction to Teradata Warehount it se 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’ Elegant IT Services, #nd Floor, Aswath Nagar,Varthur main road, Opp Safal Fresh,Near Railway Fly Over Maratha halli,Bangalore - .Ph:-/87