Teradata Fundamentals Treningskurs

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
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.

Testimonials

★★★★★
★★★★★

Related Categories

Relaterte kurs

Kursrabatter

Kursrabatter Nyhetsbrev

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in Norway!

As a Business Development Manager you will:

  • expand business in Norway
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!

This site in other countries/regions