3.3 out of 5
3.3
10 reviews on Udemy

Learn Teradata: A Beginner to Advanced Guide

A Complete Package for Beginner & Experts to master Teradata concepts in developing Data Warehousing application
Instructor:
Techno Crats
145 students enrolled
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.

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. 

Introduction

1
Introduction to Teradata
2
History of Teradata
3
Features of Teradata
4
Architecture of Teradata
5
Applications of Teradata
6
Downloading and Installing VMWare Workstation Player
7
Downloading and Installing Teradata
8
Relational Concepts
9
Datatypes
10
Table Types
11
Set Vs Multiset Table
12
Creating and Deleting Tables
13
Insert Records
14
Update Records
15
Delete Records
16
SELECT Statement
17
Logical and Conditional Operators
18
SET Operators
19
String Manipulation
20
Date and Time Functions
21
Aggregate Functions
22
Sample Function
23
TOP Function
24
CASE and COALESCE Statement
25
Primary Index
26
Joins
27
SubQueries
28
Explain Plan
29
NOPI (No Primary Index) Table
30
Secondary Index
31
Join Index
32
Partition Primary Index
33
Join Strategies
34
Space Management
35
Statistics
36
Compression
37
Permanent Journal
38
Recovery Journal
39
Locks in Teradata
40
Views
41
Macros
42
Stored Procedures
43
OLAP Function
44
Data Protection
45
Users Management
46
Performance Tuning
47
Teradata BTEQ
48
FastLoad
49
MultiLoad
50
FastExport
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.3
3.3 out of 5
10 Ratings

Detailed Rating

Stars 5
1
Stars 4
3
Stars 3
4
Stars 2
0
Stars 1
2
73b8944fe2a00c09d548f845842590e2
30-Day Money-Back Guarantee

Includes

3 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion