Advanced Teradata
Corso
A Milano
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
Descrizione
-
Tipologia
Corso
-
Luogo
Milano
Teradata is a popular Relational Database Management System for building large scale data warehousing applications. Teradata achieves this by way of parallelism.
This instructor-led, live training (onsite or remote) is aimed at application developers and engineers who wish to master more sophisticated usages of the Teradata database.
By the end of this training, participants will be able to:
Manage Teradata space.
Protect and distribute data in Teradata.
Read Explain Plan.
Improve SQL proficiency.
Use main utilities of Teradata.
Format of the Course
Interactive lecture and discussion.
Lots of exercises and practice.
Hands-on implementation in a live-lab environment.
Course Customization Options
To request a customized training for this course, please contact us to arrange.
Sedi e date
Luogo
Inizio del corso
Inizio del corso
Profilo del corso
Rich experience in using SQL.
Audience
Developers
Opinioni
Materie
- SQL
Programma
Introduction
Managing Space in Teradata
- PERM Space
- SPOOLSpace
- TEMP Space
Understanding Different Types of Tables
- Derived Table
- Volatile Table
- Global Temporary Table
Protecting Data in Teradata
- RAID protection
- Achieving and recovering data
Distributing Data in Teradata
- Hashing Algorithm
- Primary & secondary index in Teradata
- Retrieving data using PI & NUPI
- Retrieving data using USI & NUSI
Understanding Other Indexes in Teradata
- PPI (Partition Primary Index)
- MLPPI (Multi Level PPI)
- Join Index
- Sparse Index
Reading Explain Plan
- Key words in Explain Plan
Teradata Join Strategies
- Dealing with different types of Joins in SQL
- Teradata SQL Performance Tuning
- Optimization in Teradata
Using SQL in Teradata
- Working with different Functions
- String Functions
- Format Functions
- Cast Functions
- Date Functions
- Group & Aggregate Functions
Using Teradata Utilities
- FastLoad
- MultiLoad
- FastExport
- BTEQ
- Pros & cons of each utility
Best Practices
Troubleshooting
Summary and Conclusion
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
Advanced Teradata