• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Course Details

The Teradata Database is a shared-nothing massively parallel processing (MPP) relational database management system (RDBMS), making it the only commercially available RDBMS designed from the ground up for data warehousing.

Parallel processing and the automation of many typical DBA functions were created in the DNA of the Teradata Database. Because of that architecture, many functions that are manual or enhanced by wizards in other vendors’ systems are managed automatically. Consequently, the roles and responsibilities of the DBA are significantly different. Fewer tasks are required, making the system much easier to manage. Understanding those differences and how to exploit them with the RDBMS is key to driving the success of the organization.

Teradata Administration Training Curriculum

TERADATA Architecture

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

TERADATA Database Space

Permanent Space, Spool Space, Temp Space, Indexes

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.

Access Rights, Roles, Profiles

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

Query analysis and Tools

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

System Access Control Levels

TD Password Encryption,  Password Security Features,  Host Logon Processing,  GRANT/REVOKE LOGON,  Session Related Views,  DBC.sessionInfo Info View,  Data Access Info Views,  Access LogRules Views,  Access Log Views

TD Manager

TD Manager Apps, TD Dashboard, TD Manager Service, Starting TD Manager

Monitoring tools

Performance Monitor, PMON Main window, PMON sessions Screen, TD Administrator, Locking Logger

TD Remote Console Utilities

Starting DB Window, SHOWLOCKS, SHOWSPACE, SHOWBLOCKS, PACKDISK, SCANDISK

Archiving Data

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

Restoring data

Restore, COPY, Copying Tables, BUILD


Teradata DBA Responsibilities

Storage Management

Because the Teradata storage subsystem is installed and balanced before delivery, management of the disk subsystem is greatly simplified. The DBA familiar with managing items such as disk groups, logical volumes, node groups, file system, files and table spaces will find that those entities and concepts are nonexistent. (See table.)

All disk organization is entirely logical, as opposed to physical. (See figure) Initially, all space in the system is allocated to a predefined system database called DBC. Using the “CREATE” DML command, the DBA will define DATABASE and USER entities. The space parameter on the CREATE DML statement is not a physical “allocation” but is simply a size quota. If a database is allocated 5TB of space that is the maximum amount of space the database is allowed to use. Anytime that database attempts to use more than 5TB, an “out of space” message will result. However, the system is not out of space, it just exceeded its space quota.

User Management

Defining users is easy with a Teradata system. There are two types: query users with no workspace capability; and power users who have the capability to create and manipulate tables within their own workspace based on whatever limitations the DBA placed on their space usage.

The DBA first adds the users with a CREATE USER DML command, then grants them security rights to database entities. Role-based security is supported for ease of maintenance.

Index Management

DBAs need to resist the temptation to over-index the tables. Because of the powerful parallel architecture of the Teradata platform, it is unnecessary to avoid full-table scans. Therefore, far fewer indexes are needed than in other RDBMSs. In fact, as experienced in several organizations, tables having more than 80 billion rows each can be scanned in less than five minutes.

Workload Management

Teradata Active System Management provides the necessary tools for comprehensive workload management; therefore, no outside tools or resources are needed. Dynamic Query Manager enables the DBA to classify and govern the query before its execution in the database.

Priority Scheduler defines resource partitions where varying workloads can be controlled and monitored.

Salary Trends

Average Teradata DBA Salary in USA is increasing and is much better than other products.

Teradata DBA Training

Ref: Indeed.com

Course Reviews

4.8

450 ratings
      • Tekslate has been one of the finest global online learning portals with clear information and learning. I attended the Apache Spark Certification training. The best part is that they have provided IDE ...
        Profile photo of Suneel Kumar
        Chrissteve
      • I have taken 2 instructor-led courses (SAP HANA and BO). The course contents were really rich, and trainers are experts in the technology fields. I would like to recommend the course to my colleagues ...
        Profile photo of Suneel Kumar
        Katelyn Thomas
      • After a great research on available online courses, I have decided to opt Tableau Training from Tekslate, am quiet satisfied with that. Coursework is well calibrated to make student more comfortable w ...
        Profile photo of Suneel Kumar
        Christinia Beth
      • I have enrolled last month, and finished the course... As a working professional, they given me an exposure to the domain, but also helped to learn the cross technologies and develop an inclination to ...
        Profile photo of Suneel Kumar
        Alison Benhar

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.