Topics we discussed:
- 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
Online training|Online tutorials 21st Century Software Solutions|9000444287
Email us: contact@21cssindia.com
No comments:
Post a Comment