A tanfolyamról
What organizations need today is seamless management of their ever-growing data. Teradata is a fully scalable relational database management system that is used to store, retrieve and manipulate big data. Its advantages lie in the fact that it leads to performance advantages in terms of querying, scanning, sorting and manipulation of data.
This highly interactive and comprehensive Teradata training will introduce you to the fundamentals of working with Teradata. You will learn about Teradata architecture, the indexing mechanism and the various SQL queries that will allow you to retrieve and perform manipulations on your data. You will learn about the various Teradata utilities such as Fast Load and Multi Load and how they are used to import data into Teradata. The workshop also covers in-depth advanced database objects used for performance optimization.
Who Should Attend This Training
- Database Administrators
- Developers
- Data Analysts
- Business Intelligence Professionals
What You Will Learn
-
Fundamentals of Teradata
All about Teradata, its architecture, and components and how it compares to RDBMS -
Index Mechanism
Understand the Teradata indexing mechanism and handling and manipulation of data -
Advanced SQL
Learn all about Advanced SQL operations and using sub-queries, OLAP functions and others -
Database projects
Work on Advanced Database objects and use them to perform performance tuning and optimization -
Tools and Techniques
Learn all the application utilities provided by Teradata such as FastLoad and MultiLoad -
Data Protection
Understand how to protect data in Teradata, along with how to apply it in your teams
We provide the course in English.
Tematika
Curriculum
Module 1: Introduction to Teradata
- Introduction
- Fundamentals of Teradata
Module 2: Teradata Indexes and Join Strategies
- Introduction to Indexes
- Joining Strategies
Module 3: Teradata SQL
- What is SQL
- Understanding Teradata SQL
Module 4: Data Protection
- Introduction to Data Protection
- Fundamentals of Data Protection
- Importance of Data Protection
Module 5: SQL Advanced
- Introduction to SQL Advanced
- Fundamentals of SQL Advanced
Module 6: Advanced Database objects and performance optimization
- Introduction to Advanced Database Objects
- Understanding Performance Optimization
Module 7: Teradata Utilities - FastLoad, MultiLoad, BTEQ
- Introduction to Teradata Utilities
- Understanding FastLoad
- Understanding MultiLoad
- Understanding BTEQ
Module 8: Teradata Utilities - FastExport,TPT
- What are the objectives of Teradata Utilities
- Understanding FastExport
- Understanding TPT
Kinek ajánljuk
Előfeltételek
Prerequisites
Basic Knowledge in SQL, general relational database knowledge and basic Unix commands.