Tera Data Online Training and Placement @ Crescent IT Solutions

1

• Crescent IT Solutions
• Visit http//www.crescentits.com
• Call Us [phone]-5479/2879, 704-248-2649

2
Tera Data Online Training and Placement _at_
Crescent IT Solutions

• Tera Data - Course Content
• Teradata Architecture and Components
• PDE(Parallel Data Extension)
• Vprocs (virtual processors)
• PE (Parsing Engine)
• 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
• Visit http//www.crescentits
  .com

3
Tera Data Online Training and Placement _at_
Crescent IT Solutions

• Tera Data - Course Content
• Various Architecture
• Node Architecture (shared nothing)
• SMP Architecture
• MPP Architecture
• Parallelism Architecture
• Benefit types
• Visit http//www.crescentits
  .com

4
Tera Data Online Training and Placement _at_
Crescent IT Solutions

• Tera Data - Course Content
• Data Recovery and Protection
• Object Locks-Various locks for simultaneous
  access
• RAIDI
• RAIDI5
• Disk Arrays
• Fall Back
• Clique
• AMP Clustering
• Journals
• Visit http//www.crescentits
  .com

5
Tera Data Online Training and Placement _at_
Crescent IT Solutions

• Tera Data - Course Content
• Teradata Storage and Retrieval Architecture
• Request processing
• a. Syntaxer
• b. Resolver
• c. Security Module
• d. Optimizer
• e.Step Generator
• f. GNC Apply
• g. Dispatcher
• Visit http//www.crescentits
  .com

6
Tera Data Online Training and Placement _at_
Crescent IT Solutions

• Tera Data - Course Content
• Primary index
• 1.Hash algorithm
• 2. Row hash
• 3. DSW
• 4. Hash Map
• 5. Hash Bucket
• 6. Reaching Vdisk
• Visit http//www.crescentits
  .com

7
Tera Data Online Training and Placement _at_
Crescent IT Solutions

• Tera Data - Course Content
• Teradata Indexes
• Primary Index
• Unique
• Non unique
• Partitioned
• Secondary Index
• Unique
• Non unique
• Hash, Join, Value Ordered
• Skewness
• Secondary Index Sub table
• Accessing Records via primary index
• Accessing records via Secondary index
• Keys vs indexes

8
Tera Data Online Training and Placement _at_
Crescent IT Solutions

• Tera Data - Course Content
• Teradata Sql Reference
• Fundamentals
• Data Types and Literals
• Data Definition Statements
• Data manipulation statements
• Visit http//www.crescentits
  .com

9
Tera Data Online Training and Placement _at_
Crescent IT Solutions

• Tera Data - Course Content
• Teradata Functions and Operators
• String functions
• Format functions
• Cast functions
• Group Aggregate functions
• With with by clauses
• Visit http//www.crescentits
  .com

10
Tera Data Online Training and Placement _at_
Crescent IT Solutions

• Tera Data - Course Content
• Teradata Transactions
• Implicit Transaction
• Explicit Transaction
• Performance Tuning and Explain Utility
• Explain Usage
• Collection Statistics
• Tuning SQL Performance
• Usage of PMON
• Visit http//www.crescentits
  .com

11
Tera Data Online Training and Placement _at_
Crescent IT Solutions

• Tera Data - Course Content
• Joints Unions
• Inner Join
• Left Outer Join
• Right Outer join
• Full Outer Join
• Teradata Basic Commands
• HELP
• SHOW
• EXPLAIN
• COLLECT STATISTICS
• Visit http//www.crescentits
  .com

12
Tera Data Online Training and Placement _at_
Crescent IT Solutions

• Tera Data - Course Content
• Teradata objects
• Tables
• 1. SET table
• 2. Multi Set table
• 3. Volatile tables
• 4. Global Temporary tables
• 5. Derived tables
• Views
• Macros
• Stored procedures
• Triggers
• Visit http//www.crescentits
  .com

13
Tera Data Online Training and Placement _at_
Crescent IT Solutions

• Tera Data - Course Content
• Teradata spaces
• PERM space
• SPOOL space
• TEMPORARY space
• Teradata user and managing.
• Teradata Transaction Modes
• BTET
• ANSI
• Interactive
• Batch
• Visit http//www.crescentits
  .com

14
Tera Data Online Training and Placement _at_
Crescent IT Solutions

• Tera Data - Course Content
• Load and Unload Utilities Tools
• Teradata Sql Assistant (Queryman)
• Teradata Performance Monitor
• Teradata BTEQ
• a. Batch Scripts with samples
• b. Branching and Looping
• c. Importing data through scripts
• d. Exporting data through scripts
• e. Session Control Command Set
• f. Error handling.
• Visit http//www.crescentits
  .com

15
Tera Data Online Training and Placement _at_
Crescent IT Solutions

• Tera Data - Course Content
• Load and Unload Utilities Tools
• Teradata Sql Assistant (Queryman)
• Teradata Performance Monitor
• Teradata BTEQ
• a. Batch Scripts with samples
• b. Branching and Looping
• c. Importing data through scripts
• d. Exporting data through scripts
• e. Session Control Command Set
• f. Error handling.
• Visit http//www.crescentits
  .com

16
Tera Data Online Training and Placement _at_
Crescent IT Solutions

• Tera Data - Course Content
• Load and Unload Utilities Tools
• Teradata Fast load
• a. Various Phases of Fast Load
• b. Advantages and Process
• c. Limitations of Fast Load
• d. Sample scripts
• Teradata Multi Load
• a. Various Phases of Multi load
• b. Limitations of Multi Load
• c. Working with multiple tables
• d. Applying various operations
• e. Sample Scripts
• Visit http//www.crescentits
  .com

17
Contact Us

• Crescent IT Solutions
• Address 10919 west road, apt 518 Houston, Tx
  77064
• Phone No [phone]-2649/713-589-2879/713-589-54
  79
• Toll Free 1-800-929-0849
• eMail training_at_crescentits.com
• Visit http//www.crescentits.com