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
4.00/5
1 reviews
Price:
₹ 0,00
₹ 0,00
Contact
CONTACT