Dot Net And Teradata

[InfPrasad]

Hi All,

We are providing [b]Online Training[/b] and [b]Job Support[/b] on [b]Dot Net and Teradata.[/b]

If anybody interested in any of these technologies please contact me soon.

You can reach me at --------> [b][email protected][/b]


Course Content:-

[indent=1][b]Teradata Online training course Content: [/b][/indent]
[indent=1][b]Introduction:[/b][/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]
[indent=1][b]Teradata Architecture and Components[/b][/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]
[indent=1][b]Data Recovery and Security[/b][/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]
[indent=1][b]Teradata Indexes [/b][/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]
[indent=1][b]Teradata Sql Reference[/b][/indent][list]
[*]SQL Fundamentals
[*]Data Types and Literals
[*]Data Definition Statements(DDL)
[*]Data Manipulation Statements(DML)
[*]Explaining with proper examples
[/list]
[indent=1][b]Teradata Functions and Operators[/b][/indent][list]
[*]String Functions
[*]Format Function
[*]Cast Functions
[*]Group & Aggregate Functions
[*]With & with by clauses
[*]Practices of this section
[/list]
[indent=1][b]Teradata Transactions[/b][/indent]
[indent=1][b]Implicit Transaction[/b][/indent]
[indent=1][b]Explicit Transaction[/b][/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]
[indent=1][b]Teradata Basic Commands[/b][/indent][list]
[*]HELP
[*]SHOW
[*]EXPLAIN
[*]COLLECT STATISTICS
[/list]
[indent=1][b]Teradata Objects[/b][/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]
[indent=1][b]Teradata spaces[/b][/indent][list]
[*]PERM space
[*]SPOOL space
[*]TEMPORARY space
[*]Teradata User and managing
[*]Practical Examples
[/list]
[indent=1][b]Teradata Transaction Modes[/b][/indent][list]
[*]BTET
[*]ANSI
[*]Interactive
[*]Batch
[/list]
[indent=1][b]Teradata performance tuning on SQL Assistance[/b][/indent][list]
[*]Usage of PMON
[*]Explain usage
[*]Collecting statistics
[*]SQL tuning
[*]Various SQL statements
[*]Real time Issues & resolving
[/list]


[indent=1][b]Teradata Utilities & Tools (Import & Export)[/b][/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]
[/list][list]
[*][b]Teradata FastLoad[/b]
[list]
[*]Types of phages & how to find it
[*]Advantages & its process
[*]Limitations of fast load
[*]Real time scripts
[/list]
[/list][list]
[*][b]Teradata MultiLoad[/b]
[list]
[*]Overview of Multi load
[*]Types of phages in MultiLoad
[*]Advantages & its process
[*]Limitations of MultiLoad
[*]Uses various types of operations
[list]
[*]Work on Multi tables
[*]Real time scripts
[list]
[*]Sample scripts
[/list]
[/list]
[/list]
[/list][list]
[*][b]Teradata Tpump[/b]
[list]
[*]Overview of Tpump
[*]Limitations of Tpump
[*]Work on Multi tables
[*]Real time scripts
[list]
[*]Sample scripts
[/list]
[/list]
[/list]
[indent=1] [b]Teradata Fast Export[/b][/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]
[/list][list]
[*]Teradata SQL Assistant(Quarryman)
[*]Teradata performance monitor
[*]Teradata Administrator usage
[*]Teradata performance tuning on scripts
[/list]
[indent=1][b]Other Features:[/b][/indent][list]
[*]FAQS
[*]Covering DBA concepts
[/list]


[b]Thanks & Regards,[/b]
[b]Durgaprasad.[/b]
[b]+91 929 122 7040.[/b]
[b]+[/b][b]91 99494 89441.[/b]