Buy on Amazon now!
Buy on Appl iBooks now!
Buy on Kobo books now!

Teradata Certification Database Administration (v14)

The Teradata CertificationDatabase Administration Guide is designed for those who are interested in becoming a Teradata Certified Database Administrator. Through simplified examples and explanations, this guide prepares the reader to take the Teradata Database Administration Exam.

  • Data Dictionary Directory
  • Users, Databases, and Types of Space
  • Access Rights, Roles and Profiles
  • Security, Session, and Workload Management
  • DBQL and Access Logging
  • System Administration and Monitoring Tools
  • Database Maintenance Utilities
  • Performance Optimization and Capacity Planning Techniques
  • Load Utilities
  • Backup and Restore

The Teradata 14 Certification Study Guides are the only Teradata authorized study publications. Cerulium Corporation partners with Teradata and the Teradata Certified Professional Program to author the Teradata 14 Certification Study Guides.

Teradata Certified Database Administrator

“A successful candidate has core knowledge and skills necessary to set up, manage, and maintain a Teradata database environment. The candidate has a thorough understanding of Teradata database concepts, object creation, system and query performance, space management, security, system parameters, workload management, capacity management, and database utilities.”*

Teradata Certification Exam TEO-144 is required for:

  • Teradata Certified Database Administrator
  • Teradata Certified Master

 

Chapter 1: The Teradata Certified Professional Program              

  • Pursue Teradata Certification with Confidence™
  • Your Teradata 14 Certification Upgrade Roadmap
  • Certification… Knowledge Building to Mastery
  • Path to Teradata 14 Mastery
  • Exam Registration
  • Where to Find More Information

Chapter 2 — Data Dictionary / Directory

  • Teradata Certification Database Administration Objectives
  • Supplied Data Dictionary Views
  • Using Restricted Views
  • Selecting Information about Created Objects
  • DBC.ChildrenV[X] View
  • DBC.DatabasesV[X] View
  • DBC.UsersV View
  • DBC.TablesV[X] View
  • DBC.ColumnsV[X] View
  • DBC.IndicesV[X] View
  • DBC.IndexConstraintsV[X] View
  • DBC.ShowTblChecksV[X] View
  • DBC.TriggersV[X] View
  • DBC.AllTempTablesV[X] View
  • DBC.Databases2V[X] View
  • Time Stamps in Data Dictionary
  • Practice Questions

Chapter 3 Database Space          

  • Teradata Certification Database Administration Objectives
  • CurrentPerm
  • PeakPerm
  • MaxPerm
  • MaxSpool
  • PeakSpool
  • CurrentSpool
  • MaxTemp
  • PeakTemp
  • CurrentTemp
  • DBC.ClearPeakDisk macro
  • DBC.TableSizeV[X] View
  • DBC.AllSpaceV[X] View
  • DBC.DataBaseSpace Table
  • Practice Questions

Chapter 4 – Users and Databases            

  • Teradata Certification Database Administration Objectives
  • Before You Begin
  • Creating Users & Databases
  • CREATE DATABASE Statement
  • CREATE USER Statement
  • CREATE USER and the Data Dictionary
  • MODIFY USER Statement
  • Creating and Using Account IDs
  • System Accounting Views
  • Practice Questions

Chapter 5 – Access Rights           

  • Teradata Certification Database Administration Objectives
  • Before You Begin
  • Privileges/Access Rights
  • Access Rights Mechanisms
  • Implicit, Automatic, and Explicit Rights
  • GRANT Command
  • REVOKE Command
  • Inheriting Access Rights
  • The GIVE Statement and Access Rights
  • Access Rights and Views
  • System Views for Access Rights
  • Practice Questions

Chapter 6 – Security Management         

  • Teradata Certification Database Administration Objectives
  • Before You Begin
  • What are Roles and Profiles?
  • Advantages of Roles
  • Access Rights without Roles
  • Access Rights using a Role
  • Implementing Roles
  • Dropping a Role
  • Role Views
  • Steps to Implementing Roles
  • Advantages of Profiles
  • Implementing Profiles
  • CREATE/MODIFY/DROP PROFILE Statements
  • Password Attributes (CREATE/MODIFY PROFILE)
  • Teradata Password Control
  • DROP PROFILE Statement
  • ProfileInfoV[X] View
  • User Authentication
  • Teradata Wallet
  • Identifying Security and Password Violations
  • Limiting Column and Row Access Using Views
  • Row Level Security
  • Practice Questions

Chapter 7 – Priority Scheduler and Workload Management       

  • Teradata Certification Database Administration Objectives
  • Before You Begin
  • Reducing Authentication Time
  • Session Pooling
  • Identifying users
  • Trusted Sessions
  • Levels of Workload Management
  • Priority Scheduler Facility
  • SLES 10 Priority Scheduler Architecture
  • Resource Partitions and Performance Groups
  • Schmon Utility
  • SLES 11 Priority Scheduler
  • AMP Worker Task (AWT)
  • Workload Designer SLES 10 & SLES 11
  • Practice Questions

