Course Description
This is a comparison of Teradata SQL and ANSI SQL for those already familiar with standard SQL. It focuses on the Teradata extensions to ANSI SQL and how they function in a parallel processing architecture.
Prerequisites
To get the most out of this training, you should have the following knowledge or experience.
- Introduction to Teradata Database
- SQL know-how
Target Audience
This course is for Individuals who design, administer, support, maintain or write applications for a Teradata Database.
Learning Objectives
Upon accomplishment of this course, participants will be able to:
- Write Group Aggregates using PARTITION BY in a Window Function
- Filter the result of a Window Function using QUALIFY
- Add a frame to a Window Function to calculate ordered aggregates such as a Cumulative Sum or a Moving Average
- Access columns in a different row using Analytic Functions such as LAG and FIRST_VALUE
- Work with Ranking functions such as DENSE_RANK, CUME_DIST and PERCENTILE_CONT
- Dynamically add subpartitions to the window definition using RESET WHEN
- Handle NULLs in Window Functions
- Understand how and when to use scalar subqueries and correlated subqueries
- Write SQL to modify data in a table, using the UPDATE, INSERT, DELETE and MERGE statements
- Create and use views and macros
- Work with Extended Grouping functions such as ROLLUP and GROUPING SETS
Content Outline
SQL help and database object definition tools: HELP and SHOW
- Basic SQL syntax
- Rules for naming Teradata objects
- Fully qualified names
- Changing the default database
- Terminators + Multi statement requests
- Referencing a column alias
- Data types and literals
- Type casts: ANSI vs. Teradata
- Output formats
- Arithmetic Operators and Functions / Trigonometric / Hyperbolic Functions
- DateTime and Interval Functions and Expressions:
- ANSI DateTime / Interval
- EXTRACT
- ADD_MONTHS differences
- Logical predicates:
- Case Sensitivity in Character Comparisons
- Multi-column subqueries, Like with subqueries
- OVERLAPS
- String functions
- CASE vs. DECODE
- ANSI SQL:1999 statistical aggregate functions
- CUBE and ROLLUP
- Windowed OLAP functions
- ANSI Join syntax
- Set operations: UNION [ALL], INTERSECT [ALL], MINUS/EXCEPT [ALL]
- SAMPLE and RANDOM
- Volatile and Global Temporary tables
- Table Creation from Existing Tables: CREATE TABLE AS ... WITH [NO] DATA
FAQs
To attend the training session you should have an operational Desktops or Laptops with required specification along with good internet connection to access the labs.
We would always recommend you to attend the live session to practice & clarify the doubts instantly and get more value from your investment. However, due to some contingency if you have to skip the class Radiant Techlearning would help you with the recorded session of that particular day. However, those recorded sessions are not meant only for personal consumption and NOT for distribution or any commercial use.
Radiant Techlearning has a data center containing the Virtual Training environment for the purpose of participant’s hand-on-practice.
Participants can easily access these labs over Cloud with the help of remote desktop connection.
Radiant virtual labs provide you the flexibility to learn from anywhere in the world and in any time zone.
The learners will be enthralled as we engage them in real world and industry Oriented projects during the training program. These projects will improve your skills and knowledge and you will gain better experience. These real time projects, they will help you a lot in your future tasks and assignments.