Master Teradata- A Complete Course on Teradata

Course Curriculum

Chapter 1: Module-1 Introduction to the Course

Lecture 1: Introduction to TeraData

Lecture 2: Prerequisites

Lecture 3: History of TeraData

Lecture 4: Characteristics of TeraData

Lecture 5: Architecture of TeraData

Lecture 6: Relational Concepts

Lecture 7: Datatypes

Lecture 8: Life cycle of a Query

Lecture 9: Installation of Teradata

Lecture 10: Introduction to Tables

Lecture 11: Create Table Command

Lecture 12: Alter Table Command

Lecture 13: Drop Table Command

Lecture 14: Insert Records

Lecture 15: UPDATE Records

Lecture 16: DELETE Records

Lecture 17: SELECT Statement

Lecture 18: WHERE Clause

Lecture 19: ORDER BY

Lecture 20: GROUP BY

Lecture 21: Logical and Conditional Operators

Lecture 22: SET Operators and UNION

Lecture 23: UNION ALL

Lecture 24: INTERSECT

Lecture 25: MINUS or EXCEPT

Lecture 26: String Manipulation

Lecture 27: Date and Time Function

Lecture 28: Built in Functions

Lecture 29: Aggregate Functions

Lecture 30: CASE, COALESCE and NULLIF

Lecture 31: Primary Index

Lecture 32: Joins

Lecture 33: Subqueries

Lecture 34: Permanent Journal

Lecture 35: Recovery Journal

Lecture 36: Locks

Lecture 37: Pseudo Locks

Lecture 38: Explain Plan

Lecture 39: Table Types

Lecture 40: Space Concepts

Lecture 41: Secondary Indexes

Lecture 42: Statistics

Lecture 43: MVC

Lecture 44: BLC

Lecture 45: ALC

Lecture 46: Hashing Algorithm

Lecture 47: Join Index

Lecture 48: Views in Teradata

Lecture 49: Macros

Lecture 50: Join Strategies

Lecture 51: Partitioned Primary Index(PPI)

Lecture 52: OLAP Functions

Lecture 53: Data Protection

Lecture 54: User Management

Lecture 55: Performance Tuning

Lecture 56: BTEQ

Lecture 57: Fastload

Lecture 58: Multiload

Lecture 59: FastExport