• India Flag
    Call Us:

    +91 769-409-5404

  • USA Flag
    Call Us:

    +1 786-629-6893

About Course:

Teradata-Admin-Track

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

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

Module of Training

LIVE ONLINE TRAINING


Live presentation of theory, demonstration of tool, features & tasks

We are connecting Online via Goto Meeting

You will get recordings of each training session that you attended

Get practice environment for practical & hands-on Training curriculum has been designed by real-time industry professionals & real-time scenarios training pattern

CORPORATE TRAINING


Learn as per day-wise & customized schedule with discussions & lab exercises included

One to one or Batch-wise interactive demonstration of a tool, features and 100% practical classes

World-class learning material & case studies for the course

Completely customizable course content & schedule as per convenience

Certification guidance provided if necessary

Curriculum

Teradata Admin Track Download  

Teradata Admin Track web based Online Training Curriculum


Introduction and Getting Started

  • What is Teradata?
  • Teradata Architecture
  • Role of Teradata in Data Ware housing industry
  • Evolution of Teradata DW
  • Significance and characteristics of Teradata
  • Advantages of Teradata over other RDBMS

Teradata Architecture

  • Understanding H/W and S/W components
  • Involved in Architecture of Teradata
  • V-disks
  • AMP
  • PE
  • V procs
  • BYNET

Data distribution

  • Understanding significance of Index in Teradata
  • UPI
  • NUPI
  • SI
  • Data distribution continues...
  • NUSI
  • Partitioned index

Data Protection

  • Different levels of failures that could happen and fault tolerance of Teradata
  • CLIQUE
  • CLUSTER
  • RAID
  • LOCKS
  • 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 Hierarchy
  • Teradata Administrator tool usage to perform creation of users
  • Databases
  • Identify spaces
  • Skew of databases
  • Moving spaces and accesses
  • Practical’s

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 requirements 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 and Access Rights
  • Implicit
  • Access Rights continues...
  • Automatic
  • 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
  • Acc Log Rules View
  • Query Logging (DBQL) Concepts and objects
  • Used in Defining Rules for DBQL
  • DBQL Rules View
  • Setting up Access Logging
  • Acc Log Rules View
  • Query Logging (DBQL) Concepts
  • Objects
  • Used in Defining Rules for DBQL and DBQL Rules 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

  • 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 recommendations
  • Significance of collecting and statistics
  • Other indexes and techniques
  • Determine proper join columns
  • Join index
  • Spars index
  • Aggregate index
  • SET / MULTSET with UPI and NUPI combinations
  • Compress

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

Who should Learn Teradata Admin Track?

IT professionals

Analytics managers

Administrators

Fresh Graduates

Professionals who want to enhance their skills in database management, and administration.

Prerequisite to learn Teradata Admin Track

Participants are expected to have basic knowledge of SQL

General relational database knowledge

Basic UNIX commands.

Delivery Methodology used to deliver the Teradata Admin Track

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

Teradata Admin Track FAQ

Question: Can I attend the Demo session before enrollment?

Answer: Yes, you may attend the Demo class before enrollment for training Quality Evaluation. You can also Interact with a trainer as one to one session for a specific requirement or discussion

Question: Can you schedule the training based upon my availability?

Answer: Yes, we need to discuss it with a trainer, accordingly, we can schedule training at a convenient time.

Question: How I can pay for the course?

Answer: You can pay the fee or enroll yourself via payment gateway through the course page, make an online payment using various options.

Question: What if I missed any class?

Answer: BISP has a missing class policy. If you missed any session, we will be sharing a recorded session. However, you may retake whole training multiple times within 6 month period but the trainer is the same.

Question: Is there any live project training along with regular training?

Answer: Our training curriculum includes real-time scenarios and lives project working module & the trainer explains every topic with examples. If you have any issue or you are stuck in any scenario the trainer will explain end-to-end.

Question: What about certification preparation and guidance?

Answer: BISP technical faculty assist & guide you completely for certification and preparation. We ensure you will get certified easily after our training.

Question: Who is the trainer & about his experience?

Answer: All our trainers are working professionals and industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo We also ensure that only those trainers with a high alumni rating continue to train for us.

Question: Do you provide Job support?

Answer: Yes, we provide Job support services, but the cost structure is different and fixed. For more details: Just give us a call at: +91 769-409-5404 & +1 786-629-6893 You can also write to us: support@bisptrainings.com

Question: What if I have more queries and doubts?

Answer: Just give us call at : +91 769-409-5404 & +1 786-629-6893 You can also write to us: support@bisptrainings.com

Question: How Fee Refund Policy works?

Answer: Please refer the link for refund policy: https://www.bisptrainings.com/Refund-Policy

Case Study and Learning Pdf's

Certificate

Certificate123
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?