What you'll learn

Introduction to Teradata
Lifecycle of a Query
CREATE, INSERT, DELETE, UPDATE etc.
INDEX
MVC, BLC, ALC
VIEWS, MACROS, JOINS
BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT

Requirements

Relational Concepts of databases
Basics of SQL
Database Management theory and technology

Description

The course covers the following Topics:

Teradata Architecture,
Space management and data protection,
Data Distribution,
Indexing and Explain Plan development,
Teradata SQL,
Performance turning and query optimization,
Teradata utilities and best practices,

The course covers teradata in detail with examples-

Sessions are theoretical as well as practical.
Examples used are from real life project scenarios.
Animated and pictorial PPT slides for better understanding of concepts.
Very Interactive sessions with best audio and screen sharing.
Emphasis on teaching concepts, rather than just covering topics.
Practical sessions are done by sharing the Teradata environment on trainers screen and showing the exact way of doing things in Teradata Client Software.

Who this course is for:

Beginner and advanced both