Learn Teradata: A Beginner to Advanced Guide

Name: Learn Teradata: A Beginner to Advanced Guide
Rating: 3.7 (78 reviews)

A Complete Package for Beginner & Experts to master Teradata concepts in developing Data Warehousing application

Created byTechno Crats

Last updated 2/2019

English

What you'll learn

This course will introduce the participants to work with Teradata. The course will cover in detail about Teradata Architecture, Indexing mechanism and how data is stored and retrieved.
It will cover basic and advanced SQL operations in Teradata. It will also cover various utilities provided by Teradata to process, import and export data.

Course content

1 section • 50 lectures • 3h 28m total length

Introduction to Teradata3:10
History of Teradata1:34
Features of Teradata1:43
Architecture of Teradata4:12
Applications of Teradata1:00
Downloading and Installing VMWare Workstation Player1:49
Downloading and Installing Teradata2:47
Relational Concepts2:05
Datatypes1:58
Table Types1:45
Set Vs Multiset Table4:37
Creating and Deleting Tables6:10
Insert Records5:59
Update Records1:48
Delete Records1:20
SELECT Statement4:43
Logical and Conditional Operators4:13
SET Operators5:21
String Manipulation5:10
Date and Time Functions9:14
Aggregate Functions3:06
Sample Function2:20
TOP Function2:36
CASE and COALESCE Statement5:22
Primary Index5:09
Joins6:14
SubQueries1:51
Explain Plan7:08
NOPI (No Primary Index) Table3:17
Secondary Index9:32
Join Index9:45
Partition Primary Index4:28
Join Strategies2:14
Space Management3:14
Statistics5:22
Compression3:47
Permanent Journal4:01
Recovery Journal2:01
Locks in Teradata4:25
Views3:32
Macros3:40
Stored Procedures1:11
OLAP Function4:20
Data Protection3:04
Users Management4:16
Performance Tuning2:46
Teradata BTEQ3:55
FastLoad9:25
MultiLoad9:22
FastExport6:00

Requirements

Basic Knowledge in SQL
General relational database
basic unix commands

Description

Teradata provides market leading data and analytics platform. Built from scratch using parallelism, Teradata has been a market leader for decades. It is used by world’s largest and competitive organizations to derive insights from their data and make decisions.

In addition to its data warehousing platform, Teradata provides Analytics platform and connectors to integrate seamlessly with Hadoop.

The Teradata database management system can be applied in a number of areas. It can be used for enterprise or active data warehousing and even for customer relationship management in large scale organizations and MNCs that cater to a wide variety of clients at the same time.

Who this course is for:

Developers/Designers who want to gain acceleration in their careers as an Teradata Developer/Designer
Analytics Managers who are subject matter experts, leading a team of analysts
Individual Contributors in the field of Enterprise Business Intelligence.