Teradata Online Training And Job Support

[InfPrasad]

[color=#282828][font=helvetica, arial, sans-serif][indent=1]Hi Everybody,[/font][/color][/indent]


[color=#282828][font=helvetica, arial, sans-serif]I am providing [/font][/color][b]Online training[/b][color=#282828][font=helvetica, arial, sans-serif] and [/font][/color][b]job support[/b][color=#282828][font=helvetica, arial, sans-serif] on [/font][/color][b]Teradata[/b][color=#282828][font=helvetica, arial, sans-serif]. It is for [/font][/color][b]Teradata[/b][color=#282828][font=helvetica, arial, sans-serif] developers.[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]If anybody interested please contact me soon. My contact details...........[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]Email:- [/font][/color][b] [email protected][/b]

[color=#282828][font=helvetica, arial, sans-serif]Ph:- [/font][/color][b]+91 929 122 7040, +91 99494 89441.[/b]









[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]Duration:30 Hours[/b][/font][/color][/indent]

[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]Teradata Online training course Content: [/b][/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]Introduction:[/b][/font][/color][/indent][list]
[*]What is Teradata?
[*]Teradatav12 & versions Other versions
[*]Overview OF Teradata
[*]Teradata warehouse
[*]Teradata in the Enterprise
[*]Teradata Users & Scalability
[*]interview Q&A and Certification queries
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]Teradata Architecture and Components[/b][/font][/color][/indent][list]
[*]Teradata Architecture
[*]SMP Architecture
[*]MPP Architecture
[*]AMP(Access Module Processing)
[*]TDP(Teradata Directory Program)
[*]CLI(Call Level Interface)
[*]TPA(Trusted Parallel Application)
[*]Parallelism Architecture
[*]Benefits and Types
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]Data Recovery and Security[/b][/font][/color][/indent][list]
[*]Why for locks &how to release
[*]Various locks for simultaneous access
[*]RAID 1&RAID 5
[*]Disk Arrays
[*]Fall Back
[*]Clique
[*]AMP Clustering
[*]Types OF Journals
[*]Recovery Journal
[*]Trasient Journal
[*]Permanent Journal
[*]Before Journal
[*]After Journal
[*]How & where is used journals
[*]Answering various recovery questions
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]Teradata Indexes[/b][/font][/color][/indent][list]
[*]Primary Index
[*]Unique
[*]Non unique
[*]Partitioned
[*]Secondary Index
[*]Unique
[*]NonUnique
[*]Hash, Join, Value Ordered
[*]Skewness
[*]Secondary Index Sub table
[*]Accessing Records via Primary Index
[*]Accessing records via Secondary Index
[*]Keys Vs Indexes
[*]Full Real time scenarios and explaining
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]Teradata Sql Reference[/b][/font][/color][/indent][list]
[*]SQL Fundamentals
[*]Data Types and Literals
[*]Data Definition Statements(DDL)
[*]Data Manipulation Statements(DML)
[*]Explaining with proper examples
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]Teradata Functions and Operators[/b][/font][/color][/indent][list]
[*]String Functions
[*]Format Function
[*]Cast Functions
[*]Group & Aggregate Functions
[*]With & with by clauses
[*]Practices of this section
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]Teradata Transactions[/b][/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]Implicit Transaction[/b][/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]Explicit Transaction[/b][/font][/color][/indent][list]
[*]Performance Tuning and Explain Utility
[*]Explain Usage
[*]Collecting Statistics
[*]Tuning SQL Performance
[*]Usage of PMON
[*]Explaining various SQL statements
[*]Joins and Unions
[*]Inner Join
[*]Left Outer Join
[*]Right Outer Join
[*]Full Outer Join
[*]Detailed explanation
[*]Join Strategies
[*]Product Join
[*]Merge Join
[*]Hash Join
[*]Nested Join
[*]Questions of this section
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]Teradata Basic Commands[/b][/font][/color][/indent][list]
[*]HELP
[*]SHOW
[*]EXPLAIN
[*]COLLECT STATISTICS
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]Teradata Objects[/b][/font][/color][/indent][list]
[*]Tables
[*]SET table
[*]Multi Set table
[*]Volatile tables
[*]Global Temporary tables
[*]Derived tables
[*]Views
[*]Macros
[*]Stored Procedures
[*]Triggers
[*]Practices and FAQs of this session
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]Teradata spaces[/b][/font][/color][/indent][list]
[*]PERM space
[*]SPOOL space
[*]TEMPORARY space
[*]Teradata User and managing
[*]Practical Examples
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]Teradata Transaction Modes[/b][/font][/color][/indent][list]
[*]BTET
[*]ANSI
[*]Interactive
[*]Batch
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]Teradata performance tuning on SQL Assistance[/b][/font][/color][/indent][list]
[*]Usage of PMON
[*]Explain usage
[*]Collecting statistics
[*]SQL tuning
[*]Various SQL statements
[*]Real time Issues & resolving
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]Teradata Utilities & Tools (Import & Export)[/b][/font][/color][/indent][list]
[*][b]Teradata BTeq scripts[/b]
[list]
[*]Overview of BTeq
[*]Looping stages
[*]Batches scripts
[*]Import &export scripts with Examples
[*]Error handling
[*]Real time scripts
[/list][*][b]Teradata FastLoad[/b]
[*]Types of phages & how to find it
[*]Advantages & its process
[*]Limitations of fast load
[*]Real time scripts
[*]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
[*]Overview of Tpump
[*]Limitations of Tpump
[*]Work on Multi tables
[*]Sample scripts
[*]Real time scripts
[*][b]Teradata MultiLoad[/b]
[*][b]Teradata Tpump[/b]
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]Teradata Fast Export[/b][/font][/color][/indent][list]
[*]How to export the data
[list]
[*]Passing parameters
[*]IN/OUT Modes
[*]Work on Multi tables
[*]Real time scripts
[list]
[*]Sample scripts
[/list]
[/list][*]Teradata SQL Assistant(Quarryman)
[*]Teradata performance monitor
[*]Teradata Administrator usage
[*]Teradata performance tuning on scripts
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]Other Features:[/b][/font][/color][/indent][list]
[*]FAQS
[*]Covering DBA concepts
[/list]