Description
TERADATA COURSE CONTENT
- Teradata Introduction
- Teradata Introduction
- Teradata Advantages
- Teradata Installation
- Teradata Tools & Utilities Installation
- Teradata Architecture
- Teradata Components
- Storage & Retrieval architecture
- System architecture
- How parallelism works
- 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
- Indexes
- Primary Index
- Secondary Index
- Partition Primary Index
- Teradata Objects
- SET vs MULTISET tables
- Derived/Volatile/Global Temporary
- Views
- Macros
- Stored Procedures
- Join Index
- Space concepts
- Advanced SQL
- Subqueries
- Coalesce
- OLAP Functions
- Compression
- DBC tables
- Explain plan
- Transaction Models
- Utilities
- Fast Load
- Multi Load
- BTEQ
- Fast Export
- TPT
- Data Protection
- Fallback
- Clusters
- Clique
- Permanent Journals
- Hot Standby Nodes
- RAID
- Performance Optimization
- Join Strategies
- Confidence Levels
- Statistics collection process
- Performance tuning techniques
