admin@onlinetrainings9.com

IND No.+91-9036298699
  • Home
  • About
  • Courses
  • Instructors
  • Payment
  • Contact Us

TERADATA

TERADATA

DESCRIPTION

Course Content

1.Intoduction
What is DWH and Applications
Role of Teradata In DWH
Advantages of Terada over other RDBMS
Evolution of Teradata
2.RDBMS Concepts
TD Instalation
RDBMS Concepts
3.Architecture
Hardware components
Node Architecture(Shared Architecture)
SMP Architecture
MPP Architecture
Parsing engine(PE) Architecture
AMP Architecture &uses
Bynet Benefits &types
Parallel data extension(PDE)
Teradata directory program(TDP)
Call level interface(CLI)
Trusted parallel application(TPA)
Virtual processors
Parallism Architecture
Perm,spool,temp spaces
4.TERADATA INDEXES
Types of indexes in Teradata
Primary indexes(unique, non- unique, NO PI)
Secondary indexes(unique, non- unique)
Partition Primary Indexes
Join indexes
Skew factor
5.Data protection
Fallback
Clique
Cluster
Journals
Locks
Raid
6.Teradata SQL
Teradata Objects
Teradata Extensions
Operators and expressions
Functions
SET operators
Datatype conversions
7.Advanced SQL
Ranking
Qualify
Case
Coalesce
8.Utilities
Sql Assistant
Bteq
Fastload
Fast Export
Multi load
TPT
9.Database Adminstration
Space mangement
User management
Roles/accessrights management
Profiles management
Quering DBC tables
10.Performance monitoring
Tdmanager
Pmon
11.Tools
Teradata Adminstrator
stats wizard
Index wizard
DBQL
12.Backup/Restore
Arcmain
Backups
Restores
Copy
13.Performace Tuning
Explain
Stats
Troubleshooting

     Register this course
  • Paypal:  rajani.kotapati9@gmail.com
  • riamoneytransfer.com
  • remitly.com
  • Duration:  7Weeks
  • Type:  Online Training
  • Languages: English
  • Video : English
TERADATA

About

Online Trainnings9 is based at India and serves to global customers for IT Training and Consulting Services. Online Trainnings9having the trainer pool to deliver training programs with cutting edge techniques and methodology that provides people with right skills and knowledge to help them achieve their career goals.

Hot Links

  • About Us
  • Courses
  • Instructers
  • Payment
  • Contact Us

Contact

phone
IND NO.+91 90 3629 8699
USA NO.+1 7576099623
email
info@onlinetrainings9.com
Skype id
onlinetrainings9

Payment

    Thanks for your interest to register for a course with us, we ensure you to get the best service for the same. You can pay your course fee with the following options,

     
  •  Paypal  rajani.kotapati9@gmail.com
  •  riamoneytransfer.com
  •  www.remitly.com

Copyright © 2016 Onlinetrainings | All Right Reserved | Privacy Policy | Terms of Use

Designed & Developed By