Getting Started with Teradata
3.4 (15 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
62 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Getting Started with Teradata to your Wishlist.

Add to Wishlist

Getting Started with Teradata

Become an expert in developing Data Warehousing applications using Teradata
3.4 (15 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
62 students enrolled
Last updated 5/2017
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
Requirements
  • basic Knowledge in SQL
  • General relational database knowledge
  • basic UNIX commands
Description

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. 

Who is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
49 Lectures
02:47:41
+
Module 2:- An Overview of Teradata Concepts
3 Lectures 08:52

2.2 Relational Concepts
02:30

2.3 Datatypes
02:49
+
Module 3:- DDL (Data Definition Language)
4 Lectures 14:35
3.1 Introduction to Tables
01:48

3.2 Create Table Command
08:46

3.3 Alter Table Command
02:06

3.4 Drop Table Command
01:55
+
Module 4:- DML (Data Manipulation Language)
7 Lectures 14:53
4.1 Insert Records
04:17

4.2 Update Records
02:39

4.3 Delete Records
01:26

4.4 SELECT Statement
01:35

4.5 WHERE Clause
01:32

4.6 ORDER BY
01:37

4.7 GROUP BY
01:47
+
Module 5:- Operators in Teradata
5 Lectures 13:30
5.1 Logical and Conditional Operators
05:13

5.2 SET Operators and UNION
03:22

5.3 UNION ALL
01:15

5.4 INTERSECT
02:12

5.5 MINUS or EXCEPT
01:28
+
Module 6:- Various Functions and Conditions in TeraData
5 Lectures 25:16
6.1 String Manipulation
04:26

6.2 Date and Time Functions
07:40

6.3 Built in Functions
02:05

6.4 Aggregate Functions
03:43

6.5 CASE, COALESCE and NULLIF
07:22
+
Module 7:- Index, Join and Sub-queries in TeraData
3 Lectures 11:20
7.1 Primary Index
01:34

7.2 Joins
06:54

7.3 Subqueries
02:52
+
Module 8:- Advanced Concepts in TeraData
18 Lectures 01:11:02
8.1 Table Types
03:51

8.2 Space Concepts
01:47

8.3 Secondary Indexes
01:42

8.4 Statistics in Teradata
02:56

8.5 Compression in Teradata
03:33

8.6 Explain in Teradata
08:19

8.7 Hashing Algorithm
01:49

8.8 Join Index
02:51

8.9 Views in Teradata
05:23

8.10 Macros
06:40

8.11 Stored Procedures
03:31

8.12 Join Strategies
02:55

8.13 Partitioned Primary Index
01:06

8.14 OLAP Functions
05:32

8.15 Data Protection
03:50

8.16 User Management
06:46

8.17 Performance Tuning
02:51

8.18 Fastload
05:40
About the Instructor
Launch Programmers
3.8 Average rating
32 Reviews
156 Students
5 Courses
Keep Programming Simple

Launch Programmers is an intuitive e-learning platform that is changing proficient online training. We offer online courses supported by online assets, alongside 24x7 on-request support. We give to experts the adaptability to learn at their own time and place, even from their mobile devices. Launch Programmers courses are uncommonly curated by specialists who screen the IT business with a hawk's eye, and react to desires, changes and prerequisites from the business, and consolidate them into our courses.