TERADATA DEVELOPMENT
About This Course
Introduction
Teradata Development Training
Teradata is a database, which is planned to manage logical queries. Teradata is basically a relational database management system that means It is an open-system, operating on the UNIX MP-RAS or Windows machine platform. It is assisting several concurrent users from various customer systems capable. It is suitable for market specifications. Teradata is totally developed over a parallel architecture.
Course Objectives
What you’ll learn in Teradata Development Training Course?
- Learn the basic concepts of Teradata.
- Know the Architecture and Indexing mechanism.
- How to process the data using SQL in tables.
- How to import or export data using Teradata application utilities.
- How to implement different performance turning methods.
What are the pre-requisites to learn Teradata Development Course?
- Basic Knowledge of SQL is mandatory.
Course Curriculum
MODULE 1: INTRODUCTION
- Overview
- Different versions
- Warehouse
- Users and Scalability
- Enterprise Usage
MODULE 2: ARCHITECTURE AND COMPONENTS
- 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: INDEXES
- Unique
- Primary Index
- Non-unique
- Secondary Index
- Partitioned
- Hash, Join, Value Ordered
- Secondary Index Subtable
- Skewness
- Keys Vs Indexes
MODULE 5: 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: BASIC COMMANDS
- Show
- Help
- Collect Statistics
- Explain
MODULE 9: TERADATA OBJECTS
- Tables
- Multi Settable
- 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
- 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
Your Instructors
Free
