Course Overview
About Course
This 40‑Hour Teradata Training equips professionals to architect, administer, and optimize large-scale data warehouses using Teradata’s enterprise-grade platform. Starting with core architecture fundamentals—MPP systems, Parsing Engines, AMPs, and BYNET—it establishes a strong foundation in how Teradata processes and distributes data efficiently
Key modules focus on space and storage management, covering permanent, spool, and temporary spaces and data compression strategies, enabling learners to design storage-efficient databases . Training also covers Teradata’s metadata ecosystem, making students adept at navigating the DBC dictionary tables for tracking schema objects and sessions
Security is a priority, delivering hands-on experience configuring roles, profiles, and access rights, along with implementing logon policies and encryption for enterprise compliance SQL modules equip learners with expert knowledge of join strategies (hash, merge, nested), set operations, and advanced query constructs including BTEQ scripting and utility usage like MultiLoad and TPump
Performance tuning is rigorously addressed through query logging (DBQL), ResUsage analysis, EXPLAIN plans, locking diagnostics, and statistics management—essential skills for optimizing query performance at scale. Complementing this, modules on archiving, recovery, backup, restore, and remote administration tools ensure learners can maintain high availability environments
Advanced sessions delve into partitioning, indexing, capacity planning, workload management, and Teradata Viewpoint for proactive monitoring using dashboards and alerts . The capstone project binds these learnings—designing a warehouse, populating data, optimizing loads, securing objects, and conducting archiving/recovery tasks.
This training brings together architecture, security, performance, utilities, and administration in a hands-on, mentor-led format with lifetime learning resources and job support. Graduates emerge as fully equipped Teradata DBAs or Developers, ready to manage and scale analytics environments in enterprise-grade data infrastructures.
Course Syllabus
- Module 1: Teradata Architecture & Fundamentals (4 hrs)
- Shared-nothing, MPP architecture: Parsing Engine (PE), AMPs, BYNET
- Data distribution, hashing, virtual processors, storage fundamentals
- Module 2: Space Management & Storage (4 hrs)
- Permanent, spool, temp space
- Block-level storage, compression, cylinder layout, TVS
- Module 3: Data Dictionary & Object Management (4 hrs)
- DBC dictionary tables and views (e.g., DBC.Users, DBC.TableSize)
- Object metadata tracking (tables, indexes, sessions)
- Module 4: Access Control & Security (3 hrs)
- Roles, profiles, access rights (AUTO, IMPLICIT, EXPLICIT)
- Logon rules, password policies, encryption
- Module 5: SQL Essentials & Join Strategies (5 hrs)
- Teradata SQL vs ANSI SQL, set and join operations
- Join types: hash, merge, nested, product; UNION/UNION ALL
- Module 6: Performance Logging & Query Analysis (4 hrs)
- DBQL, ResUsage, EXPLAIN plan
- PMON, TD Viewpoint, dynamic charts, locking logs
- Module 7: Utilities & Data Loading Tools (4 hrs)
- BTEQ scripting, error handling, batching
- FastLoad, MultiLoad, TPump, FastExport
- Module 8: Archiving & Recovery (3 hrs)
- Archive & recovery statements, table copy/restore
- FastLoad vs archive reload strategies
- Module 9: Partitioning & Indexing Strategies (4 hrs)
- Primary and secondary indexes, join indexes
- Partitioned tables, compression techniques
- Module 10: Advanced Performance & Capacity Planning (4 hrs)
- Statistics collection, optimizer behavior, workload management
- Capacity planning, skew analysis, temporal tables
- Module 11: Teradata Viewpoint & Admin Tools (3 hrs)
- Monitoring via TD Viewpoint, admin dashboards, alerts
- Remote Console utilities (SHOWLOCKS, SHOWSPACE)
- Module 12: Capstone Project & Review (5 hrs)
- Design a multi-node warehouse
- Implement DDL, loads, tuning, archiving, recovery
- Presentation and code review
-
Key Features
- Hands-on labs on real multi-node platforms: SQL queries, BTEQ, loads, performance tuning
- Deep architecture coverage: PE, AMPs, BYNET, storage & data distribution
- Real-world utilities: BTEQ, FastLoad, MultiLoad, TPump, FastExport
- Monitoring & logging tools: DBQL, ResUsage, TD Viewpoint, PMON
- Security-centric modules: roles, profiles, encryption, password enforcement
- Performance mastery: indexing, partitioning, statistics, workload planning
- Admin toolkit: backup/recovery, archive, restore, capacity design, remote tools
- Small batch size (5–6), lifetime access, 24/7 mentor support, job assistance via CourseJet/MindMajix
Our Upcoming Batches
At Topskill.ai, we understand that today’s professionals navigate demanding schedules.
To support your continuous learning, we offer fully flexible session timings across all our trainings.
Below is the schedule for our Training. If these time slots don’t align with your availability, simply let us know—we’ll be happy to design a customized timetable that works for you.
Training Timetable
| Batches Online/Offline | Batch Start Date | Session Days | Time Slot (IST) | Fees |
|---|---|---|---|---|
| Week Days (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Mon-Fri | 7:00 AM (Class 1-1.30 Hrs) | View Fees |
| Week Days (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Mon-Fri | 11:00 AM (Class 1-1.30 Hrs) | View Fees |
| Week Days (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Mon-Fri | 5:00 PM (Class 1-1.30 Hrs) | View Fees |
| Week Days (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Mon-Fri | 7:00 PM (Class 1-1.30 Hrs) | View Fees |
| Weekends (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Sat-Sun | 7:00 AM (Class 3 Hrs) | View Fees |
| Weekends (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Sat-Sun | 10:00 AM (Class 3 Hrs) | View Fees |
| Weekends (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Sat-Sun | 11:00 AM (Class 3 Hrs) | View Fees |
For any adjustments or bespoke scheduling requests, reach out to our admissions team at
support@topskill.ai or call +91-8431222743.
We’re committed to ensuring your training fits seamlessly into your professional life.
Note: Clicking “View Fees” will direct you to detailed fee structures, instalment options, and available discounts.
Don’t see a batch that fits your schedule? Click here to Request a Batch to design a bespoke training timetable.
Corporate Training
“Looking to give your employees the experience of the latest trending technologies? We’re here to make it happen!”
