IT Training /Certification /Consulting - Bangalore

Growmind Solutions

TERADATA
Teradata - Database engine optimized
for Datawarehousing (for reading,
not for inserting). Used for huge
data warehouses (Fortune 100
companies, for example, major airlines).

Benefits
• Scenario Based and Real Time Oriented Training
• Certification Guidance to Clear your Certifications
• Customized Course for every students For Oracle SQL / PL-SQL Training in BANGALORE
• On-Job Support after getting Placed in any Company.
• We have the Best Oracle Sql, Pl/Sql Trainers in Chennai, Who have more than 10+ years of experience.
• Our teaching style is completely hands-on Industry oriented.

TERADATA COURSE CONTENT:

• What Is Teradata Why for It Is What For It Is
? What is Teradata?
? Teradatav12 & versions
? Teradata History
? Teradata users scalability
? Teradata &other RDBMS
? Teradata warehouse
? Teradata in the Enterprise
? Interview Q&A and Certification queries
• 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
• Recovery ? otection Of Data
? What is fall back &where it used
? Why for fall back
? What is Clique
? AMP Clustering & 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
? 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 Objects?? Types of tables
? Set tables
? Multi tables
? Volatile tables
? Global temporary tables
? 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
? Overview of Multi load
? Types of phages in MultiLoad
? Advantages & its process
? Limitations of MultiLoad
? Uses various types of operations
? Work on Multi tables
? Real time scripts
? Sample scripts
? Teradata Tpump
? Overview of Tpump
? Limitations of Tpump
? Work on Multi tables
? Real time scripts
? Sample scripts
? Teradata Fast Export
? How to export the data
? Passing parameters
? IN/OUT Modes
? Work on Multi tables
? Real time scripts
? Sample scripts
? Teradata SQL Assistant(Quarryman)

For more details contact us
Information Helpdesk
918884851579 / +918026542131
www.growmind.co.in / www.facebook.com/growmind
Authorized training and certification center from 'EC-Council', USA
Autorirized training and certification center from 'Peoplecert' USA