Chapter 8 – Query Access Logging            

  • Teradata Certification Database Administration Objectives
  • Before You Begin
  • Access and Query Logging
  • Access Logging and Objects Used
  • Access Log Views
  • DBC.AccLogRulesV
  • DBC.AccessLogV
  • DBC.AccessLogV View – Example
  • END LOGGING – Example
  • Teradata Administrator – Access Logging
  • Query Logging (DBQL) Concepts
  • Objects used in Defining Rules for DBQL
  • BEGIN QUERY LOGGING Statement
  • BEGIN QUERY LOGGING WITH   logging_option
  • BEGIN QUERY LOGGING Examples
  • END QUERY LOGGING Statement
  • DBC.DBQLRulesV View
  • DBC.QryLogV View
  • DBC.QryLogSummaryV View
  • Practice Questions

Chapter 9 – System Administration Tools            

  • Teradata Certification Database Administration Objectives
  • Before You Begin
  • Teradata Administrator
  • Teradata Multi-System Manager (TMSM)
  • Teradata Viewpoint
  • Teradata Analyst Pack
  • Teradata Index Wizard
  • Teradata Statistics Wizard
  • Teradata System Emulation Tool
  • Teradata Visual Explain
  • Practice Questions

Chapter 10 – Monitoring Tools 

  • Teradata Certification Database Administration Objectives
  • Before You Begin
  • Viewpoint
  • Locking Logger
  • ResUsage Data
  • ResUsage Tables
  • ResUsage Views
  • ResUsage Macros
  • Specifying ResUsage Tables and Logging Rates
  • Populating the ResUsage Tables
  • AmpUsageV[X]
  • DBQL
  • Practice Questions

Chapter 11 – Maintenance Utilities       

  • Teradata Certification Database Administration Objectives
  • Before You Begin
  • Maintenance, Diagnostic, and Recovery Utilities
  • FERRET
  • DEFRAGMENT
  • FORCE
  • PACKDISK
  • SCANDISK
  • SHOWSPACE
  • SHOWWHERE
  • Recovery Manager Utility
  • List Locks
  • List Rollback Tables
  • Cancel Rollback on Table
  • Reconfig
  • Reconfiguration Estimator
  • Online and Offline Reconfiguration
  • ABORT
  • ctl
  • DBS Control Utility
  • Free Space
  • AutoCylPack
  • MiniCylPack
  • Database Initialization Program (DIP)
  • Practice Questions

Chapter 12 – Capacity Planning

  • Teradata Certification Database Administration Objectives
  • Before You Begin
  • Table design considerations
  • NUSI
  • Partitioned Primary Index
  • Data Protection
  • RI Constraints
  • Altering Attributes
  • Compression
  • Multi-Value Compression (MVC)
  • Join Index Compression
  • Column Container Compression
  • Algorithmic Compression (ALC)
  • Software-Based Block-Level Compression
  • Temperature-Based Block-Level Compression
  • Capacity planning
  • Calculating Space Requirements
  • Conserving Disk Space
  • Peak spool
  • Practice Questions

Chapter 13 – Performance Optimization              

  • Teradata Certification Database Administration Objectives
  • Before You Begin
  • Considerations for keeping and utilizing performance data history
  • To Maintain Efficient Use of Existing System Resources
  • To Help Identify System Problems
  • For Capacity Planning
  • Recommendations to move DBC data to a historical database
  • Best Practices to capture performance data daily
  • Statistics
  • Reasons to collect statistics
  • Types of Statistics
  • Random AMP Sampling
  • Full Statistics
  • Sample Statistics
  • Summary Statistics
  • Extrapolated Statistics
  • Derived Statistics
  • What statistics should be collected
  • Multi-Column Statistics
  • Enabling a Rollup
  • Viewing Statistics
  • Analyzing Response Time and Throughput
  • Tactical queries
  • DBQL
  • Access Logging
  • ResUsage
  • Hash Functions
  • Data Dictionary Tables
  • Steps required for analyzing queries for optimization
  • WHERE clause analysis
  • Explains
  • Practice Questions

Chapter 14 – Load Utilities          

  • Teradata Certification Objectives
  • Before You Begin
  • BTEQ
  • FastLoad
  • FastExport
  • MultiLoad
  • TPump
  • Teradata Parallel Transporter
  • Checkpoint and Restart
  • Utility Limits
  • Practice Questions

Chapter 15 – Archiving 

  • Teradata Certification Database Administration Objectives
  • Before You Begin
  • Archive and Recovery Utility (ARC)
  • Archive and Recovery Phases
  • Restore versus FastLoad
  • Session Control
  • Multiple Sessions
  • ARCHIVE Statement
  • ANALYZE Statement
  • Types of Archives
  • Archive Options
  • Database DBC Archive
  • Archiving Selected Partitions of a PPI Table
  • Archiving Stored Procedures, Triggers, UDFs, and UDTs
  • Online Archive
  • Practice Questions

Chapter 16 – Restoring 

  • Teradata Certification Database Administration Objectives
  • Before You Begin
  • Understanding Restore Operations
  • RESTORE Statement
  • Restoring Selected Partitions of PPI Table
  • Restoring UDFs, UDTs, Triggers, and Stored Procedures
  • COPY Statement
  • Copying Partitioned Data
  • Copying Objects
  • UDFs & Triggers
  • Keyword Options with COPY

 

Paperback: 395 pages
Publisher: Cerulium Corporation (2014)
ISBN: 978-0989400534

In Stock: Yes

http://www.teradata.com/Certification

2017-03-23T17:58:47+00:00