Teradata ( Developer & DBA ) Online Training

Teradata is a RDBMS specifying Data Warehousing and enterprise Analytic application tool. It helps in streamlining huge amount of data into individual moments of assessment via actionable and cognitive insights.  Tysco Online Trainings conducts Teradata Training and the course modules can be tailored according to client’s needs and specification. All the classes are conducted with flexi-time advantage and on interactive virtual platform. Teradata Online training from Tysco Online Trainings covers entire advanced concept through the basic modules.

Academic graduates and working IT professionals (Developers and DBA) are most appropriate recipients for doing this advanced learning course. Contact Helpdesk for more details to enrol Teradata Training

Teradata Online Training Overview:

Teradata is a fully scalable relational database management system produced by Teradata Corporation. It is widely used to manage large data warehousing operations and acts as a single data storage that accepts a large number of concurrent request from multiple client applications. The Teradata database system is based on symmetric multiprocessing technology combined with connecting symmetric,  communication networking multiprocessing systems to form large parallel processing systems. The major features of Teradata are Parallelism along with load distribution shared among several users, complete scalability and execution of complex queries. Teradata training explain the overview TeraData Architecture, Database Space, Teradata DBC Dictionary Tables and DBSize Control.

Course Objectives for Teradata Training:

After the completion of the Teradata course, you will be able to:

  • Understand Teradata’s competitive advantage over other RDBMSs.
  • Understand Teradata Architecture and Indexing mechanism.
  • Use SQL to process data stored in Teradata tables.
  • Use Teradata Training application utilities to import/export data.
  • Apply various performance turning techniques to optimize the queries.

Who should go for this Teradata Training?

The course is designed for all those who want to learn Teradata Training.

  • Developers/Designers who want to gain acceleration in their careers as an Teradata Developer/Designer.
  • Analytics Managers who are subject matter experts, leading a team of analysts.
  • Individual Contributors in the field of Enterprise Business Intelligence.
What are the pre-requisites for this Teradata Training?
  • The pre-requisites for this course include basic Knowledge in SQL, General relational database knowledge and basic unix commands.

TERADATA ONLINE TRAINING COURSE CONTENT:

TERADATA TRAINING ARCHITECTURE
The biggest strength of the Teradata is the parallelism, so the architecture of it is designed in such way to keep this strength in mind. Teradata is unique from other databases because of its unique architecture. In this module of TeraData  you will learn, main components of TeraData Architecture (PE,AMP,BYNET)

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

TERADATA DATABASE SPACE
Teradata is designed in such a fashion, to reduce the DBA’s administrative functions when it comes to space management space. This module of TeraData ,we will let you know, how many ways, Space is configured in Teradata .

  • Permanent Space
  • Spool Space
  • Temp Space
  • Indexes

TERADATA DBC DICTIONARY TABLES
The Teradata Database Data Dictionary is composed of tables and views that reside in the system user named DBC. The tables are reserved for use by the system and contain metadata about the objects in the system, privileges, system events, and system usage. This module of TeraData training, trains you on different types of views and how to track logs(LOGON,LOGOFF).

  • 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

TERADATA ACCESS RIGHTS, ROLES, PROFILES
Roles are generally used to manage the access rights, while profiles are used to maintain user parameters / environment settings like spool space, account string etc.

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

TERADATA TRAINING DBSIZE CONTROL
The following are the different DBS Control fields that you will learn in Teradata Training.

  • DBS Control record -General Fields
  • DBS Control record – File system Fields
  • DBS Control record – Performance Fields
  • DBS Control record – Performance Columns

RESTORING DATA
Restore a database, individual database object, or selected row partitions to Teradata Database from an archived file. Learn, how to copy tables, restore and performing release lock in the conclusive part of Teradata online training.

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

TERADATA QUERY ANALYSIS AND TOOLS
The Teradata Database Optimizer analyzes steps required to execute each query, then chooses the most efficient path that returns answers in the minimal amount of time. Get trained inTeradata Query Analysis and also on tools(VE,SET, Index Wizard, Statistic Wizard) in TeraData training.

  • Database Query Log (DBQL)
  • DBQL Tables and Views
  • Access Logging
  • Statistics Wizard
  • Index Wizard
  • TSET
SYSTEM ACCESS CONTROL LEVELS
Teradata Database privileges for system-level access control are granted by administrators to databases and users (they cannot be defined on any database object)… all this is included in teradata Online training.

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

PRIORITY SCHEDULER
Priority Scheduler is a workload-management facility that controls access to system resources by the different active jobs in Teradata Database.In this module of TeraData online training, you will learn how to define different priorities for different categories of work, and comes with a number of flexible options.

  • PS(Priority Scheduler) Partition Hierarchy PSH Def
  • Resource Partition Examples
  • Multiple resource Partition Example
  • Scheduling Policies
  • Performance Periods
  • TD Manager
  • Learn, How to Start TD manager, Manager App and also how to connect to the Dashboard..
  • TD Manager Apps
  • TD Dashboard
  • Priority Scheduler Admin
  • TD Manager Service
  • Starting TD Manager
  • Enable Data Collection

MONITORING TOOLS IN TERADATA
Several facilities exist for monitoring and controlling system performance. In this module of TeraData training, we’ll discuss about various aspects of monitoring Teradata Database, including the monitoring tools used to track system and performance issues.

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

TERADATA TRAINING REMOTE CONSOLE UTILITIES
This module of Teradata Training, describes how to start Teradata Database utilities. Teradata Database offers several user interfaces from which the utilities may be started and run.

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

ARCHIVING DATA
This session of Teradata DBA Training includes in Archive/Recovery utility (ARC), working with BAR application software, writes and reads sequential files on a Teradata client system to archive, restore, recover, and copy Teradata Database table 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

TOPIC 15:ISSUES AND RESOLVING IN REAL TIME SCENARIOS

What are the course objectives?

At end of this Teradata training by Gang Board you will be clear about,

  • Teradata Architecture
  • Teradata SQL
  • Teradata Programming Language
  • Teradata Supported Utilities

Who should do this course?

  • Fresh Graduates
  • College / School Students
  • Job Seekers
  • Who have more interested about database and Data warehousing.

Teradata Online Training Overview:

Teradata Training is a fully scalable relational database management system produced by Teradata Corporation. It is widely used to manage large data warehousing operations and acts as a single data storage that accepts a large number of concurrent request from multiple client applications. The Teradata database system is based on symmetric multiprocessing technology combined with connecting symmetric, communication networking multiprocessing systems to form large parallel processing systems. The major features of Teradata are Parallelism along with load distribution shared among several users, complete scalability and execution of complex queries. Teradata training explain the overview TeraData Architecture, Database Space, Teradata DBC Dictionary Tables and DBSize Control.

Teradata Training is an enterprise software company that develops and sells a relational database management system (RDBMS). Teradata is considered as a “Data ware house system”, which can manage data, store data & BAR (BACKUP, ARCHIVE &RESTORE) data.

Teradata online training shares the knowledge of gathering the data from multiple sources and makes it available for the analysis.

Teradata 13.10 stores and processes the data in an open parallel framework, whereas Teradata 14 is upgrade for Teradata 13 including column store analysis.

Teradata Training masters the learners in using the tool for business analysis, storage of data in the offsite recovery center and its retrieval.