About Teradata

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.

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

Send a Query









Tai Infotech Pvt Ltd, 2017 All Rights Reserved