Course Code: tdpbsp
Duration: 98 hours
Prerequisites:

.

Overview:

.

Course Outline:

•                     Introduction to Database

•                     Introduction to Teradata

•                     Introduction to SQL

·         •            

•                     Database Concepts

•                     Data Warehouse Architecture

•                     Teradata Architecture and Components

•                     Data Distribution and Access

•                     Secyurity and Privacy

•                     Teradat Tools and Utilities

•                     Tables (DML)

•                     Basic SQL Functions

•                     Advanced SQL Functions

•                     Joins

·         •            

•                     Advanced Teradata Architecture

•                     Indexes

•                     Querying Efficiently

•                     Joining of Tables

•                     Statistics

•                     Teradata SQL Functions

•                     Date and Time Functions

•                     Aggregation

•                     Online Analytical Processing

•                     Recursive Queries

•                      

•                     Exam Prep and Self Learning