Master Teradata- A Complete Course on Teradata

Master Teradata- A Complete Course on Teradata, available at $34.99, has an average rating of 3.2, with 59 lectures, based on 179 reviews, and has 708 subscribers.

You will learn about Introduction to Teradata Lifecycle of a Query CREATE, INSERT, DELETE, UPDATE etc. INDEX MVC, BLC, ALC VIEWS, MACROS, JOINS BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT This course is ideal for individuals who are Beginner and advanced both It is particularly useful for Beginner and advanced both.

Enroll now: Master Teradata- A Complete Course on Teradata

Summary

Title: Master Teradata- A Complete Course on Teradata

Price: $34.99

Average Rating: 3.2

Number of Lectures: 59

Number of Published Lectures: 59

Number of Curriculum Items: 59

Number of Published Curriculum Objects: 59

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

Introduction to Teradata

Lifecycle of a Query

CREATE, INSERT, DELETE, UPDATE etc.

INDEX

MVC, BLC, ALC

VIEWS, MACROS, JOINS

BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT

Who Should Attend

Beginner and advanced both

Target Audiences

Beginner and advanced both

The course covers the following Topics:

Teradata Architecture,

Space management and data protection,

Data Distribution,

Indexing and Explain Plan development,

Teradata SQL,

Performance turning and query optimization,

Teradata utilities and best practices,

The course covers teradata in detail with examples-

Sessions are theoretical as well as practical.

Examples used are from real life project scenarios.

Animated and pictorial PPT slides for better understanding of concepts.

Very Interactive sessions with best audio and screen sharing.

Emphasis on teaching concepts, rather than just covering topics.

Practical sessions are done by sharing the Teradata environment on trainers screen and showing the exact way of doing things in Teradata Client Software.

Course Curriculum

Chapter 1: Module-1 Introduction to the Course

Lecture 1: Introduction to TeraData

Lecture 2: Prerequisites

Lecture 3: History of TeraData

Lecture 4: Characteristics of TeraData

Lecture 5: Architecture of TeraData

Lecture 6: Relational Concepts

Lecture 7: Datatypes

Lecture 8: Life cycle of a Query

Lecture 9: Installation of Teradata

Lecture 10: Introduction to Tables

Lecture 11: Create Table Command

Lecture 12: Alter Table Command

Lecture 13: Drop Table Command

Lecture 14: Insert Records

Lecture 15: UPDATE Records

Lecture 16: DELETE Records

Lecture 17: SELECT Statement

Lecture 18: WHERE Clause

Lecture 19: ORDER BY

Lecture 20: GROUP BY

Lecture 21: Logical and Conditional Operators

Lecture 22: SET Operators and UNION

Lecture 23: UNION ALL

Lecture 24: INTERSECT

Lecture 25: MINUS or EXCEPT

Lecture 26: String Manipulation

Lecture 27: Date and Time Function

Lecture 28: Built in Functions

Lecture 29: Aggregate Functions

Lecture 30: CASE, COALESCE and NULLIF

Lecture 31: Primary Index

Lecture 32: Joins

Lecture 33: Subqueries

Lecture 34: Permanent Journal

Lecture 35: Recovery Journal

Lecture 36: Locks

Lecture 37: Pseudo Locks

Lecture 38: Explain Plan

Lecture 39: Table Types

Lecture 40: Space Concepts

Lecture 41: Secondary Indexes

Lecture 42: Statistics

Lecture 43: MVC

Lecture 44: BLC

Lecture 45: ALC

Lecture 46: Hashing Algorithm

Lecture 47: Join Index

Lecture 48: Views in Teradata

Lecture 49: Macros

Lecture 50: Join Strategies

Lecture 51: Partitioned Primary Index(PPI)

Lecture 52: OLAP Functions

Lecture 53: Data Protection

Lecture 54: User Management

Lecture 55: Performance Tuning

Lecture 56: BTEQ

Lecture 57: Fastload

Lecture 58: Multiload

Lecture 59: FastExport

Instructors

Edulearners Technologies
Learn With Us

Rating Distribution

1 stars: 40 votes

2 stars: 27 votes

3 stars: 38 votes

4 stars: 39 votes

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