Overview
Teradata is a popular Relational Database Management System (RDBMS) suitable for large data warehousing applications. It is capable of handling large volumes of data and is highly scalable. This tutorial provides a good understanding of Teradata Architecture, various SQL commands, indexing concepts and Utilities to import/export data.
Pre-requisites
You should have a basic understanding of Relational concepts and basic SQL. It will be good if you have worked with any other RDBMS product.
Audience
This tutorial is designed for software professionals who are willing to learn Teradata concepts and become a Teradata developer. By the end of this tutorial, you will have gained intermediate level of expertise in Teradata.
Course Outline
- Teradata - Introduction
- What is Teradata?
- History of Teradata
- Features of Teradata
- Teradata – Installation
- Installation Steps for Windows
- Starting BTEQ
- Teradata – Architecture
- Components of Teradata
- Storage Architecture
- Retrieval Architecture
- Teradata – Relational Concepts
- Teradata – Data Types 6. Teradata – Tables
- Table Types
- Create Table
- Alter Table
- Drop Table
- Teradata – Data Manipulation
- Insert Records
- Insert from Another Table
- Update Records
- Delete Records
- Teradata – SELECT Statement
- WHERE Clause
- ORDER BY
- GROUP BY
- Teradata – Logical & Conditional Operators
- BETWEEN
- IN
- NOT IN
- Teradata – SET Operators
- UNION
- UNION ALL
- INTERSECT
- MINUS/EXCEPT
- Teradata – String Manipulation
- Teradata – Date/Time Functions
- Date Storage
- EXTRACT
- INTERVAL
- Teradata – Built-in Functions
- Teradata – Aggregate Functions
- Teradata – CASE & COALESCE
- CASE Expression
- COALESCE
- NULLIF
- Teradata – Primary Index
- Unique Primary Index (UPI)
- Non Unique Primary Index (NUPI)
- Teradata – Joins
- INNER JOIN
- OUTER JOIN
- CROSS JOIN
- Teradata – SubQueries
- Teradata – Table Types
- Derived Table
- Volatile Table
- Global Temporary Table
- Teradata – Space Concepts
- Permanent Space
- Spool Space
- Temp Space
- Teradata – Secondary Index Unique Secondary Index (USI) Non Unique Secondary Index (NUSI).
- Teradata – Statistics
- Collecting Statistics
- Viewing Statistics
- Teradata – Compression 24. Teradata – EXPLAIN
- Examples of EXPLAIN
- Full Table Scan (FTS)
- Unique Primary Index
- Unique Secondary Index Additional Terms .
- Teradata – Hashing Algorithm
- Teradata – JOIN INDEX
- Single Table Join Index
- Multi Table Join Index
- Aggregate Join Index
- Teradata – Views
- Create a View
- Using Views
- Modifying Views
- Drop View
- Teradata – Macros
- Create Macros
- Executing Macros
- Parameterized Macros
- Executing Parameterized Macros
- Teradata – Stored Procedure
- Creating Procedure
- Executing Procedures
- Teradata – JOIN Strategies
- Join Methods
- Merge Join
- Nested Join
- Product Join
- Teradata – Partitioned Primary Index
- Teradata – OLAP Functions
- Teradata – Data Protection
- Transient Journal
- Fallback
- Down AMP Recovery Journal
- Cliques
- Hot Standby Node
- RAID
- Teradata – User Management
- Users
- Accounts
- Grant Privileges
- Revoke Privileges
- Teradata – Performance Tuning
- Teradata – FastLoad.
- How FastLoad Works
- Executing a FastLoad Script
- FastLoad Terms
- Teradata – MultiLoad
- Limitation
- How MultiLoad Works
- Executing a MultiLoad Script
- Teradata – FastExport
- Executing a FastExport Script
- FastExport Terms
- Teradata – BTEQ
Programme scope, delivery arrangements and suitability are confirmed during enquiry.