Teradata Database Administration
Catalog Home
Databases, Business Intelligence & Data Science
Teradata
Your Training Location:
Teradata Database Administration
Add Course To Watch List
View Full Course Outline
Request A Public Course
In Your Area
Request A Quote For A
Private Class
View Full Course Outline
Request A Public Course
In Your Area
Request A Quote For A
Private Class
Delivery Options & Status:
Let us know if you would like a date for this course added to our schedule
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
