+1-877-612-8972
Menu

Find the Benefits of our
Highly Valued Services

We provide you the best business solutions ever.

There are Websites

about to speck
The business

Teradata

 Teradata DBA Training Program  
           
S#   Topics Details Duration(in hrs) Documents
           
Teradata Architecture and other essentials    
1   Introduction  What is Teradata and role of Teradata in Data Ware housing industry, Significant characteristics of Teradata, Advantages of Teradata over other RDBMS 1  
2   Teradata Architecture Understanding H/W and S/W components, involved in Architecture of Terdata(vdisks,AMP,PE Vprocs, BYNET…etc). 2  
3   Data distribution Understanding significance of Index in teradata(UPI, NUPI, SI, NUSI, Partitioned index ) 3  
4   Data Protection Different levels of failures that could happen and fault tolarance of Teradata in that situations.(CLIQUE,CLUSTER,RAID,LOCKS and JORNALS) 2  
5   Advanced Teradata SQL HELP, SHOW, EXPLAIN, Define and execution of Macros, Date calculations, data type conversion, Case,COALESCE,sample, Ranking, Qualify, CSUM, MSUM,MDIFF,MAVG,  WITH,WITH BY. 2  
DBA    
6   Teradata DBA basics and responsibilities Initial Teradata Databases
Administrative User
Owners, Parents and Children
Creating New Users and Databases
Transfer of Ownership
DELETE/DROP Statements		 1  
7   Users, Accounts, and Accounting creation of users, databases,
Identify spaces, skew of tables,
Moving spaces and accesses,
Creating and Using Account IDs
Using Account IDs with Logon
Dynamically Changing an Account ID
Account Priorities
Account String Expansion
Understand the Heirarchy,
Teradata Administrator tool usage to perform all the above tasks		 2  
8   The Data Dictionary Updating Data Dictionary Tables
Supplied Data Dictionary Views
Restricted Views
Suffix Options with Views
Selecting Information about Created Object
Children View, Databases View, Users View, Tables View
Columns View, Indices View		 1  
9   Capacity management and planning Spaces and types of tables -

PERM, SPOOL, TEMP space terminology, Derived,Volatile, Global temporary tables. Identify current space usage and estimate the space requirments for the applications.		 1  
10   Access Rights Privileges/Access Rights
Implicit, Automatic, and Explicit Rights
GRAND and REVOKE accesses, GIVE command
System Views for Access Rights,
Inheriting Access Rights, Transfer access rights, Delete or Drop / user or database		 1  
11   Roles and Profiles What is a role, Advantages of Roles, Access Rights Using a Role, Implementing Roles, Nesting of roles, views for roles, Profiles, implementing Profiles, Teradata password control 2  
12   Security Management System Access Control Levels
Objects used in Host Logon Processing
GRANT/REVOKE LOGON Statements
Access Control Mechanisms
Using Views to Limit Access
A Recommended Structure Using Roles
Using Macros to Reduce User SQL Complexity		 1  
13   Work load management and Priority scheduler Levels of Workload Management,Priority Scheduler Architecture, and concepts 1  
14   Access logging and Query logging
Setting up Access Logging,AccLogRules View, Query Logging (DBQL) Concepts, Objects used in Defining Rules for DBQL, DBQLRules View		 2  
15   Performance monitoring (PMON)  Resource usage, Session Management User session Info,
SQL & Explain Steps		 1  
16   Overview of Load and unload Utilities Functionalities, limitations of BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, TPUMP, TPT 2  
17   Archive and Restore and copy  Archive and restore data using ARCMAIN utility, Different levels of archiving and restoration, HUT locks, Revalidate references after restoration 2  
18   View point  The Demo of view point portlets (which is new tool for DBAs having the features of PMON, TDMANAGER and TASM 1  
     Performance tuning    
19   Explain plan, Statistics and Join strategies  Understanding Explain plan and recommandations.
Significance of collecting  statistics		 1  
20   Other indexes, and techniques Determine the proper join columns, Join index, Spars index, Aggregate index, SET / MULTSET with UPI and NUPI combinations, compress 1
    Others (Optional)    
21   Unix Role of Unix in executing Teradata utility scripts and Basic commands used 2  
22   General Lifecycle of the projects General phases of a Development project. Documents required in each phase 1
33
Note:
1 This course is helpful to get an exposure of 2+ years as Teradata DBA.
2 This course covers the topics required to clear Teradaga DBA certifications 
3 The real time scenarios, SQLs and commands shown during the sessions will be sent along with study material and documents
4 All the gray highlighted itesm(20, 21 rows) are optional
5 A step by step self explanatory installation guide will be shared upon enrollment which helps you install Teradata on your machine 
 Teradata DBA tracker sheet  
Date Day Time In Time Out Module Convered [Brief Description] Students Remarks
Dhwani Patel      
17-Apr Friday Demo Session done
18-Apr Saturday
19-Apr Sunday
20-Apr Monday Session started
21-Apr Tuesday Session done
22-Apr Wednesday Requesting to HOLD session due to some agrrement signoff.
23-Apr Thursday
24-Apr Friday
25-Apr Saturday
26-Apr Sunday
27-Apr Monday
28-Apr Tuesday
29-Apr Wednesday
30-Apr Thursday
01-May Friday
02-May Saturday
03-May Sunday
04-May Monday
05-May Tuesday
06-May Wednesday
07-May Thursday
08-May Friday
09-May Saturday
10-May Sunday
11-May Monday
12-May Tuesday
13-May Wednesday
14-May Thursday
15-May Friday
16-May Saturday
17-May Sunday
18-May Monday
14-Apr Tuesday
15-Apr Wednesday
16-Apr Thursday
17-Apr Friday
18-Apr Saturday
19-Apr Sunday
20-Apr Monday
21-Apr Tuesday
22-Apr Wednesday
23-Apr Thursday
24-Apr Friday
25-Apr Saturday
26-Apr Sunday
27-Apr Monday
28-Apr Tuesday
29-Apr Wednesday
30-Apr Thursday
01-May Friday
29-Jan
30-Jan
31-Jan
01-Feb
02-Feb
03-Feb
04-Feb
05-Feb