TERADATA DBA SYLLABUS

COMPLETE PRACTICAL and REAL-TIME ORIENTED TRAINING WITH PROJECTS

UNIQUE FEATURES OF VINAYTECHHOUSE?

•           In detail subject with clear diagramatic explanation {Unique Style }.
•           Full practical oriented classes with Real-time examples and situations.
•           Certification based training and interview related practices.
•           Exclusive project helps to under Teradata Project Environment .
•          Various documents discussion (used in real-time) to work effectively.

TERADATA DBA SYLLABUS

(DBA PART1: PERFORMANCE TUNING  DBA) 1. Prerequisites and Start up v  What is Teradata Datawarehouse? v  Teradata presence in IT. v  Teradata vs Other Databases. v  Teradata Competitive advantages. v  Teradata Capabilities and Limits. v  Teradata 15 & Other versions( 14,13.10,13,12) v  Teradata History and Real time running versions v  Teradata View Point Features (Web based management tool)*** v  Descriptions on Golden Gate and Data Mover*** v  Loading Types (Truncate, SCD, CDC etc…) v  HW and SW requirements & installation steps v  Teradata DBA Over view (System DBA, Application DBA) Discussion on Interview and Certification questions 2)Teradata Single ,Multi and Cloud System v  Node Architecture(Shared Nothing) v  SMP Architecture v  MPP Architecture v  Cloud Architecture (Teradata 14) v  Discussion on real time no of AMPs and Nodes Real time Project Configurations 3)Teradata Components and Explanation v  PDE(Parallel Data Extension), v  Vprocs (Virtual Processors) v  TPA (Trusted Parallel Application) v  PE(Parsing Engine) v  AMP(Access Module Processing) v  BYNETs (Board less, Board Oriented) v  TDP (Teradata Directory Program) v  CLI(Call Level Interface), v  VSS (Virtual Storage System)*** Discussion on  Certification & Interview questions Discussion on various organizations configurations.

4) Teradata Server, Client and Pre-requisites v  Server start, stop, pause in Linux & Windows v  Client tools to operate [GUI, Wizard, CUI] v  Teradata Sql-Assistant, BTEQ, Query Studio v  Teradata Viewpoint Overview and Portlets v  Open Database Connectivity (ODBC), OLEDB v  Working with Sql-Assistant, BTEQ v  Transaction Modes [BTET, ANSI] v  Single, Multi Statement request operations v  Normal and Bulk Load/Unload v  Command, Query and Request Processing Practical on this with case studies 5) Teradata Indexes (Primary, Secondary)         Primary Index v  Unique Primary Index (UPI) v  Non Unique Primary Index (NUPI) v  Partitioned Primary Index (PPI) (Range_N, Case_N, Multi Valued PPI ***) v  NOPI (No Primary Index)*** v  Full Uniform Distribution vs Skewed distribution. v  Skewness and Skewfactor Secondary Index v  Unique Secondary Index (USI) v  Non Unique Secondary Index(NUSI) v  Value Ordered Secondary Index (VOSI) v  Hash Index (HI) v  Join Index (JI) and Types (Single, Multi, Sparse, Aggregate) Full Table Scan(FTS) - Execution process Diagrammatic explanation, syntaxes and practical. Performance improvement indexes and tuning them.

6) Locks, Data Recovery and Protection v  Object Locks -Access, Read, Write, Exclusive, Hut v  NO Wait ,Pseudo table lock v  HSA,HSN (Hot Stand By AMP,NODE) v  RAID1 ,RAID5 , Disk Arrays v  Fall Back , AMP Clustering v  Clique v  Images (Single , Dual , Before, After) v  Journals ( Recovery , Transient and Permanent Journals ,Write ahead logging) Real time usages and detailed practices 7) Performance Tuning v  Scripts and Queries Bottlenecks v  Explain request modifier v  Explain plan steps explanation v  Join Strategies Product Join Strategy Merge Join Strategy Nested Join Strategy Row Hash Join Strategy v  Collect statistics, Collecting and  Updating v  Recommendations for statistic columns v  Diagnostic Help Stats Command and Stats wizard v  Skewness and Skew factor v  More memory & Out of Spool memory issue v  Hash functions (Hashrow, HashAmp, HashBucket ) v  Performance monitor,Explaining various tabs v  ViewPoint various portlets for perfoamance v  General Query Tuning tips in various Sql constructs

(DBA PART2: APPLICATION  DBA) 1) Building TD database environment v  Initial Teradata database structure v  Administrative user creation and usages v  Owners , Parents and children Memory management (Permanent, Spool and Temporary) v  Drop and Delete Statements (Users & Databases) Real time users and databases with practical. 2) Teradata Accounting v  Create user statement with accounting v  System accounting, views and usages v  DBC.AccountInfo(X) view v  DBC.AMPUsage view v  Account String Expansion, advantages Real time accounting with scenarios. 3) Users, Databases and Data Dictionary v  Create database and user statements v  Password Encryption and Security v  Profiles and usages v  Create Profile syntaxes and GUI v  Impact profiles on users, password attributes v  Data Dictionary v  [Non]Fallback protected v  Updating data dictionary tables v  System Views, [non]Restricted views v  Databases, Users and Children views Real time users, databases with scenarios. 4) Other Admin tools v  Teradata Administrator v  Performance Monitor {PMON} v  Statistics Wizard v  Index Wizard v  Visual Explain

5) Access Rights v  Privileges / Access rights mechanisms v  Implicit ,Explicit and Automatic access rights v  Granting right, Grant public v  Revoke statement ([non] existent object) v  Inheriting access rights v  Give statement and access rights v  Removing level in the hierarchy v  Roles, Advantages v  Access rights without roles v  Access rights using a role v  SQL Statements for roles (Grant ,Revoke) v  Steps to implement roles v  Using views to limit access v  Macros and Procedures to control access v  System views for access rights v  Allrights and user rights views v  DBC.Usergrantedrights view v  Roleinfo(X) view, Rolemembers(X) view Practical on these features 6) Access and Query Logging [DBQL] v  Access Logging in detail v  DBQL tables usage v  Begin and End Logging Real time logging and DBQL operations. 7) DBC Control Utilities v  DBS Control Records v  PackDisk v  Checktable v  ScanDisk v  Ferrot v  Showlocks v  Table ReBuild v  Recovery Manager

8) Recovery tools v  Teradata Data Protection v  Netvault, Net Backup tools Architectures in Mainframe & Unix Detailed explanation about these statements 9) Achieving Data v  ARC Utility ,Phases and Statement v  Archive Objects ,Levels ,Options ,Types Practical on these statements 10) Restoring Data v  Restore statement , tables v  Copy statement , tables v  Build statement v  Hot Locks v  Release lock statement Practical on these statements 11) Starting /Restarting /Stopping Database v  Database Supervisory Window v  Database Set up v  Operations on Windows, Unix among more Practical on these features

12) VIEW POINT, PORTAL PAGE & PORTLETS v  View Point description v  Rewind, Pause,Stop and Abort v  View Point configuration v  System Health Portlet v  Teradata Workload analyzer v  Unity Director v  Unity Ecosystem Manager v  Unity Data Mover v  Remote Control v  Alert viewer v  SQL ScratchPad v  Workload Management v  Query Monitor v  Query Groups v  Data Labs v  Administration Portlets (Backup,General etc...) v  Teradata Active System Management (TASM) Practical on these features with real time case studies.