TeraData DBA Training

7254 Learners

Teradata is a fully scalable relational database management system (RDBMS) that specializes in managing data warehousing operations and providing enterprise Analytic/Analysis solutions. Our TeraData DBA training is intended to provide details on Teradata architecture, database, dictionary, access rights/levels, manage apps, monitor performance, archive and restore data. The Teradata course offered explains how to manage data to respond to diverse concurrent queries while delivering high performance. The experts from the industry deliver Teradata training and guides on the career path and explains the best practices.

Upon the completion of the TeraData DBA training course, the candidates will be able to do the following:

  • Understand the architecture of Teradata
  • Manage space in Teradata database
  • Create views – system, database, DBC users, indices
  • Define roles and profiles of the users to limit access rights
  • Work on query analysis tools
  • Use TD Manager to administer services and apps
  • Start DB window and work on remote console utilities
  • Archive user actions and data
Target audience
  • Database Administrators
  • Data Analysts
  • IT professionals (Developers/DBA)
  • Experienced Business Users who have been working extensively in Data Warehousing
  • Professionals  and enthusiastic persons who want to know the database management of DatawareHouse
Prerequisites

Candidates with the zeal to learn the Dataware housing can undergo this training.

Teradata is a fully scalable relational database management system (RDBMS) that specializes in managing data warehousing operations and providing enterprise Analytic/Analysis solutions. Our TeraData DBA training is intended to provide details on Teradata architecture, database, dictionary, access rights/levels, manage apps, monitor performance, archive and restore data. The Teradata course offered explains how to manage data to respond to diverse concurrent queries while delivering high performance. The experts from the industry deliver Teradata training and guides on the career path and explains the best practices.

Upon the completion of the TeraData DBA training course, the candidates will be able to do the following:

  • Understand the architecture of Teradata
  • Manage space in Teradata database
  • Create views – system, database, DBC users, indices
  • Define roles and profiles of the users to limit access rights
  • Work on query analysis tools
  • Use TD Manager to administer services and apps
  • Start DB window and work on remote console utilities
  • Archive user actions and data
Target audience
  • Database Administrators
  • Data Analysts
  • IT professionals (Developers/DBA)
  • Experienced Business Users who have been working extensively in Data Warehousing
  • Professionals  and enthusiastic persons who want to know the database management of DatawareHouse
Prerequisites

Candidates with the zeal to learn the Dataware housing can undergo this training.

1.    TERADATA Architecture

  • Parsing Engine (PE)
  • Request and Response Parcel
  • Access  Processors (AMPs)
  • Bynet
  • Data access Handling
  • TD Config Utilities
  • Config and Reconfig

 2.   TERADATA Database Space

  • Permanent Space
  • Spool Space
  • Temp Space
  • Indexes

  3.  DBC Dictionary Tables

  • Data dictionary
  • Parsing Engine
  • System Views
  • Database Views
  • DBC Users View
  • Indices View
  • All Temp Tables View
  • Using DBC AMP Usage
  • Using DBC Table Size
  • Logon and Logoff Tracking

 4.  Access Rights, Roles, Profiles

  • Access rights (Auto, implicit, Explicit Rights)
  • Roles and Profiles
  • Creating Roles and Profiles
  • DBC. RoleInfo and DBC. ProfileInfo

5.   Query analysis and Tools

  • Database Query Log (DBQL)
  • DBQL Tables and Views
  • Access Logging

6.  System Access Control Levels

  • TD Password Encryption
  • Password Security Features
  • Host Logon Processing
  • GRANT/REVOKE LOGON
  • Session Related Views
  • DBC Session Info View
  • Data Access Info Views
  • Access Log Rules Views
  • Access Log Views

 7. TD Manager

  • TD Manager Apps
  • TD Dashboard
  • Priority Scheduler Admin
  • TD Manager Service
  • Starting TD Manager

8. Monitoring tools

  • Performance Monitor
  • PMON Main window
  • PMON sessions Screen
  • TD Administrator
  • TD Manager Dynamic Utilization Charting
  • Locking Logger

9.  TD Remote Console Utilities

  • Starting DB Window
  • QRYCONFIG
  • QRYSESSN
  • RCVMANAGER
  • SHOWLOCKS
  • VPROCMANAGER
  • SHOWSPACE
  • SHOWBLOCKS
  • PACKDISK
  • SCANDISK

 10.  Archiving Data

  • Archive and Recovery Statements
  • Recovery vs. FastLoad
  • Invoking Archive
  • Restart Log
  • ANALYZE Statement
  • Archive
  • Database DBC Archive
  • Indexes option
  • Database DBC Archive
  • Archive and Recovery (ARC) Examples

11.  Restoring data

  • Restore
  • COPY
  • Copying Tables
  • BUILD

Drop Us a Query

+91 95550 06479

Available 24x7 for your queries

TeraData DBA Corporate Training & Certification Program

Employee training and development programs are essential to the success of businesses worldwide. With our best-in-class corporate trainings you can enhance employee productivity and increase efficiency of your organization. Created by global subject matter experts, we offer highest quality content that are tailored to match your company’s learning goals and budget.

Learn from the experts

Customized Training

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements of your workforce. You can even choose a trainer from our team of certified industry experts.

Learn from the experts

Expert Mentors

Get trained from our team of highly skilled and certified trainers, who are officially accredited professionals with relevant industry experience and adept in providing the knowledge and skills required to be successful.

Learn from the experts

360º Learning Solution

Engage your employees with our all-inclusive learning platform. Avail benefits of 24/7 access to the learning management system, industry-certified mentors, assessments & mock tests, real-time learning and more.

Learn from the experts

Learning Assessment

Check test score and performance with our skills analysis tools. Our detail scoreboard displays scores, areas of strength, detailed answer of questions and more for each employee.

Download Corporate Brochure

+91 9555006479

Available 24x7