info@ascendinfosolutions.com
732- 645-7910
Home
About Us
Who we are
Values
Why Ascend Info Solutions
Services
Corporate training
One to one training
Training & Placement
Project Guidance
Courses
SAP TECHNICAL
SAP - FUNCTIONAL
ORACLE ERP
PEOPLESOFT ERP
DATAWAREHOUSING TOOLS
MICROSOFT TECHNOLOGIES
JAVA TECHNOLOGIES
TESTING TOOLS
OTHER TECHNOLOGIES
Payments
Job Search
Job search
Contact Us
Testimonials
Enquiry
Contact Us
Course Contents
TERADATA SYLLABUS
Data Warehousing Concepts
About Data Warehouse & warehousing
Active Warehouse & passive Warehouse
Data warehouse using Evaluation
OLTP, DSS,OLTP,&OLCP
SDLC(DWD Life Cycle)
Schema Types
Characteristics' Of Dimension &Fact Tables
ETL Process & cleaning
ER & dimentional Model Overview
Introduction to TERADATA
UInique Features of Teradata
Teradata System
Node component
SMP & MPP
BYNET Hardware &SoftWare
Communication between Nodes
Teradata Maximums
TERADATA Architecture
Architecture Flow
Shared Nothing Acrhitecture
PE with Explain
Visual Data Layout
Primary Index
Purpose of Primary Index
Non unique Primary Index
unique Primary Index
Secondary Index
Purpose of the Secondary Index
Unique Secondary Index
Non Unique Secondary Index
Teradata SQl
SQL Basics
Teradata Punctuation
HELP,show,Explain
Working With Nulls
And ,OR,Not, Between & like
Aggregation
Subqueries & Co-related Sub Queries
Aliasing,Title,cast &format
Interrrogating Data
Types of Tables
Set and Multiset Tables
Volatile Tables
Derived Tables
Global Tempory Tables
Teradata Spaces
Perm Space
Spool Space
Term Space
Performance Tunning with Space
Joins
Join Types
Join strategies
Join Index
Agg join index
Set Operators
Union/Union all
Intersect
Except or minus
Views
Purpose Of view
Create View Syntax
Usage
Macros
Purpose of Macros
Create Macro Syntax
Data and Times
Teradata Key words
Storage of dates on Disk
DateForm
ADD_Months Command
Extract Command
System Calender
System Calendar with Date Comparision
Intervel Processing with Date And Time
Rank Function and Qualify Usage
Rank Functions
Qualify Usage
Rank with OLAP functions
OLAP Function
CSUM
MSUM
MAVG
Teradata Utilites
MLOAD
FLOAD
FAST EXPORT
BTEQ
TERADATA OLELOAD
TERADAT PARLLAL TRANSPOSER
TPUMP
Locks
Exclusive
Write
Read
Access
Protection Features
Fallback
Raid
Clique
Stores Procedure
Performance Tunning
Note: Duration of the course is 30h of one hour each.
BO-XI R3
INFORMATICA
DATASTAGE
COGNOS
COGNOS-TM1
ABINITIO
PEGA
MICROSTRATEGY
SAS-ANALYTICS
SAS-BI
SAS-FINANCE
MS-BI
TERADATA DBA
TERADATA DEVELOPER
RUBY ON RAILS
QLIKVIEW
MAXIMO