The Leader In IT Training & Project Support Solutions

Introduction

Teradata is one of the most emerging technologies in market. As more and more organization are moving their data warehouse in Teradata database, so the demand of Teradata Professionals are high. People who are interested in learning the basics and advance features of Teradata Development can benefit from this training.

 Teradata Course Content:

1.Teradata Warehouse and competitiveness

  • Opportunities of Teradata in the enterprise.
  • What is Teradata-rdbms/DWH?
  • Teradata 13.10 & Other versions(12,v2r7,v2r6).
  • Teradata History and Realtime running versions.
  • Teradata competitiveness with other RDBMS . Diff between them.
  • Teradata Warehouse and Usability.

2.Teradata single and Multi system Architectures

  • Node Architecture
  • SMP Architecture
  • MPP Architecture
  • Discussion on AMPS and NODES

3.Teradata Components and Explanation

  • VPROCS
  • BYNETS

4.Teradata Pratical(DBA Related concepts)

  • Teradata server starting/stopping
  • Working with Teradata sql Assistant and BTEQ
  • Creating Database and Manipulation
  • Creating User and Manipulation
  • Managing Databases and users
  • Data Dictionary and Views
  • Working with Teradata Administration Tool

5.Memory Management Spaces

6.Teradata SQL

  • Stored Procedure Language
  • Teradata Extensions(HELP,SHOW,EXPLAIN,COLLECT STATISTICS)

7.Data Definition Language

  • Creating Table
  • Types of tables
  • Altering and Modifying Tables
  • Dropping

8.DML

9.DCL

10.Locks, Data Recovery and Protection

11.Other Components of table

  • Datatypes (ANSI,Teradata)
  • Column Storage Attributes
  • Constraints

12.Teradata Transactions

13.Teradata Storage and Retrival Architecture

14.Teradata Indexes

  • Primary Index
  • Secondary Index

15.Teradata SQL References

  • Condition Expressions
  • Arithmetic, Logical, Conditional Operators
  • Normal Functions
  • Advanced OLAP Functions

16.Sub Queries, Set Operations, Joins

17.Teradata Other Objects

  • Views
  • Macros
  • Triggers
  • Cursors

18.Join Strategies

19.Performance Tunning and Explain utility

  • Explain request Modifier
  • Collect Statics,Confidence Levels
  • Tunning SQL Queries and Utilities
  • Usage of PMON, Index & Statistics Wizards
  • Various Indexes
  • Skew factor, Skewness, Remeddies Spool Space Issues

20.Load and Unload Utilities(20 hrs)

  • Teradata SQL Assistant(SQLA)
  • Teradata BTEQ
  • Teradata FASTLOAD
  • Teradata MULTILOAD
  • Teradata FASTEXPORT
  • Teradata TPUMP

Course Reviews

No Reviews found for this course.

Drop us a query

Looking for a training for

 Myself My team/organization

captcha

 I agree to be contacted over email

top
Copyright © 2015 KEEN IT TECHNOLOGIES Pvt.Ltd, ALL RIGHTS RESERVED  |   PRIVACY POLICY   |   TERMS OF USE   |   REFUND AND RESCHEDULE POLICIES   |   SITEMAP  
Keen IT is not an affiliate of SAP AG or other products.