Tera Data
Course
In Hyderabad
₹ 1
VAT incl.
Description
-
Type
Course
-
Location
Hyderabad
-
Class hours
45h
Facilities
Location
Start date
Hyderabad
(Andhra Pradesh)
See map
516,Annapurna Block, AdityaEnclave, Ameerpet, Hyderabad-500026, 500026
Start date
On request
Reviews
Have you taken this course?
Course programme
TERADATA 12Teradata Warehouse and Competitiveness
What is Teradata-RDBMS
Teradata 12 Vs Other versions
Teradata History
Teradata in the Enterprise
Teradata Users & Scalability
Teradata competitiveness with other RDBMS
(Oracle, SqlServer etc)
Teradata Warehouse
Discussion on interview and certification questions
Teradata Architecture and Components
PDE(Parallel Data Extension)
Vprocs(Virtual Processors)
AMP(Access Module Processing)
Board less Bynet
TDP(Teradata Directory Program)
CLI(Call Level Interface)
TPA(Trusted Parallel Application)
Going in depth by explaining the process of SQL statement execution
Various Architectures
Node Architecture(Shared Nothing)
SMP Architecture
MPP Architecture
Parallelism Architecture
Benefits and Types
Data Recovery and Protection
Object Locks
Various locks for simultaneous access
RAID 1
RAID 5
Disk Arrays
Fall Back
Clique
AMP Clustering
Journals
Recovery Journal
Trasient Journal
Permanent Journal
Before Journal
After Journal
Answering various recovery questions
Teradata Storage and Retrival Architectures
Request Processing
Syntaxer
Resolver
Security Module
Optimizer
Step Generator
GNC Apply
Dispatcher
Primary Index
Hash algorithm
Row Hash
DSW
Hash Map
Hash Bucket
Reaching V disk
Teradata Indexes
Primary Index
Unique
Non unique
Partitioned
Secondary Index
Unique
NonUnique
Hash, Join, Value Ordered
Skewness
Secondary Index Sub table
Accessing Records via Primary Index
Accessing records via Secondary Index
Keys Vs Indexes
Full Real time scenarios and explaining
Teradata Sql Reference
Fundamentals
Data Types and Literals
Data Definition Statements
Data Manipulation Statements
Explaining with proper examples
Teradata Functions and Operators
String Functions
Format Function
Cast Functions
Group & Aggregate Functions
With & with by clauses
Practices of this section
Teradata Transactions
Implicit Transaction
Explicit Transaction
Performance Tuning and Explain Utility
Explain Usage
Collecting Statistics
Tuning SQL Performance
Usage of PMON
Explaining various SQL statements
Joins and Unions
Inner Join
Left Outer Join
Right Outer Join
Full Outer Join
Detailed explanation
Join Strategies
Product Join
Merge Join
Hash Join
Nested Join
Questions of this section
Teradata Basic Commands
HELP
SHOW
EXPLAIN
COLLECT STATISTICS
Teradata Objects
Tables
SET table
Multi Set table
Volatile tables
Global Temporary tables
Derived tables
Views
Macros
Stored Procedures
Triggers
Practices and FAQs of this session
Teradata spaces
PERM space
SPOOL space
TEMPORARY space
Teradata User and managing
Practical Examples
Teradata Transaction Modes
BTET
ANSI
Interactive
Batch
Load and Unload Utilities & Tools
Teradata Sql Assistant(Queryman)
Teradata Performance Monitor
Teradata BTEQ
Batch Scripts with samples
Branching and Looping
Importing data through scripts
Exporting data through scripts
Error handling
Explanation with proper debugging
Teradata Fast Load
Various Phases of Fast Load
Advantages and Process
Limitations of Fast Load
Sample Scripts
Real time Issues and resolving it
Teradata Multi Load
Various Phases of Multi Load
Limitations of Multi Load
Working with multiple tables
Applying various operations
Sample Scripts
Real time Issues and solving it
Teradata Parallel Data Pump
Limitations of TPump
Overview of TPump
Sample Scripts
Teradata Fast Export
Exporting Data
Passing Parameters
OUTMODS
Sample Scripts
Utility Vs Parallelism
Introduction to
Answering AD-hoc queries and FAQs
Covering DBA Concepts
Concentrating on Performance Tuning
Tera Data
₹ 1
VAT incl.