Logo

Course Contents
Teradata Basic & Advanced Workshop

Day 1 – 2 ( 2 days)

– Course Overview
1– Teradata Overview
2– Relational DB Concepts
3 – Teradata Basics
4 – RDBMS Architecture
5 – System Architecture
6 – Creating a Database
7 – Storing Rows
8 – Primary Index Mechanics
9 – Secondary Indexes
10 – Data Protection
11 – Intro to NCR Systems
12 – Teradata parallel architecture
13 – Teradata and NCR Systems
14 - Physical Design Overview
15 – Data Distribution & Hashing
16 – File System Writes
17 – Primary Index Criteria
18 – Partitioned Primary Indexes
19 – Secondary Indexes
20 – Secondary Index Criteria

Day 3 – 5.5 (2.5 days)

 1 – Access Considerations
2 – Referential Integrity
3 – Sizing
4 – SQL Parser
5 – Collecting Statistics
6 – The EXPLAIN Facility
7 – Visual Explain
8 – Join Processing Analysis
9 – Explains of Joins
10 – Additional Indexes
11 – Miscellaneous SQL Features
12 - produce reports using complex joins, sub queries, aggregation and string manipulation of data
13 - How to maintain data using INSERT, UPDATE and DELETE.
14 - create, debug and execute macros and how to pass run time parameters.
15 - How views and macros are used for security and control.
16 - How to use ANSI standard features such as the CASE statement, EXISTS statement, null handling, and date/time extraction.
17 - How to perform simple rankings on rows in a table, and extract samples of data from a table.
18 - HELP and SHOW commands to obtain information from the Data Dictionary/Directory about data structures associated with Teradata Database users, databases, tables, views, macros and indexes.
19 - Use of the Teradata DATE, TIME, TIMESTAMP and time ZONE data types for date and time-oriented queries.
20 - Creating OLAP queries using advanced ranking functions such as RANK, QUANTILE, and WIDTH_BUCKET.
21 - Use of Ordered Analytic Functions for Group, Sum, Cumulative and Remaining Window Aggregations.
22 - Use of RANDOM and SAMPLE functions for generating data or extracting samples of existing data.
 23 - How and why to create and use volatile and global temporary tables.
24 - Implementing column compression for performance and reduced storage costs  using single or multi-value compression.
25 - How to create new tables from existing tables and how to copy data and table attributes from the source table.
26 - ANSI standard features such as EXISTS statement, correlated subqueries, derived tables, null handling, and date/time extraction.
 SQL Basics – SQL Assistant 12.0


Day 5.5 – 7.5 (2 days)

 1 – Application Utilities
2 – BTEQ
3 – FastLoad
4 – Support Environment
5 – FastExport
6 – MultiLoad Part 1
7 – MultiLoad Part 2
8 – TPump
9 – Choosing a Utility
10 –TPT
11 – PP2
12 - Demo Project

Day 7.5 - 8 (1.5 days)

 1 – The Database Environment
2 – Data Dictionary
3 – Space Allocation
4 – Users and Accounts
5 – Access Rights
6 – Roles and Profiles
7 – System Access Controls
8 – Access and Query Logging
9 – RI and Triggers
10 – Utilities and DB Window
11 – Configuration Utilities
12 – Performance Monitoring
13 – Teradata Manager & DQM
14 – System Restarts
15 – Diagnostic & Recovery Utilities
16 – Permanent Journals
17 – A Tale of 3 Tables
18 – Archiving Data
19 – Restoring Data
20 – Data Recovery Operations
21 – Administration Recap
22-Demo Project

System requirement :

H.D.D: 80 GB (will create 4 GB Database for Demo)
1.GB of Ram
O/S: Windows XP : Service Pack : 3