|  
Home | About Us | Sitemap | Contact Us
 
       
Services
Portfolio
Product
Development
Training
Clientele
 
Training | Course: Teradata
Sub Course: Teradata
 
Teradata Overview & Basic
 1. Overview
         *  What is Teradata ?
         *  Teradata – A Brief History
         *  How Large is a Trillion ?
         *  Evolution of Data Processing
         *  What is a Data Warehouse ?
         *  What is Active Data Warehousing ?
         *  Teradata Database Competitive Advantages
         *  Teradata Database Manageability
 2. Relational Concepts
         *  What is a Database ?
         *  Relational Databases
         *  Primary Key
         *  Foreign Key
         *  Advantages of a Relational Database Approach
 3. Teradata Basics
         *  Teradata Storage Architecture
         *  Teradata Retrieval Architecture
         *  Multiple Tables on Multiple AMPs
         *  Linear Growth and Expandability
         *  Teradata Objects
         *  The Data Dictionary Directory (DD/D)
         *  Structure Query Language (SQL)
         *  CREATE TABLE – Example of DDL
         *  Views & Multi-Table Views
         *  SELECT – Example of DML
         *  The JOIN Operation
         *  Macros
         *  HELP Commands
         *  SHOW Command
         *  EXPLAIN Facility
         *  Teradata Features Review
 
 
Teradata Architecture
 4. Teradata Database Architecture
         *  Teradata and MPP Systems
         *  Teradata Functional Overview
         *  Channel-Attached Client Software Overview
         *  Network-Attached Client Software Overview
         *  The Parsing Engine
         *  Message Passing Layer
         *  The Access Module Processor (AMP)
         *  Teradata Parallelism
 5. Teradata System Architecture
         *  Teradata Database Version 1 Platforms
         *  Teradata Database Version 2 Architecture
         *  Teradata Database Version 2 Single Node (SMP)
         *  Multi-Node MPP System
         *  Teradata Cliques
         *  BYNET (for MPP)
         *  BYNET Communication Protocols
         *  Vproc Inter-process Communication
         *  Examples of Teradata Database Version 2 Systems
         *  What makes NCR’s MPP Platforms Special ?
         *  NCR Rack-Based Cabinets
 6. Creating a Teradata Database
 7. Primary Index Access
 8. Primary Index Mechanics
 9. Secondary Indexes and Table Scans
 10. Data Protection & RAID Technologies
 11. Data Distribution, Hashing, and Index Access
 12. Sizing
 13. Optimizer and Collecting Statistics
 14. The EXPLAIN Facility
 15. Join Processing Analysis
 16. Explains of Joins and Index Choices
 
 
Application Utilities
 17. Introduction to Application Utilities
         *  Application Utilities & Environments
         *  Application Development
         *  Transferring Large Amounts of Data
         *  INSERT/SELECT: The Fast Path
         *  Multi-Statement Insert/Select Example
         *  DELETE (ALL): The Fast Path
         *  Using an INMOD Routine
         *  Teradata Parallel Transporter
         *  Teradata Parallel Transporter Operators
         *  Referential Integrity and Load Utility Issues
         *  Application Utility Checklist
         *  Application Utility Summary
         *  Review Questions
 18. BTEQ
 19. FastLoad
 20. FastExport
 21. MultiLoad Part 1
 22. MultiLoad Part 2
 23. TPump
 24. Choosing a Utility
 25. The Support Environment
 
 
       
Our Services
Product Expertise
Industry Focus
Corporate Training
Software Development
Web Designing
Search Engine Optimizatior
Corporate Training
Web Hosting
E-Commerce Application
Inventory Management System
Online Test System
HR and Payroll System
Jewellery Management System
   
Banking & Insurance
Education
E-Commerce
Accounting & Finance
Real Estate
Visual Studio 2008/2010
Oracle Database
Teradata Database
Dataware Housing - Informatica
Testing
Copyrights © 2010. 7HillTop Technologies. All Rights Reserved.
Feedback Career Marketing Technology