Teradata Database Administration

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

Related Scheduled Courses