Learn Teradata- A Beginner to Advanced Guide

Learn Teradata: A Beginner to Advanced Guide, available at $34.99, has an average rating of 3.55, with 50 lectures, based on 64 reviews, and has 420 subscribers.

You will learn about 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. 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: Learn Teradata: A Beginner to Advanced Guide

Summary

Title: Learn Teradata: A Beginner to Advanced Guide

Price: $34.99

Average Rating: 3.55

Number of Lectures: 50

Number of Published Lectures: 50

Number of Curriculum Items: 50

Number of Published Curriculum Objects: 50

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will 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.

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

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction to Teradata

Lecture 2: History of Teradata

Lecture 3: Features of Teradata

Lecture 4: Architecture of Teradata

Lecture 5: Applications of Teradata

Lecture 6: Downloading and Installing VMWare Workstation Player

Lecture 7: Downloading and Installing Teradata

Lecture 8: Relational Concepts

Lecture 9: Datatypes

Lecture 10: Table Types

Lecture 11: Set Vs Multiset Table

Lecture 12: Creating and Deleting Tables

Lecture 13: Insert Records

Lecture 14: Update Records

Lecture 15: Delete Records

Lecture 16: SELECT Statement

Lecture 17: Logical and Conditional Operators

Lecture 18: SET Operators

Lecture 19: String Manipulation

Lecture 20: Date and Time Functions

Lecture 21: Aggregate Functions

Lecture 22: Sample Function

Lecture 23: TOP Function

Lecture 24: CASE and COALESCE Statement

Lecture 25: Primary Index

Lecture 26: Joins

Lecture 27: SubQueries

Lecture 28: Explain Plan

Lecture 29: NOPI (No Primary Index) Table

Lecture 30: Secondary Index

Lecture 31: Join Index

Lecture 32: Partition Primary Index

Lecture 33: Join Strategies

Lecture 34: Space Management

Lecture 35: Statistics

Lecture 36: Compression

Lecture 37: Permanent Journal

Lecture 38: Recovery Journal

Lecture 39: Locks in Teradata

Lecture 40: Views

Lecture 41: Macros

Lecture 42: Stored Procedures

Lecture 43: OLAP Function

Lecture 44: Data Protection

Lecture 45: Users Management

Lecture 46: Performance Tuning

Lecture 47: Teradata BTEQ

Lecture 48: FastLoad

Lecture 49: MultiLoad

Lecture 50: FastExport

Instructors

Techno Crats
A new Innovation Everyday

Rating Distribution

1 stars: 7 votes

2 stars: 3 votes

3 stars: 21 votes

4 stars: 17 votes

5 stars: 16 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!