- Teradata Components.
- The Parser (Parsing Engine).
- Access Module Processor (AMP).
- Message Passing Layer (BYNET).
- Primary Index and Secondary Index.
- Fundamental Structured Query Language (SQL)
- The SELECT Command
- SELECT Command with DISTINCT Function
- Limiting Rows with WHERE Clause
- Comparisons Operators ( AND / OR )
- Usage of NULL in Comparison Operators
- Usage IN and NOT IN.
- Usage of ANY and ALL with IN.
- Range of Value Search with BETWEEN.
- Similar Character String Search using LIKE operator.
- What are Derived Columns?
- Creating Aliases.
- Usage of GROUP BY and ORDER BY Clause.
IV. Data Transformations
- Data Conversions using CAST
- Implicit and Explicit Casting.
- Data Formatting.
- NULLIFZERO
- NULLIF
- ZEROIFNULL
- COALESCE
- CASE
- Usage of SUM Function with Example.
- Usage of AVG Function with Example.
- Usage of MIN Function with Example.
- Usage of MAX Function with Example.
- Usage of COUNT Function with Example.
VI. Join Algorithms
- INNER JOIN
- Ordinary Inner Join
- Cross Join
- Self-Join
- OUTER JOIN
- Left Outer Join
- Right Outer Join
- Full Outer Join
VII. Formatting Date and Time
VIII. String Manipulations
- CHARACTERS Function
- TRIM Function
- SUBSTRING Function
- POSITION Function
- INDEX Function
- Concatenation of Character Strings
IX. Ordered (OLAP) Analytical Computations
- What are OLAP or Ordered Functions
- Usage of Cumulative Function
- Usage of Moving Average Function
- Working Out Examples
- Usage of OVER / PARTITION BY Clause
- How to Ranking Data using RANK
- See Sample Data with SAMPLE Function
- Usage of RANDOM Function
- Usage of Set Operators
- The INTERSECT Operators
- The UNION Operators
- The EXCEPT Operators
- The MINUS Operators
XI. Data Manipulation
- Using INSERT Command
- Using NULL as DEFAULT VALUES
- INSERT with SELECT Command
- The UPDATE Command
- The DELETE Command
XII. Data Definition
- CREATE TABLE syntax.
- PRIMARY INDEX considerations
- SET and MULTISET Tables
- Constraints
- UNIQUE Constraint
- CHECK Constraint
- CREATE TABLE from an existing table
- Altering a Table
- Dropping a Table
- Drop versus Delete
- Renaming a Table
XIII. Temporary Tables
- Types of Temporary Tables
- Volatile Tables
- Global Temporary Tables
XIV. Working with View
- VIEW Basics
- Creating VIEWS
- Deleting VIEWS
- Modifying VIEWS
- What is a Macro
- CREATE MACRO
- EXECUTE MACRO
- DROP MACRO
XVI. Displaying Totals and Subtotals in Reports
- Totals and Subtotals
- Totals Using WITH
- Subtotals Using WITH BY Clause
XVII. Working with Trigger
- What are Triggers
- CREATE TRIGGER Syntax
- Row level Trigger
- Statement level Trigger
- The BEFORE Trigger
- The AFTER Trigger
- The INSTEAD OF Trigger
XVIII. Working with Stored Procedures
- Stored Procedures in Teradata
- CREATE PROCEDURE Syntax
- BEGIN / END Statements
- HELP on a Stored Procedure
- REPLACE PROCEDURE
- DROP PROCEDURE
- RENAME PROCEDURE
- SHOW PROCEDURE
- What is a Transaction
- Available Transaction Modes
- Processing a Transactions
