About Trainer

  • 8+ years of IT experience
  • 7+ years in Teradata
  • 5+ years in teaching
  • Certified Trainer
  • Excellent in communication

About Teradata Administration

 
 
 
 
ONLINE TRAINING IN Teradata Administration BY OUR REALTIME/CERTIFIED PROFESSIONALS

Course Pre-requisites:

Training Material:

  • Class PPT’s (Soft Copy)
  • Session recordings (optional)
  • Manuals

Teradata Administration Online Training Course Outline:
  • Introduction
  • Architecture
  • Data Distribution
  • Data Protection
  • Advanced Teradata SQL
  • Performance tuning
  • User Management
  • Capacity Management & planning
  • Work Load Management
  • Archive, Restore & Copy
Course Contents:
Introduction & other essentials:
  • What is Teradata
  • Role of Teradata in DW industry
  • Characteristics of Teradata
  • Advantages of Teradata
  • Hardware & Software components
  • Terminology: vdisks, AMP, PE Vprocs, BYNET, etc
  • What is Teradata
  • Role of Teradata in DW industry
  • Characteristics of Teradata
  • Advantages of Teradata
  • Significance of Index in Teradata
  • UPI, NUPI, SI, NUSI, Partitioned Index
  • Fault Tolerance
  • CLIQUE, CLUSTER, RAID, LOCKS, and JORNALS
  • 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
Performance Tuning:
  • Collecting statistics
  • Explain Plan & Recommendations
  • Indexes & Techniques
DBA:
  • Initial Teradata Databases
  • Administrative User
  • Owners, Parents and Children
  • Creating New Users and Databases
  • Transfer of Ownership
  • DELETE/DROP Statements
  • creation of users, databases,
  • Identify spaces, skew of tables,
  • Moving spaces and accesses,
  • Creating and Using Account ID
  • s
  • 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
  • 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
  • Capacity Management & planning
  • Access Rights
  • Roles & Profiles
  • 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
  • Work Load Management & Priority scheduler
  • Access Logging & Query Logging
  • Performance Monitoring (PMON)
  • Archive and restore data using ARCMAIN utility
  • Different levels of archiving and restoration
  • HUT locks
  • Revalidate references after restoration
  • View Point
 
 
 
 

Testimonials

  • The fact that they have a set format of teaching, which creates a schedule for a student, and a step-by-step process that covers the entire Netezza syllabus. I can surely assure eTraining provides a great help for Netezza curriculum.
    - Shannon D.

  • The BEST I liked about the tutors in eTraining is the amount of practical knowledge these guys have and the way they bring in the same to students perspective while Teaching. Glad I took DB2 course from eTraining.
    - Rubeena Khan

  • I found classes very helpful. What you Teach is AWESOME
    - Gopal