TERA DATA
About This Course
Course Overview :
We aware of industry needs and we are offering Teradata Training in Hyderabad in more practical way. Our team of Teradata trainers offers Teradata in Classroom training, Teradata Online Training and Teradata Corporate Training services. We framed our syllabus to match with the real world requirements for both beginner level to advanced level. Our training will be handled in either weekday or weekends programme depends on participants requirement.
Teradata is a fully scalable relational database management system produced by Teradata Corp. It is widely used to manage large data warehousing operations.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.
Prerequisites
Teradata Course Content
- Introduction
- What is Teradata?
- Teradatav12 & versions Other versions
- Overview OF Teradata
- Teradata warehouse
- Teradata in the Enterprise
- Teradata Users & Scalability
- Teradata Architecture and Components
- Teradata Architecture
- SMP Architecture
- MPP Architecture
- AMP(Access Module Processing)
- TDP(Teradata Directory Program)
- CLI(Call Level Interface)
- TPA(Trusted Parallel Application)
- Parallelism Architecture
- Benefits and Types
- Data Recovery and Security
- Why for locks &how to release
- Various locks for simultaneous access
- RAID 1&RAID 5
- Disk Arrays
- Fall Back
- Clique
- AMP Clustering
- Types OF Journals
- Recovery Journal
- Trasient Journal
- Permanent Journal
- Before Journal
- After Journal
- How & where is used journals
- 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
- Teradata Sql Reference
- SQL Fundamentals
- Data Types and Literals
- Data Definition Statements(DDL)
- Data Manipulation Statements(DML)
- 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
- 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
- Teradata spaces
- PERM space
- SPOOL space
- TEMPORARY space
- Teradata User and managing
- Practical Examples
- Teradata Transaction Modes
- BTET
- ANSI
- Interactive
- Batch
- 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
Your Instructors
