- Architecture of Teradata
- Facts, dimensions and data model concepts
- Data distribution & physical data model
- Database design
- Objects in Teradata
- Tables
- Views
- Macros
- Stored Procedure
- GTT
- VTT
- DDL Statements
- DML Statements
- Accessing Of data in Teradata
- SQL Operations
- Joins
- Sub query
- co - releated sub query
- arithmetic functions
- Aggregate functions
- string functions
- Alias
- Data type conversion
- Show
- Help
- Set operations
- Explain
- Date functions
- Case
- Coalesce
- Sample
- TOP
- row_num, rank
- Qualify
- Utilities
- Bteq
- Fast Load
- Multi load
- Fast export
|
