• India Flag
    Call Us:

    +91 769-409-5404

  • USA Flag
    Call Us:

    +1 786-629-6893

About Course:

This training program is designed to prepare the students for Teradata Administrator. The Teradata DBA bootcamp training is practical oriented with real time scenarios, which helps you to gain knowledge on field experience. You learn in this course how to replicate data across environments, monitor and manage databases, perform SQL tuning and analysis, provide capacity planning, grant data level access privileges, Implementing monitoring procedures to maximize system availability, Managing and tuning Teradata Workload Management designing and creating workload groups, priorities, throttles, and various day to day activities a DBA has to perform.


Duration : 30 hours

Fee: 319


Job Trends


Who Should Learn?
Prerequisite

This certification training course does not presume or require any prior knowledge or prerequisites. However, basic knowledge of salesforce concepts be an added advantageous. We are recommending that students should have following: To be an administrative professional Should possess clear knowledge and grasp of salesforce concepts knowledge on SQL, HTML and JavaScript should be an added advantage

Delivery Methodology
We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.
Class Delivery
Live Interactive classes with expert

Training Calender

Date Time Type Attend
No Schedule Available
Contact Us

+91 769-409-5404

Includes
  • 24 hours on-demand video
  • Articles
  • Coding Exercises
  • Full lifetime access
  • Certificate of Completion

Curriculum

Teradata Admin Track

Teradata Architecture and other essentials

  • Introduction
    • What is Teradata and role of Teradata in Data Ware housing industry, Evolution of Teradata DW, Significant characteristics of Teradata, Advantages of Teradata over other RDBMS
  • Teradata Architecture
    • Understanding H/W and S/W components, involved in Architecture of Terdata(vdisks, AMP, PE Vprocs, BYNET etc...).
  • Data distribution
    • Understanding significance of Index in teradata(UPI, NUPI, SI, NUSI, Partitioned index )
  • Data Protection
    • Different levels of failures that could happen and fault tolarance of Teradata in that situations. (CLIQUE, CLUSTER, RAID, LOCKS and JORNALS)
  • 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.

Others (Optional)

  • Unix
    • Role of Unix in executing Teradata utility scripts and Basic commands used
  • General Lifecycle of the projects
    • General phases of a Development project. Documents required in each phase

DBA

  • 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
  • User and Security Management
    • Understand the Heirarchy,Teradata Administrator tool usage to perform creation of users, databases, Identify spaces, skew of databases, Moving spaces and accesses, And all the practicals to perform of all coming up topics.
  • 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
  • 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.
  • Users, Accounts, and Accounting
    • Creating and Using Account IDs
    • Using Account IDs with Logon
    • Dynamically Changing an Account ID
    • Account Priorities
    • Account String Expansion
  • 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
  • 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
  • Work load management and Priority scheduler
    • Levels of Workload Management, Priority Scheduler Architecture, and concepts
  • Access logging and Query logging
    • Setting up Access Logging, AccLogRules View, Query Logging (DBQL) Concepts, Objects
      used in Defining Rules for DBQL, DBQLRules View
    • Setting up Access Logging, AccLogRules View, Query Logging (DBQL) Concepts, Objects
      used in Defining Rules for DBQL, DBQLRules View
  • Performance monitoring (PMON)
    • Resource usage, Session Management User session Info, SQL & Explain Steps
  • Archive and Restore and copy
    • Archive and restore data using ARCMAIN utility, Different levels of archiving and restoration,
      HUT locks, Revalidate references after restoration
  • View point
    • The Demo of view point portlets (which is new tool for DBAs having the features of PMON,
      TDMANAGER and TASM

Performance tuning

  • Explain plan, Statistics and Join strategies
    • Explain plan and recommandations.
    • Significance of collecting� statistics
  • Other indexes, and techniques
    • Determine the proper join columns, Join index, Spars index, Aggregate index, SET / MULTSET with UPI and NUPI combinations, compress.
  •  

Use Case

Use Case 1

Certificate

Certificate
Benefits of Certificate

Certification demonstrates your dedication, motivation and technical knowledge on a specific platform. Having a certification shows that you not only possess comprehensive knowledge of that technology but you also care enough about your own career to spend the time and money to get the certification.

We are welcoming our Students or professionals to participate in our professional online courses. We are offering great variety of online training programs and professional courses that you can always find as desired. After the completion of training program they will receive a certificate from BISP. As a Certified professional you can apply that knowledge in your future profession and enjoy with better salaries & career prospects.

Signup for free newsletter and
business tips

Any Questions?
Talk to our Course Co-ordinator

+91 769-409-5404
Want to see a live demo? We'll be in touch within 24 hours?