This listing was updated more than 3 months ago. It might contain outdated information.
Teradata Development online training by pradhika technology
Hyde Park
6 years, 1 month
Sorry, but there is no uploaded picture or video for this ad. You can request one from this user.
Ad ID:ADOIST-2042767
Category:Classes
Subcategory:Computer, Multimedia classes
Description
Introduction: • 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
Data Recovery and Security • 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
Teradata Indexes • 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
Teradata Sql Reference • SQL Fundamentals • Data Types and Literals • Data Definition Statements(DDL) • Data Manipulation Statements(DML) • Explaining with proper examples
Teradata Functions and Operators • String Functions • Format Function • Cast Functions • Group & Aggregate Functions • With & with by clauses • Practices of this section
Teradata Transactions
Implicit Transaction
Explicit Transaction • 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
Teradata Basic Commands • HELP • SHOW • EXPLAIN • COLLECT STATISTICS
Teradata Objects • Tables • SET table • Multi Set table • Volatile tables • Global Temporary tables • Derived tables • Views • Macros • Stored Procedures • Triggers • Practices and FAQs of this session
Teradata spaces • PERM space • SPOOL space • TEMPORARY space • Teradata User and managing • Practical Examples
Teradata Sql Assistant (Queryman) • Teradata Performance Monitor • Teradata BTEQ • Batch Scripts with samples • Branching and Looping • Importing data through scripts • Exporting data through scripts • Error handling • Explanation with proper debugging • Teradata Fast Load • Various Phases of Fast Load • Advantages and Process • Limitations of Fast Load • Sample Scripts
Real time Issues and resolving it • Teradata Multi Load • Various Phases of Multi Load • Limitations of Multi Load • Working with multiple tables • Applying various operations • Sample Scripts
Real time Issues and solving it • Teradata Parallel Data Pump • Limitations of TPump • Overview of TPump • Sample Scripts • Teradata Fast Export • Exporting Data • Passing Parameters • OUTMODS • Sample Scripts • Utility Vs Parallelism Our Courses WebSphere SAP Oracle Java Microsoft Tibco PROFESSIONAL COURSES Address Rakesh Kumar +91 9700330693 +1 234 200 0813 info@pradhikatechnology.com pradhikatechnology@gmail.com
Audience: o Functional Owner, Administrators and Implementers o Any Programmers o DataBase developers/administrators o Testing professionals o Enterprise Resource Planning professionals o Customer Relationship Management professionals o Business Inte...