India

+91 8447799888

USA

+1 (515) 442-2418

Teradata Certification Training Course

Checking...

Ouch! There was a server error.
Retry »

Sending message...

Enquiry Now


time-icon-vector-png_125592-removebg-preview

Course Duration

50 Days.

833px-PDF_file_icon.svg

Download Course Curriculum

ABOUT COURSE

Teradata Online Training is basically a database, that is designed to handle analytical queries. The typical analytical queries process huge amount of data and take longer time(say 30 seconds to 1 hour) to execute. So the focus of Teradata DBMS is on scalability, parallel processing and performance (find optimal plan for the query).

Teradata Certification is one of the popular Relational Database Management System. It is mainly suitable for building large scale data warehousing applications. Teradata Courses achieves this by the concept of parallelism. It is developed by the company called Teradata. The Teradata database system is based on off the shelf symmetric multiprocessing technology combined with communication networking, connecting symmetric multiprocessing systems to form large parallel processing systems.

Benefits of Attending Teradata Training

Following are some of the features of Teradata SQL training material −

Why Kasha Training Education?

Feedback from our Participants

COURSE CURRICULUM

  • Teradata Components & Architecture
  • Data Distribution in Teradata
  • Teradata space management
  • Creating tables
  • Temporary tables
  • Parsing Engine(PE)
  • Request and Response Parcel
  • Access Module Processors (AMPs)
  • Benet
  • Data access Handling
  • TD Config Utilities
  • Config and Recon fig
  •  
  • Permanent Space
  • Temp Space
  • Indexes
  •  
  • Data dictionary
  • Parsing Engine
  • System Views
  • Database Views
  • DBC Users View
  • Indices View
  • The Parsing Engine (PE)
  • 4. The Access Module Processors (AMPs)
  • 5. The BYNET
  • All Temp Tables View
  • Using DBC AMP Usage
  • Using DBC Table Size
  • Logon and Logoff Tracking.
  •  
  • Access rights (Auto,implicit,Explicit Rights)
  • Roles and Profiles
  • Creating Roles and Profiles
  • DBC.RoleInfo and DBC.ProfileInfo
  •  
  • Database Query Log (DBQL)
  • DBQL Tables and Views
  • Access Logging
  •  
  • TD Password Encryption
  • Password Security Features
  • Host Logon Processing
  • Fallback protection /clusters (group of NODES)
  • Redundant Array of Independent Disks (RAID)
  • Cliques (group of AMPs)
  • GRANT/REVOKE LOGON
  • Session Related Views
  • DBC.sessionInfo Info View
  • Data Access Info Views
  • Access LogRules Views
  • Access Log Views
  •  
  • TD Manager Apps
  • TD Dashboard
  • TD Manager Service
  • Starting TD Manager
  •  
  • Performance Monitor
  • PMON Main window
  • PMON sessions Screen
  • TD Administrator
  • Locking Logger
  •  
  • Starting DB Window
  • SHOWLOCKS
  • SHOWSPACE
  • SHOWBLOCKS
  • PACKDISK
  • SCANDISK
  •  
  • Archive and Recovery Statements
  • Recovery vs. FastLoad
  • Invoking Archive
  • Restart Log
  • Archive
  • Database DBC Archive
  • Indexes option
  • Database DBC Archive
  • Archive and Recovery (ARC) Examples
  •  
  • Restore
  • COPY
  • Copying Tables
  • BUILD
  •  

WHO CAN LEARN?

FAQ

Most frequent questions and answers

Click on Enquire now and register.

Yes we do provide Demo session and one free class that will help you to decide.

Yes all relevant material would be provided.

Yes all relevant material would be provided.

About Us

Kasha Training is one of the world’s leading Online training providers, helping professionals across industries and sectors develop new expertise and bridge their skill gap for recognition and growth in the corporate world.

Copyright © 2021 Kasha Training. All Rights Reserved

Need Help? Chat with us