This Advanced Teradata SQL course is designed to provide students with more sophisticated usages of the Teradata database. While it does incorporate more functionality associated with the SELECT, it goes beyond data mining to include data maintenance.
Additionally, it focuses on techniques that provide a high degree of flexibility as well as performance opportunities. This course uses methodologies to enhance data integrity as well as looking for opportunities to enhance performance of queries. This course is designed for experienced SQL users.
About Teradata
Objectives
Upon completion of the Advanced Teradata SQL course, students will be able to:
Increase overall knowledge and experience with Teradata
Describe the EXPLAIN
Increase SQL proficiency
Apply performance advantages related to transactions
List and apply alternatives, tricks and techniques for data mining
Who can take this training?
IT Professionals
Prerequisites
Successful completion of CFLQ-105 Teradata SQL course or equivalent knowledge
Strong experience in using SQL
Course Content
Subquery Processing
Correlated subqueries only
Joins
Joins with correlated subquery (inner and outer joins)
Set Operators
INTERSECT
UNION
EXCEPT
DML Statements
INSERT
INSERT / SELECT
UPDATE
DELETE
Data Interrogation
CASE only
Transaction Processing
Transactions defined
Locking
Multi-statement operations
CREATE TABLE
Data types
Attributes
Constraints
PPI and Identity columns
Secondary index definitions
COLLECT STATISTICS
Hash functions
Temporary Tables
Derived tables
Volatile tables
Global tables as needed
Stored Procedures
SPL
Variables and parameters
Single row selection vs multi-row via cursor
New SQL version of SELECT
Dynamic SQL
Call Now- +91-921-276-0556
