Teradata Administration
Introduction
Teradata is a database, which is planned to manage logical queries. Teradata is basically a relational database management system that is Teradata is an open-system, operating on the UNIX MP-RAS or Windows machine platform. Teradata is of assisting several concurrent users from various customer systems capable. Teradata is suitable for market specifications. Teradata is totally developed over a parallel architecture.
COURSE SUMMARY
Course Name | Teradata Development Online Training |
Contents | Fundamentals, Architecture and Components of Teradata etc. |
Duration | 30 Hours with Flexible timings |
Delivery | Instructor Led-Live Online Training |
Eligibility | Any Graduate |
Ideal For | Freshers, aspirants seeking to learn the Teradata Development |
Next Batch | Please visit the schedule section |
Course Objectives
- Learn the basic concepts of Teradata.
- Know the Architecture and Indexing mechanism of Teradata.
- How to process the data using SQL in Teradata tables.
- How to import or export data using Teradata application utilities.
- How to implement different performance turning methods.
PR-EREQUISITES:
- Basic Knowledge of SQL is mandatory.
Course Curriculum
MODULE 1: INTRODUCTION
- Overview of Teradata
- Teradata versions
- Teradata warehouse
- Teradata Users and Scalability
- Teradata in the Enterprise
MODULE 2: ARCHITECTURE AND COMPONENTS OF TERADATA
- Teradata Architecture
- MPP Architecture
- SMP Architecture
- AMP, TDP, CLI, TPA
- Parallelism Architecture
MODULE 3: DATA RECOVERY AND SECURITY
- locks
- Different locks
- RAID 1 and RAID 5
- Fall Back
- Disk Arrays
- Clique
- Types of Journals
- AMP Clustering
MODULE 4: TERADATA INDEXES
- Unique
- Primary Index
- Non unique
- Secondary Index
- Partitioned
- Hash, Join, Value Ordered
- Secondary Index Sub table
- Skewness
- Keys Vs Indexes
MODULE 5: TERADATA SQL REFERENCE
- SQL Fundamentals
- Data Definition Statements(DDL)
- Data Types and Literals
- Data Manipulation Statements(DML)
MODULE 6: TERADATA FUNCTIONS AND OPERATORS
- Format Function
- String Functions
- Cast Functions
- With & with by clauses
- Group & Aggregate Functions
MODULE 7: TERADATA TRANSACTIONS
- Explicit Transaction
- Implicit Transaction
- Collecting Statistics
- Performance Tuning and Explain Utility
- Tuning SQL Performance
- Usage of PMON
- Joins and Unions
- Inner Join
- Right Outer Join
- Left Outer Join
- Full Outer Join
- Product Join
- Join Strategies
- Merge Join
- Nested Join
- Hash Join
MODULE 8: TERADATA BASIC COMMANDS
- Show
- Help
- Collect Statistics
- Explain
MODULE 9: TERADATA OBJECTS
- Tables
- Multi Set table
- SET table
- Global Temporary tables
- Volatile tables
- Views
- Derived tables
- Macros
- Triggers
- Stored Procedures
MODULE 10: TERADATA SQL ASSISTANT (QUERYMAN)
- Teradata BTEQ
- Teradata Performance Monitor
- Branching and Looping
- Batch Scripts with samples
- Importing and Exporting data through scripts
- Error handling
- Teradata Fast Load
- Advantages and Process
- Sample Scripts
- Limitations of Fast Load
MODULE 11: REAL TIME ISSUES
- Teradata Multi Load
- Limitations of Multi Load
- Working with multiple tables
- Sample Scripts
- Limitations of TPump
- Sample Scripts
- Exporting Data
- OUTMODS
- Utility Vs Parallelism
Course Reviews
No Reviews found for this course.
Write a Review