Teradata Training And Placement - Online And Classroom Trainings

[sravaniravi]

9startek is offering Terasata Training.

 

 

 

 

TERADATA

1. Teradata Warehouse and Competitiveness

1. What is Teradata-Rdms/Data Ware House?
2. Teradata history and real time versions
3. Teradata in the Enterprise
4. Teradata Users & Scalability
5. Teradata competitiveness with other RDBMS

(Oracle, SQL Server, etc…) Differences between them

1. Teradata Warehouse and Usability

1. Teradata Various Architectures

1. Node Architecture( Shared nothing)
2. SMP  Architecture
3. MPP Architecture
4. Parallelism Architecture

1. Teradata components and Explanation

1. PDE (Parallel Data Extension)
2. Vprocs (Virtual Processors)
3. PE (Parsing Engine)
4. AMP (Access Module Processing)
5. BYNETS (Boardless, Board Oriented)
6. TDP (Teradata Directory Program)
7. TPA (Trusted Parallel Application)

1. Teradata Practical (DBA Related Concepts)

1. Teradata server Starting/Stopping
2. Working with teradata sql Assistant and BTEQ.
3. Creating Database and Manipulation
4. Creating User and Manipulation
5. Managing Databases and Users
6. Data Dictionary and Views
7. Working with Teradata Administrator tool.

 

 

 

1. Memory Management, Spaces(DBA & Developers)

1. PERMANENT, SPOOL, TEMPORARY.
2. PEAK Perm, CURRENT Perm, MAX Perm.

1. Teradata SQL

1. Data Definition Language
2. Data Manipulation Language
3. Data Control Language
4. Stored Procedure Language
5. Teradata Extensions

1. HELP
2. SHOW
3. EXPLAIN
4. COLLECT STASTICS

1. Data Definition Language

1. Creating Table
2. Types of Tables

1. Set
2. Multiset
3. Volatile
4. Error Tables (Error Logging)

1. Altering/Renaming table and features
2. Dropping Table

1. Data Manipulation Language

1. Retrieval of data from objects
2. Manipulation

1. Insert
2. Update
3. Delete
4. Merge
5. Upsert

 

 

 

1. Data Control Language

1. GRANT
2. REVOKE

1. Locks, Data Recovery and Protection

1. Object Locks

Access, Read, Write, Exclusive

1. RAID1, RAID5, Disk Arrays
2. Fall Back, AMP Clustering
3. Clique
4. Types of Images

Single, Dual, Before, After

1. Journals

Recovery journal,

Transient journal,

1. Permanent journal

Before journal,

After journal

1.  Other Components of Table

1. Data Types (ANSI, Teradata)
2. Data Type Attributes
3. Column Storage Attributes
4. Constraints

Primary/ Unique/ References/ Check

1. Soft Referential Integrity

1.  Teradata Transactions

1. Implicit & Explicit Transaction
2. Interactive & Batch Modes
3. Semantic Modes

1. BTET
2. ANSI

 

1.  Teradata Storage and Retrieval Architecture

1. Primary Index

1. Hash algorithm
2. Row Hash
3. .DSW
4. Hash Map
5. Hash Bucket
6. Reaching Vdisk

1.  Teradata Indexes

1. Primary Index

1. Unique, Non Unique
2. Partitioned, Range_N, Case_N
3. Multivalued PPI
4.  NOPI ( No Primary Index)
5. Skewness

1. Secondary Index

1. Unique, NonUnique
2. Hash Index, join Index
3. Value Ordered
4. Secondary Index Sub table

Full Table Scan (FTS) - Execution Process

 

 

1.  Teradata sql Reference

1. Conditional Expressions
2. Arithmetic, Logical, Conditional Operators
3. Functions

 

Normal Functions

String functions, Format function

Cast, Group & Aggregate functions

Coalesce, Nullif, Trim, Substr, Position, Length, Chars, etc….

Advanced OLAP Functions

Moving SUM/AVG/DIFF

Cumulative SUM/AVG/DIFF

With By, With, Sum/Avg Over (), Rank (),

 Row_number (), Top, Extract, etc….

1.  Sub Queries, Set Operations & Joins

1. Sub Queries

Simple, Nested & Corelated

1. Set Operations

Union, Union All, Intersect, Except

1. Joins

Cross, Inner, Left, Right and Full joins

1.  Teradata Other Objects

1. Views, Macros
2. Stored Procedures, Triggers
3. Cursors

1.  Join Strategies

1. Product join
2. Merge join
3. Hash join
4. Nested join

 

 

 

1.  Load and  Unload Utilities & Tools

1. Teradata SQL ASSISTANT (Queryman)

Import & Export Data

Teradata BTEQ

1. Features, Command Sets, Modes, Formats
2. Scripts With Fixed, Vartext and Report
3. Branching and Looping
4. Load/Un Load with ETL Operations
5. Exception Handling and examples

Teradata FASTLOAD

1. Features, Phases and Limitations of Fast Load
2. Advantages, Process, Error tables
3. Working with Fixed and Variable text scripts

Teradata MULTILOAD

1. Features, Phases and Limitations of Multi Load
2. Tables and Tasks in Multi Load
3. INSERT/UPDATE/DELETE/UPSERT/RELEASE
4. SCDs Implementation (Type1, Type2)

Teradata TPUMP

1. Features, Limitations, Process of TPump
2. Diff between MLOAD and Tpump
3. SCDs Implementation (Type1,Type2)
4. Real time & Sample Scripts

Teradata FASTEXPORT

1. Features, Limitations and Process
2. Exporting Data to Single, Multiple Tables
3. Passing Parameters (Internal, External)
4. Real Time & Sample Scripts

 

            Course provided by well experienced faculty.

Please contact us at

Phone: 214-501-8177

Email:[email protected]

 

Thanks & Regards

Sravani

9startek,

 (Direct): 214-501-8177