Teradata Fundamentals – Comprehensive SQL course on Teradata

Course Curriculum

Chapter 1: Teradata Getting Started

Lecture 1: Database Overview

Lecture 2: Teradata Installation and Teradata Studio(NEW VERSION)

Lecture 3: Create Database and Table in Teradata Studio

Lecture 4: Installation and Configuration Teradata Tools(OLD Version)

Lecture 5: Teradata Architecture

Lecture 6: Primary Index in Teradata

Lecture 7: Secondary Index in Teradata

Lecture 8: Multiset and Set Tables

Lecture 9: NOPI in Teradata

Lecture 10: Types of Spaces in Teradata

Lecture 11: Teradata SQL:Union and Union All

Lecture 12: Primary Index and Primary Key Difference

Lecture 13: Important Message..!!

Lecture 14: RAID Technology

Chapter 2: Loading Data into Teradata Vantage from Microsoft Azure Blob Storage

Lecture 1: Loading data into Vantage from Azure Blob Storage

Chapter 3: Brief Overview Teradata Administrator

Lecture 1: Create Database in Teradata Administrator

Lecture 2: Create a User in Teradata

Lecture 3: Create Profile for Users

Chapter 4: Teradata SQL Startup Lectures

Lecture 1: CREATE,INSERT,DELETE AND DROP COMMANDS

Lecture 2: ALTER and UPDATE Command

Lecture 3: Select Statement and Where clause

Lecture 4: Order by Clause

Lecture 5: EXTRACT Command

Chapter 5: String Manipulation in Teradata

Lecture 1: Concatenate Function

Lecture 2: Substring Function

Lecture 3: Index Function

Lecture 4: Trim Function

Lecture 5: Upper and Lower Function

Chapter 6: Basic Operators in Teradata SQL

Lecture 1: Arithmetic Operators

Lecture 2: AND Operator

Lecture 3: OR Operator

Lecture 4: Between Operator

Lecture 5: IN Operator

Lecture 6: Like Operator

Lecture 7: IS NULL Operator

Lecture 8: Practice Questions

Chapter 7: Aggregate Functions

Lecture 1: Overview of Aggregate Functions

Lecture 2: Having and Where Clause

Lecture 3: Aggregate Functions Practice

Chapter 8: Subqueries

Lecture 1: Subquery with SELECT statement

Lecture 2: Subquery with INSERT, UPDATE, and DELETE

Lecture 3: Correlated Subquery

Lecture 4: Correlated Subquery and Non Correlated Subquery

Chapter 9: Teradata SQL: Joins

Lecture 1: Inner Join,Outer Join and Cartesian Product Overview

Lecture 2: Self Join

Lecture 3: Join Practice Questions

Chapter 10: Analytical Functions

Lecture 1: Row Number

Lecture 2: Rank and Dense Rank Part 1

Lecture 3: Rank and Dense Rank Part 2

Lecture 4: Where,Having and Qualify Explanation and Difference

Lecture 5: Cummulative Sum,Moving Average and Moving Count Examples

Chapter 11: Teradata Advanced SQL Concepts

Lecture 1: Case Statement in SQL

Lecture 2: Coalesce Function

Lecture 3: Partitioning in Teradata

Lecture 4: Views in Teradata SQL

Lecture 5: Macros in Teradata SQL

Chapter 12: Teradata Standlone Utilities and Teradata Parallel Transporter(TPT)

Lecture 1: FastLoad Utility in Teradata

Lecture 2: MultiLoad Utility in Teradata

Lecture 3: BTEQ Utility in Teradata

Lecture 4: FASTEXPORT Utility in Teradata

Lecture 5: Teradata Parallel Transporter(TPT)

Lecture 6: Teradata Parallel Transporter(TPT) – TPTEXPORT

Chapter 13: SQL Exam

Chapter 14: Overview of Datawarehousing

Lecture 1: Overview of OLTP

Lecture 2: DataWarehousing Concepts

Lecture 3: Benefits and Limitation of Data Warehouse

Lecture 4: ETL in Data Warehousing

Lecture 5: ETL Vs ELT

Lecture 6: Dimensional Modeling Design Steps

Lecture 7: Star Schema,Snowflake Schema and Galaxy Schema

Lecture 8: Slowly Changing Dimension