Open Source/Teradata Database Administration

Enrol for the 3-day Teradata DBA training from Koenig Solutions. This class covers everything from Teradata DBA fundamentals, Teradata Architecture, and Teradata Internals.

Target Audience:

At the completion of this course, all students will have the skills and knowledge to perform their DBA jobs at a very high level.

Learning Objectives:

At the completion of this course, students will have the skills and knowledge to perform their DBA jobs at a very high level. Topics include:

• 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
• 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