Certificate Authentication

Teradata Fundamentals Certificate for Patrycja Prażmo

Add to LinkedIn

Certificate ID: 
595675
Authentication Code: 
76adf
Certified Person Name: 
Patrycja Prażmo
Trainer Name: 
Juan Pablo Maldonado Lopez
Duration Days: 
3
Duration Hours: 
21
Course Name: 
Teradata Fundamentals
Course Date: 
30 September 2019 09:00 to 2 October 2019 16:00
Venue: 
Warszawa
Course Outline: 

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

Note: The Training will be a mix of theory and hands on exercises, and it would be helpful if the delegates actively particpate in the given exercises.