3.2 out of 5
3.2
69 reviews on Udemy

Getting Started with Teradata

Become an expert in developing Data Warehousing applications using Teradata
Instructor:
Launch Programmers
283 students enrolled
English [Auto-generated]
Understand Teradata's competitive advantage over other RDBMSs
Understand Teradata Architecture and Indexing mechanism
Use SQL to process data stored in Teradata tables.
Use Teradata application utilities to import/export data.
Apply various performance turning techniques to optimize the queries.

Teradata provides market leading data and analytics platform. Built from scratch using parallelism, Teradata has been 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.

This course will introduce the participants to work with Teradata. In this course we will cover details 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. 

Module 1:- Introduction to the course

1
Introduction to Teradata
2
1.2 Prerequisites
3
1.3 History of TeraData
4
1.4 Features of TeraData

Module 2:- An Overview of Teradata Concepts

1
2.1 Architecture of TeraData
2
2.2 Relational Concepts
3
2.3 Datatypes

Module 3:- DDL (Data Definition Language)

1
3.1 Introduction to Tables
2
3.2 Create Table Command
3
3.3 Alter Table Command
4
3.4 Drop Table Command

Module 4:- DML (Data Manipulation Language)

1
4.1 Insert Records
2
4.2 Update Records
3
4.3 Delete Records
4
4.4 SELECT Statement
5
4.5 WHERE Clause
6
4.6 ORDER BY
7
4.7 GROUP BY

Module 5:- Operators in Teradata

1
5.1 Logical and Conditional Operators
2
5.2 SET Operators and UNION
3
5.3 UNION ALL
4
5.4 INTERSECT
5
5.5 MINUS or EXCEPT

Module 6:- Various Functions and Conditions in TeraData

1
6.1 String Manipulation
2
6.2 Date and Time Functions
3
6.3 Built in Functions
4
6.4 Aggregate Functions
5
6.5 CASE, COALESCE and NULLIF

Module 7:- Index, Join and Sub-queries in TeraData

1
7.1 Primary Index
2
7.2 Joins
3
7.3 Subqueries

Module 8:- Advanced Concepts in TeraData

1
8.1 Table Types
2
8.2 Space Concepts
3
8.3 Secondary Indexes
4
8.4 Statistics in Teradata
5
8.5 Compression in Teradata
6
8.6 Explain in Teradata
7
8.7 Hashing Algorithm
8
8.8 Join Index
9
8.9 Views in Teradata
10
8.10 Macros
11
8.11 Stored Procedures
12
8.12 Join Strategies
13
8.13 Partitioned Primary Index
14
8.14 OLAP Functions
15
8.15 Data Protection
16
8.16 User Management
17
8.17 Performance Tuning
18
8.18 Fastload
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.2
3.2 out of 5
69 Ratings

Detailed Rating

Stars 5
13
Stars 4
17
Stars 3
17
Stars 2
12
Stars 1
10
62e88a937a6203ff4b0ce90c373d7ff8
30-Day Money-Back Guarantee

Includes

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