Open Source/Teradata Database Administration


Teradata Database Administration Certification Training Course Overview

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

Teradata Database Administration (24 Hours) Download Course Contents

Live Virtual Classroom (Instructor-Led)

Fee : On Request
9 AM - 5 PM (Flexible Time Slots for 4 hours option)




May
8 Hours/Day
4 Hours/Day
03-05
09-11
10-12
17-19
03-10
09-15
10-17
17-24
June
8 Hours/Day
4 Hours/Day
07-09
13-15
14-16
21-23
07-14
13-19
14-21
21-28
July
8 Hours/Day
4 Hours/Day
05-07
11-13
12-14
05-12
11-17
12-19
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request

Special Solutions for Corporate Clients! Click here

Hire Our Trainers! Click here

Request More Information

Course Prerequisites

None