Last updated
Kurskode
teraintro
Varighet
21 timer (vanligvis 3 dag inkludert pauser)
Krav
Basic knowledge of SQL and Database Systems would be helpful, although the basics will be covered during the training course.
Oversikt
Teradata er en av de populære Relational Database Management System. Den er hovedsakelig egnet for å bygge applikasjoner i stor skala. Teradata oppnår dette ved begrepet parallellisme.
Dette kurset introduserer delegatene til Teradata .
Machine Translated
Kursplan
Introduction to Teradata
- Background
- Why use Teradata
- User Scalability
Relational Concepts
- Introduction to RDBMS
- Warehousing Concepts
Set Up and Installation
- Installation
- Tools and Utilities like BTEQ
Teradata Architecture
- Components
- Node
- Parsing Engine
- Message Parsing Layer - BYNET
- Access Module Processor
- Storage Architecture
- Retrieval Architecture
- Architectural Overview
Teradata Basic Concepts - SQL
- Data Type
- Tables
- Permanent
- Volatile
- Global Temporary
- Derived
- Set v/s Multiset Tables
- Playing with Data - CRUD Operations [DDL and DML]
- Logical and Conditional Operators
- SET Operators
- String Manipulation
- Date/Time
- Built in and Aggregate Functions
- Joins and Subqueries
- Indexes
- Primary
- Secondary
Teradata Advanced Concepts
- Case
- Coalesce
- Macros
- Stored Procedures
- Space
- Temp
- Spool
- Permanent
- Join Strategies
- Statistics
- Compression
- Hashing Algorithm
- OLAP Functions
- User Management
Teradata Additional Concepts
- Utilities
- FastLoad
- MultiLoad
- FastExport
- BTEQ
- Data Protection Methodologies
- Optimization Strategies