TeraData Training

BY
Mindmajix Technologies

Become a Certified TeraData Professional by enrolling in the online training by Mindmajix.

Mode

Online

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study, Virtual Classroom
Mode of Delivery Video and Text Based
Frequency of Classes Weekdays, Weekends

Course overview

TeraData Training course is a training created and administered by the e-learning platform Mindmajix in the online mode that helps the candidates to know the concepts of TeraData, a database with unique architecture, closely. The training programme will let the students develop data warehousing applications making use of Teradata and clear the Teradata certification exam. The learners can enrol in the course through any of the three options on offer, namely, the corporate training, the 30 hrs of E-Learning Videos and 30 hrs of Remote Classes in Zoom or Google meet.

The students will need to have the prerequisites of having basic knowledge of SQL, fundamental basics of Linux and relational database commands to be eligible for joining the TeraData Training online course. The curriculum will cover the main components of Teradata Architecture (PE, AMP, BYNET), TERADATA Database Space, Teradata Query Analysis And Tools and whatnot through projects, real-time examples and case studies. Post the  TeraData Training certification, Mindmajix will also render the learners the services of access to the resume builder, lifetime access to the e-learning videos, mock interviews, career guidance etc.

The highlights

  • 100 %  online course
  • Offered by Mindmajix
  • FREE Demo on Request
  • Flexible Schedule
  • Online Live and Self-paced Training Options
  • 24/7 Lifetime Support
  • Life-Time Self-Paced Videos Access
  • One-on-One Doubt Clearing
  • Certification Oriented Curriculum

Program offerings

  • One-on-one doubt clearing sessions
  • Certification oriented curriculum
  • Real-time project use cases
  • 20 hours of labs
  • Free demo on request
  • 24/7 lifetime support
  • 30 hours of sessions
  • Online live and self-paced training options

Course and certificate fees

certificate availability

Yes

certificate providing authority

Mindmajix Technologies

What you will learn

Database management

Through the TeraData Training online certification, the candidates will be able to develop a thorough understanding of Teradata and its applications, SQL operations, Teradata architecture, indexing mechanism, Application utilities, data security in Teradata and advanced database object. Plus, the students will learn the advantages of  Teradata over other RDBMSs, performance tuning techniques and the skills to process data in n Teradata tables making use of SQL processes.

The syllabus

Teradata Architecture

  • Parsing Engine (PE)
  • Request and Response Parcel
  • Access Module Processors (AMPs)
  • Bynet, Data access Handling
  • TD Config Utilities
  • Config and Reconfig

Teradata Database Space

  • Permanent Space
  • Spool Space
  • Temp Space
  • Indexes

DBC Dictionary Tables

  • Data dictionary
  • Parsing Engine
  • System Views
  • Database Views
  • DBC Users View
  • Indices View
  • All Temp Tables View
  • Using DBC AMP Usage
  • Using DBC Table Size
  • Logon and Logoff Tracking

Access Rights, Roles, Profiles

  • Access rights (Auto, implicit, Explicit Rights)
  • Roles and Profiles
  • Creating Roles and Profiles
  • DBC.RoleInfo and DBC.ProfileInfo

Teradata Query Analysis And Tools

  • Database Query Log (DBQL)
  • DBQL Tables and Views
  • Access Logging
  • Statistics Wizard
  • Index Wizard
  • TSET

System Access Control Levels

  • TD (TeraData) Password Encryption
  • Password Security Features
  • Host Logon Processing
  • GRANT/REVOKE LOGON
  • Session Related Views
  • DBC.sessionInfo Info View
  • Data Access Info Views
  • Access LogRules Views
  • Access Log Views

Priority Scheduler

  • PS (Priority Scheduler) Partition Hierarchy PSH Def
  • Resource Partition Examples
  • Multiple resource Partition Example
  • Scheduling Policies
  • Performance Periods

TD Manager

  • TD Manager Apps
  • TD Dashboard
  • Priority Scheduler Admin
  • TD Manager Service
  • Starting TD Manager
  • Enable Data Collection

Monitoring Tools In TeraData

  • Performance Monitor
  • PMON Main window
  • PMON sessions Screen
  • TD Administrator
  • TD manager Dynamic Utilization Charting
  • Alert Facility and Viewer
  • Locking Logger

TD (TeraData) Remote Console Utilities

  • Starting DB Window
  • QRYCONFIG
  • QRYSESSN
  • RCVMANAGER
  • SHOWLOCKS
  • VPROCMANAGER
  • SHOWSPACE
  • SHOWBLOCKS
  • PACKDISK
  • SCANDISK

Archiving Data

  • Archive and Recovery Statements
  • Recovery vs. FastLoad
  • Invoking Archive
  • Restart Log
  • ANALYZE Statement
  • Archive, Database DBC Archive
  • Indexes option
  • Database DBC Archive
  • Archive and Recovery (ARC) Examples

Restoring Data

  • Restore
  • COPY
  • Copying Tables
  • BUILD
  • RELEASE LOCK

Practice Test & Interview Questions

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books