Getting Started with Teradata

Getting Started with Teradata, available at $44.99, has an average rating of 3.8, with 49 lectures, based on 88 reviews, and has 366 subscribers.

You will learn about Understand Teradatas 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. This course is ideal for individuals who are Developers/Designers who want to gain acceleration in their careers as an Teradata Developer/Designer or Analytics Managers who are subject matter experts, leading a team of analysts. or Individual Contributors in the field of Enterprise Business Intelligence. It is particularly useful for Developers/Designers who want to gain acceleration in their careers as an Teradata Developer/Designer or Analytics Managers who are subject matter experts, leading a team of analysts. or Individual Contributors in the field of Enterprise Business Intelligence.

Enroll now: Getting Started with Teradata

Summary

Title: Getting Started with Teradata

Price: $44.99

Average Rating: 3.8

Number of Lectures: 49

Number of Published Lectures: 49

Number of Curriculum Items: 49

Number of Published Curriculum Objects: 49

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

Understand Teradatas 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.

Who Should Attend

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.

Target Audiences

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.

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.?

Course Curriculum

Chapter 1: Module 1:- Introduction to the course

Lecture 1: Introduction to Teradata

Lecture 2: 1.2 Prerequisites

Lecture 3: 1.3 History of TeraData

Lecture 4: 1.4 Features of TeraData

Chapter 2: Module 2:- An Overview of Teradata Concepts

Lecture 1: 2.1 Architecture of TeraData

Lecture 2: 2.2 Relational Concepts

Lecture 3: 2.3 Datatypes

Chapter 3: Module 3:- DDL (Data Definition Language)

Lecture 1: 3.1 Introduction to Tables

Lecture 2: 3.2 Create Table Command

Lecture 3: 3.3 Alter Table Command

Lecture 4: 3.4 Drop Table Command

Chapter 4: Module 4:- DML (Data Manipulation Language)

Lecture 1: 4.1 Insert Records

Lecture 2: 4.2 Update Records

Lecture 3: 4.3 Delete Records

Lecture 4: 4.4 SELECT Statement

Lecture 5: 4.5 WHERE Clause

Lecture 6: 4.6 ORDER BY

Lecture 7: 4.7 GROUP BY

Chapter 5: Module 5:- Operators in Teradata

Lecture 1: 5.1 Logical and Conditional Operators

Lecture 2: 5.2 SET Operators and UNION

Lecture 3: 5.3 UNION ALL

Lecture 4: 5.4 INTERSECT

Lecture 5: 5.5 MINUS or EXCEPT

Chapter 6: Module 6:- Various Functions and Conditions in TeraData

Lecture 1: 6.1 String Manipulation

Lecture 2: 6.2 Date and Time Functions

Lecture 3: 6.3 Built in Functions

Lecture 4: 6.4 Aggregate Functions

Lecture 5: 6.5 CASE, COALESCE and NULLIF

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

Lecture 1: 7.1 Primary Index

Lecture 2: 7.2 Joins

Lecture 3: 7.3 Subqueries

Chapter 8: Module 8:- Advanced Concepts in TeraData

Lecture 1: 8.1 Table Types

Lecture 2: 8.2 Space Concepts

Lecture 3: 8.3 Secondary Indexes

Lecture 4: 8.4 Statistics in Teradata

Lecture 5: 8.5 Compression in Teradata

Lecture 6: 8.6 Explain in Teradata

Lecture 7: 8.7 Hashing Algorithm

Lecture 8: 8.8 Join Index

Lecture 9: 8.9 Views in Teradata

Lecture 10: 8.10 Macros

Lecture 11: 8.11 Stored Procedures

Lecture 12: 8.12 Join Strategies

Lecture 13: 8.13 Partitioned Primary Index

Lecture 14: 8.14 OLAP Functions

Lecture 15: 8.15 Data Protection

Lecture 16: 8.16 User Management

Lecture 17: 8.17 Performance Tuning

Lecture 18: 8.18 Fastload

Instructors

Launch Programmers
Keep Programming Simple

Rating Distribution

1 stars: 11 votes

2 stars: 15 votes

3 stars: 20 votes

4 stars: 25 votes

5 stars: 17 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

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!