TeraData

$ 13

Browse Wishlist
Category:
Description

Description

TERADATA COURSE CONTENT

  1. Teradata Introduction
  • Teradata Introduction
  • Teradata Advantages
  • Teradata Installation
  • Teradata Tools & Utilities Installation
  1. Teradata Architecture
  • Teradata Components
  • Storage & Retrieval architecture
  • System architecture
  • How parallelism works
  1. Basic SQL
  • Data types
  • DDL statements(CREATE, DROP, ALTER)
  • DML statements(SELECT, INSERT, UPDATE, DELETE)
  • SET Operators
  • Logical & Conditional Operators
  • String Manipulation
  • Date & Time Manipulation
  • Joins
  • Build-in functions
  • Aggregates
  1. Indexes
  • Primary Index
  • Secondary Index
  • Partition Primary Index
  1. Teradata Objects
  • SET vs MULTISET tables
  • Derived/Volatile/Global Temporary
  • Views
  • Macros
  • Stored Procedures
  • Join Index
  • Space concepts
  1. Advanced SQL
  • Subqueries
  • Coalesce
  • OLAP Functions
  • Compression
  • DBC tables
  • Explain plan
  • Transaction Models
  1. Utilities
  • Fast Load
  • Multi Load
  • BTEQ
  • Fast Export
  • TPT
  1. Data Protection
  • Fallback
  • Clusters
  • Clique
  • Permanent Journals
  • Hot Standby Nodes
  • RAID
  1. Performance Optimization
  • Join Strategies
  • Confidence Levels
  • Statistics collection process
  • Performance tuning techniques
Contact Us