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.

Requirements

Basic knowledge of SQL and Database Systems would be helpful, although the basics will be covered during the training course. 

  21 Hours
 

Testimonials

Related Courses

Advanced Teradata

  14 hours

Big Data Business Intelligence for Govt. Agencies

  35 hours

From Data to Decision with Big Data and Predictive Analytics

  21 hours

Big Data Architect

  35 hours

Programming with Big Data in R

  21 hours

Big Data Storage Solution - NoSQL

  14 hours

Big Data & Database Systems Fundamentals

  14 hours

Data Science for Big Data Analytics

  35 hours

A Practical Introduction to Data Analysis and Big Data

  35 hours

Vespa: Serving Large-Scale Data in Real-Time

  14 hours

Big Data Analytics for Telecom Regulators

  14 hours

Big Data Business Intelligence for Criminal Intelligence Analysis

  35 hours

Big Data - Data Science

  14 hours

Big Data and its Management Process

  14 hours

SQL For Data Science and Data Analysis

  14 hours