Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to Teradata for Government
- Background
- Why Use Teradata for Government
- User Scalability for Government
Relational Concepts for Government
- Introduction to RDBMS for Government
- Warehousing Concepts for Government
Set Up and Installation for Government
- Installation for Government
- Tools and Utilities like BTEQ for Government
Teradata Architecture for Government
- Components
- Node
- Parsing Engine
- Message Parsing Layer - BYNET
- Access Module Processor
- Storage Architecture for Government
- Retrieval Architecture for Government
- Architectural Overview for Government
Teradata Basic Concepts - SQL for Government
- Data Type for Government
- Tables
- Permanent
- Volatile
- Global Temporary
- Derived
- Set v/s Multiset Tables for Government
- Playing with Data - CRUD Operations [DDL and DML] for Government
- Logical and Conditional Operators for Government
- SET Operators for Government
- String Manipulation for Government
- Date/Time for Government
- Built-in and Aggregate Functions for Government
- Joins and Subqueries for Government
- Indexes
- Primary
- Secondary
Teradata Advanced Concepts for Government
- Case for Government
- Coalesce for Government
- Macros for Government
- Stored Procedures for Government
- Space
- Temp
- Spool
- Permanent
- Join Strategies for Government
- Statistics for Government
- Compression for Government
- Hashing Algorithm for Government
- OLAP Functions for Government
- User Management for Government
Teradata Additional Concepts for Government
- Utilities
- FastLoad for Government
- MultiLoad for Government
- FastExport for Government
- BTEQ for Government
- Data Protection Methodologies for Government
- Optimization Strategies for Government
Note: The Training will be a mix of theory and hands-on exercises, and it would be helpful if the delegates actively participate in the given exercises.
Requirements
Basic knowledge of SQL and database systems is beneficial, though foundational concepts will be reviewed during the training course for government participants.
21 Hours
Testimonials (3)
passionate trainer
Sylvia Baniak - Maastricht University | UMIO
Course - Teradata Fundamentals
Discussing many examples.
Emily Chesworth - Maastricht University | UMIO
Course - Teradata Fundamentals
Nice training, full of interesting topics. After each topic helpful examples were provided.
