Teradata Tutorial

What is Teradata Tutorial?

Teradata is widely used Relational Database Management System (RDBMS) used for large data warehousing applications. It handles huge data and highly scalable. This tutorial is meant for providing basic knowledge on Teradata Architecture, various SQL commands, Indexing concepts and Utilities to import/export data.


This tutorial is useful for software professionals who wish to seek Teradata concepts to be a Teradata developer. You are assures to promote to next level once you complete this tutorial.


To learn this tutorial one must be familiar of Relational concepts and basic SQL. It will be an added advantage if you have worked with any other RDBMS product.

Teradata Parallel Architecture Teradata Introduction Teradata Architecture A Teradata Database Teradata Users Symbols Used In This Book Database Command Use Of An Index Fundamental Sql Using Select Fundamental Structured Query Language (sql) Basic Select Command Where Clause Compound Comparisons ( And / Or ) Impact Of Null On Compound Comparisons Using Not In Sql Comparisons Multiple Value Search (in) Using Quantifiers Versus In Multiple Value Range Search (between) Character String Search (like) Derived Columns Creating A Column Alias Name Syntax Of Order By Distinct Function On-line Help And Show Commands Help Commands Show Commands Explain Adding Comments User Information Functions Data Conversions Data Conversions Teradata Data Types Cast Implied Cast Formatted Data Title Attribute For Data Columns Transaction Modes Case Sensitivity Of Data Casespecific Lower Function Upper Function Aggregation Aggregate Processing Group By Limiting Output Values Using Having Statistical Aggregates Using The Distinct Function With Aggregates Performance Opportunities Subquery Processing Subquery Qualifying Table Names And Creating A Table Alias Correlated Subquery Processing Exists Join Processing Join Processing Original Join Syntax Product Join Newer Ansi Join Syntax Adding Residual Conditions To A Join Outer Join Hints Parallel Join Processing Join Index Processing Date And Time Processing Date, Time, And Timestamp Ansi Standard Date Reference Integerdate Ansidate Dateform Date Processing Add_months Ansi Time Extract Implied Extract Of Day, Month And Year Ansi Timestamp Time Zones Date And Time Intervals Overlaps System Calendar Character String Processing Transforming Character Data Characters Function Character_length Function Octet_length Function Trim Substring Substr Substring And Numeric Data Position Index Function In Teradata Extension Substring And Position Or Index Used Together Concatenation Of Character Strings Olap Functions On-line Analytical Processing (olap) Functions Olap Functions Cumulative Sum Using The Csum Function Moving Sum Using The Msum Function Moving Average Using The Mavg Function Moving Difference Using The Mdiff Function Cumulative And Moving Sum Using Sum / Over Moving Average Using Avg / Over Moving Linear Regression Using The Mlinreg Function Partitioning Data Using The Quantile Function Ranking Data Using Rank Internal Rank Operations Sampling Rows Using The Sample Function Random Number Generator Function Set Operators Set Operators Considerations For Using Set Operators Intersect Union Except Minus Using Multiple Set Operators In A Single Request Data Manipulation Data Maintenance Insert Command Insert / Select Command Update Command Delete Command Upsert Ansi Vs Teradata Transactions Performance Issues With Data Maintenance Data Interrogation Data Interrogation Nullifzero Nullif Zeroifnull Coalesce Case Using Case To Avoid A Join View Processing Views-select Statement Creating And Using Views Deleting Views Modifying Views Macro Processing Macros Create Macro Replace Macro Drop Macro Generating Sql From A Macro Transaction Processing What Is A Transaction Teradata Extension Transaction Modes In Teredata Comparison Chart Ansi Mode Transactions Aborting Teradata Transactions Aborting Ansi Transactions Reporting Totals And Subtotals Totals And Subtotals Totals (with) Data Definition Language Creating Tables In Teredata Table Considerations Table Naming Conventions Create Table Primary Index Considerations Protection Features Internal Storage Options Column Attributes Constraints In Teradata Utilizing Default Values For A Table Create Table To Copy An Existing Table Altering A Table Dropping A Table Renaming A Table Using Secondary Indices Join Index Hashing Functions Techniques To Create And Maintain Tables Temporary Tables Temporary Tables In Teradata Temporary Table Choices Derived Tables Volatile Temporary Tables Global Temporary Tables General Practices For Temporary Use Tables Trigger Processing Triggers Create Trigger Syntax Cascading Triggers Sequencing Triggers Stored Procedures Teradata Stored Procedures Create Procedure Stored Procedural Language (spl) Statements Establishing Variables And Data Values Additional Spl Statements Exception Handling In Teradata Dml Statements Using Column And Alias Names Comments And Stored Procedures On-line Help For Stored Procedures Replace Procedure Drop Procedure Rename Procedure Show Procedure Other New V2r4.1 Features Considerations When Using Stored Procedures Compiling A Procedure Teradata Interview Questions Teradata Practice Tests