At the end of the training you will be able to perform installation, system management, user management, storage management, index management and work load management in Teradata.
Instructor-Led Live Online Training
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
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 Apps, TD Dashboard, TD Manager Service, Starting TD Manager
Performance Monitor, PMON Main window, PMON sessions Screen, TD Administrator, Locking Logger
TD Remote Console Utilities
Starting DB Window, SHOWLOCKS, SHOWSPACE, SHOWBLOCKS, PACKDISK, SCANDISK
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
Restore, COPY, Copying Tables, BUILD
Teradata DBA Responsibilities
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.
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.
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.
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.
Average Teradata DBA Salary in USA is increasing and is much better than other products.
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 ...
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 ...
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 ...
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 ...