TERADATA
What is Teradata why for it is what for it is
What is Teradata?
Teradatav13 &versions
Teradata History
Teradata users scalability
Teradata &other RDBMS
Teradata warehouse
Teradata in the Enterprise
Interview Q&A and Certification queries
Real time Issues & resolving

Teradata architecture & it’s 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
Bynet 0 &Bynet 1
Parallism Architecture

Recovery & Protection of Data
What is fall back &where it used
Why for fall back
What is Clique
AMP Clustering
Locks & types for simultaneous Access
Why for locks &how to release
RAID 1 &RAID 5
Journals &types
Virtual Disk Array
How & where is used journals
Q & A about data recovery

Teradata indexes
Types of indexes in Teradata
Hash index
Join index
Primary index(unique, non- unique)
Secondary index(unique, non- unique)
Skewness
Keys & indexes (How & why these used)

How to storage & retrieval of data
Hash algorithm
Row hash
Hash map
Hash bucket
Receiving VDisc

Teradata SQL Quarryman
SQL fundamentals
Data types and literals
DDL Statements
DML Statements
Teradata naming conversing

Teradata SQL Functions & operations
String functions
Format functions
Cast functions
Cast functions
Group & Aggregation functions
Logical operations
Arithmetic operations
set operations
join operations
conditional expressions

Teradata join strategies & unions
hash join
merge join
nested join
product join
inner join
left & right outer join
full outer join

Teradata basic commands
Help
Show
Explain
Collect statistics

Teradata objects
Types of tables
•Set tables
•Multi tables
•Volatile tables
o Global temporary tables
o Derived tables
Views
Macros
Stored procedures
Triggers


Teradata memory spaces
Permanent spaces
Temporary spaces
Spool spaces
Users spaces & PWD

Teradata transaction modes
Batch mode
BTET mode
ANSI mode
How Converted into others

Teradata performance tuning on SQL Assistance
Usage of PMON
Explain usage
Collecting statistics
SQL tuning
Various SQL statements
Real time Issues & resolving

Teradata Utilities & Tools (Import & Export)
Teradata BTeq scripts
•Overview of BTeq
•Looping stages
•Batches scripts
•Import &export scripts with Examples
•Error handling
•Real time scripts

Teradata FastLoad
•Types of phages & how to find it
•Advantages & its process
•Limitations of fast load
•Real time scripts
Teradata MultiLoad
o Overview of Multi load
•Types of phages in MultiLoad
•Advantages & its process
•Limitations of MultiLoad
•Uses various types of operations
o Work on Multi tables
•Real time scripts
o Sample scripts

Teradata Tpump
•Overview of Tpump
•Limitations of Tpump
•Work on Multi tables
•Real time scripts
o Sample scripts

Teradata Fast Export
•How to export the data
o Passing parameters
o IN/OUT Modes
o Work on Multi tables
•Real time scripts
o Sample scripts

Teradata SQL Assistant(Quarryman)
Teradata performance monitor
Teradata Administrator usage
Teradata performance tuning on scripts

Keyservice by Trainer
FAQS
Covering DBA concepts
Concentration on performance tuning
Real time scenarios
Certification guidance
Resume preparation
Sample resumes
Interview & certification FAQS
How to face the interview
Class notes which is useful for who is trying for job
Project preparation


Courses Offerings

• Android
• AIX Administration
• Business Analyst
• CCNA, CCNP Security
• Citrix XenApp
• Cognos 10 BI & Tm1
• Crystal Reports
• Data Stage
• DB2 DBA
• Dot Net
• DAC
• Google Web Tool Kit
• IBM Lotus Notes (Development)
• IBM Lotus Notes Domino Server Administration
• IBM Message Broker
• IBM MQ Series
• IBM Tivoli Access Manager
• IBM Web Sphere Application Server Administration (WAS)
• IBM WAS Portal server Development
• IBM Websphere Transformation extender (WTX 8.2)
• Informatica
• I Phone
• Java/J2EE
• J Query
• MicroSoft .NET Technologies (VB.NET, C#, ASP.NET)
• Microstrategy
• MicroSoft Business Intelligence
• MicroSoft Dynamics CRM
• OBIEE 11 g
• Oracle APPS – HRMS
• Oracle APPS – SCM
• Oracle APPS – Financial
• Oracle APPS – Technical
• Oracle BI Apps
• Oracle BI Publisher
• Oracle DBA 11g
• Oracle RAC
• Oracle Fusion SOA
• Oracle SQL , PL SQL
• PHP
• Perl Scripting
• SAP SD , BO , FICO , BI / BW , APO , BPC
• Sales Force CRM
• SharePoint Server 2010
• Shell Scripting
• Siebel CRM , EAI, E-Scripting
• SQL Server DBA
• Springs and Hibernate
• Storage Area Network ( SAN)
• Tera Data
• Testing Tools - QTP, QC, Load Runner, Selenium, ISTQB
• TIBCO BW, BE, TIBCO I Process
• Tivoli Access Manager
• Unix Administration
• VN Ware
• WCF, WPF, LINQ, AJAX, SILVER LIGHT
• Webmethods
• Webservices , SOAP ( JAVA)



Drop a mail info@futurepointtech.com we will get in touch with u

olaideabbas33@gmail.com

Tonixdigital@gmail.com