Loading Course Schedule...
PT0060
Summary
This class teaches everything a Teradata DBA needs to know. This class covers everything from Teradata DBA fundamentals, TASM and Viewpoint, and Teradata Internals.
Prerequisites
There are no prerequisites for this course.
Duration
5 Days/Lecture & Lab
Audience
This course is designed for Teradata DBAs or anyone who has interest in learning more about how to perform the role of a Teradata DBA.
Topics
- Introduction and Good Advice
- Teradata Architecture Fundamentals the DBA must know
- The Primary Index is the Axis of all Teradata Systems
- A DBA's best friend - The Data Dictionary
- How Teradata Tracks Objects
- Creating Users and Databases
- Profiles
- Roles
- Access Rights
- Collect Statistics
- Locking
- Protection Features
- Viewpoint
- TASM
- Designing and Implementing Workloads
- Top SQL Commands Cheat Sheet
- The Cold, Hard Teradata Facts
- How Teradata Tracks Objects
- AMP Worker Tasks
- Deep Dive Overhead for each Row
- Compression
- Data Stored in the Row
- How Data Rows are Stored in Blocks
- Disk Cylinders and the Master Index
- Teradata Virtual Storage (TVS)
- Teradata Writes and Blocks
- Access Logging
- DBQL Query Logging
- ResUsage