Tera Data

This course provides an overview of the Teradata Database architecture, as well as the features and benefits of the product. Teradata data distribution, access, storage and data protection methods are described. The suite of complementary load, access, and management utilities and tools are also covered, as well as Teradata Terminology.

This course also offers practical, hands-on experience with retrieving and manipulating data with Teradata Structured Query Language (SQL) using both ANSI standard conventions and Teradata extensions to the language.

What You Will Learn:

• Basic concepts of Teradata
• Industry terminology
• Critical success factors & risks
• Tearadata applications and Designs
• Best practices
• Tearadata Tools
• Industry trends

Who Should Attend:

This course is intended for Freshers & Novice to this technology who may be involved in the process of designing and implementing a business intelligence application or data warehouse. It is also for those who just need to understand what is involved in managing either a business intelligence or data warehouse project.

Content:

• Section 1: Teradata SQL
• Basic relational concepts and their implementation using SQL
• Retrieving data using the SELECT statement
• Using logical and arithmetic expressions, and output formatting
• Producing reports using table joins, subqueries, aggregation, and string manipulation
• Creating tables and views using column attributes and check constraints
• Choosing the appropriate Teradata data type for column definitions
• Maintaining data using INSERT, UPDATE, and DELETE in both their simple and advanced forms
• How to create and execute macros using run time parameters
• ANSI standard join processing including inner, outer, left, right, cross, and product joins
• Set manipulations using set operators
• Aggregations using both ANSI and Teradata specific functions
• Use of the Teradata built-in functions for providing system and session level information
• Use of the Teradata sampling function to produce samples from existing table data
• Use of the HELP and SHOW facilities to obtain information from the Data Dictionary about data
• structures associated with Teradata databases, users, tables, view, macros, and indexes
• Use of Teradata’s DATE data type for date and time oriented reporting
• OLAP Function ( Rank, Cummulative Sum, Moving Average, Percentile Rank, Width_bucket,Quantile)