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
 

Need help picking the right course?
Call us +971 4871 6715

Testimonials

Excercises were good, trainer was helpful. I also assume that trainer adapted a little to our knowledge after first day.

- Capgemini Polska sp. z o.o.

Trainer's enthusiasm and energy

- Capgemini Polska sp. z o.o.

Tips to improve performance

- Capgemini Polska sp. z o.o.

the good energy of the trainer, he explained everything clearly and precisely

MicroStrategy Poland Sp. z o.o.

Materials (code, presentation) were good

MicroStrategy Poland Sp. z o.o.

Nice training, full of interesting topics. After each topic helpful examples were provided.

Pawel Wojcikowski - MicroStrategy Poland Sp. z o.o.

I like the comprehensive approach to the subject taught. The course was well-structured, the topics were prepared and presented in a good order, helping us understand step-by-step logic how particular aspects of Teradata work. Especially I like that a lot of impact was put on the topic of indices. Pablo is a very likeable person and a good teacher. The time spent on this training was definitely spent well.

MicroStrategy Poland Sp. z o.o.

interaction

Maastricht University | UMIO

Discussing many examples.

Emily Chesworth - Maastricht University | UMIO

exercises & subquery

Maastricht University | UMIO

I liked the depth of the training. I was able to understand most of it and definitely learned from this training

Maastricht University | UMIO

passionate trainer

Sylvia Baniak - Maastricht University | UMIO

x

Maastricht University | UMIO

New learned skills

Maastricht University | UMIO

The enthusiasm of the trainer

Maastricht University | UMIO

Explaining the step to take when trying to answer a question via the SQL

Maastricht University | UMIO

wide aspect of Teradata knolwedge - starting basic architecture monitoring finishing

MicroStrategy Poland Sp. z o.o.

Related Courses

Advanced Teradata

 14 hours

Teradata is a popular Relational Database Management System for building large scale data warehousing applications. Teradata achieves this by way of parallelism. This instructor-led, live training (online or onsite) is aimed at application

Big Data Analytics for Telecom Regulators

 14 hours

To meet compliance of the regulators, CSPs (Communication service providers) can tap into Big Data Analytics which not only help them to meet compliance but within the scope of same project they can increase customer satisfaction and thus

Big Data Architect

 35 hours

Day 1 - provides a high-level overview of essential Big Data topic areas. The module is divided into a series of sections, each of which is accompanied by a hands-on exercise. Day 2 - explores a range of topics that relate analysis practices and

Big Data and its Management Process

 14 hours

Objective : This training course aims at helping attendees understand why Big Data is changing our lives and how it is altering the way businesses see us as consumers. Indeed, users of big data in businesses find that big data unleashes a

Big Data - Data Science

 14 hours

This classroom based training session will explore Big Data. Delegates will have computer based examples and case study exercises to undertake with relevant big data tools

Vespa: Serving Large-Scale Data in Real-Time

 14 hours

Vespa is an open-source big data processing and serving engine created by Yahoo.  It is used to respond to user queries, make recommendations, and provide personalized content and advertisements in real-time. This instructor-led, live

Big Data Business Intelligence for Govt. Agencies

 35 hours

Advances in technologies and the increasing amount of information are transforming how business is conducted in many industries, including government. Government data generation and digital archiving rates are on the rise due to the rapid growth of

Big Data Business Intelligence for Criminal Intelligence Analysis

 35 hours

Advances in technologies and the increasing amount of information are transforming how law enforcement is conducted. The challenges that Big Data pose are nearly as daunting as Big Data's promise. Storing data efficiently is one of these

From Data to Decision with Big Data and Predictive Analytics

 21 hours

Audience If you try to make sense out of the data you have access to or want to analyse unstructured data available on the net (like Twitter, Linked in, etc...) this course is for you. It is mostly aimed at decision makers and people who need to

Programming with Big Data in R

 21 hours

Big Data is a term that refers to solutions destined for storing and processing large data sets. Developed by Google initially, these Big Data solutions have evolved and inspired other similar projects, many of which are available as open-source. R

Big Data Storage Solution - NoSQL

 14 hours

When traditional storage technologies don't handle the amount of data you need to store there are hundereds of alternatives. This course try to guide the participants what are alternatives for storing and analyzing Big Data and what are theirs

A Practical Introduction to Data Analysis and Big Data

 35 hours

Participants who complete this instructor-led, live training will gain a practical, real-world understanding of Big Data and its related technologies, methodologies and tools. Participants will have the opportunity to put this knowledge into

SQL For Data Science and Data Analysis

 14 hours

  This instructor-led, live training (online or onsite) is aimed at software developers, managers, and business analyst who wish to use big data systems to store and retrieve large amounts of data. By the end of this training,

Big Data & Database Systems Fundamentals

 14 hours

The course is part of the Data Scientist skill set (Domain: Data and Technology).

Data Science for Big Data Analytics

 35 hours

Big data is data sets that are so voluminous and complex that traditional data processing application software are inadequate to deal with them. Big data challenges include capturing data, data storage, data analysis, search, sharing, transfer,