Jump to content

Dot Net And Teradata


InfPrasad

Recommended Posts

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]

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...