Learn Teradata from Scratch- A Basic to Advanced Overview

Learn Teradata from Scratch- A Basic to Advanced Overview, available at $59.99, has an average rating of 4.17, with 49 lectures, based on 6 reviews, and has 17 subscribers.

You will learn about Introduction to Teradata An Overview of Teradata Concepts Operators in Teradata Advanced Concepts in TeraData Index, Join and Sub-queries in TeraData Various Functions and Conditions in TeraData This course is ideal for individuals who are Beginners, Students, Learners, Big Data Architects etc. It is particularly useful for Beginners, Students, Learners, Big Data Architects etc.

Enroll now: Learn Teradata from Scratch- A Basic to Advanced Overview

Summary

Title: Learn Teradata from Scratch- A Basic to Advanced Overview

Price: $59.99

Average Rating: 4.17

Number of Lectures: 49

Number of Published Lectures: 49

Number of Curriculum Items: 49

Number of Published Curriculum Objects: 49

Original Price: ?999

Quality Status: approved

Status: Live

What You Will Learn

Introduction to Teradata

An Overview of Teradata Concepts

Operators in Teradata

Advanced Concepts in TeraData

Index, Join and Sub-queries in TeraData

Various Functions and Conditions in TeraData

Who Should Attend

Beginners, Students, Learners, Big Data Architects etc.

Target Audiences

Beginners, Students, Learners, Big Data Architects etc.

Learn Teradata from Scratch- A Basic to Advanced Overview is a course for intermediate learners and for freshers also. One can simply learn this course if you are having some knowledge of SQL and database concepts. Teradata is a popular Relational Database Management System (RDBMS) suitable for large data warehousing applications. Teradata achieves this by the concept of parallelism which means the use of parallel processing. It is capable of handling large volumes of data and is highly scalable. It is developed by the company called Teradata. This Course provides a good understanding of Teradata Architecture, various SQL commands, Indexing concepts and Utilities to import/export data.

There are numerous reasons why clients choose Teradata over other databases.

· Linear scalability helps to support more users/data/queries/query complexity without losing performance. When system configuration grows performance increases linearly.

· System is built on open architecture, so whenever any faster chip and device are made available it can be incorporated into the already build architecture.

· Automatic distribution of data across multiple processors (AMP) evenly. Components divide task into approximately equal pieces so all parts of the system are kept busy to accomplish the task faster.

· Single point of control for the DBA to manage the database using Teradata viewpoint.

· Compatible with large numbers of BI tool to fetch data.

Course Curriculum

Chapter 1: Introduction to the Basics of Teradata

Lecture 1: Introduction

Lecture 2: Prerequisites of Learning Teradata

Lecture 3: History

Lecture 4: Features

Chapter 2: Overview of Teradata Concepts

Lecture 1: Architecture of TeraData

Lecture 2: Relational Concepts

Lecture 3: Datatypes

Chapter 3: DDL (Data Definition Language)

Lecture 1: Introduction to Tables

Lecture 2: Create Table Command

Lecture 3: Alter Table Command

Lecture 4: Drop Table Command

Chapter 4: DML (Data Manipulation Language)

Lecture 1: Insert Records

Lecture 2: Update Records

Lecture 3: Delete Records

Lecture 4: SELECT Statement

Lecture 5: WHERE Clause

Lecture 6: ORDER BY

Lecture 7: GROUP BY

Chapter 5: Operators in Teradata

Lecture 1: Logical and Conditional Operators

Lecture 2: SET Operators and UNION

Lecture 3: UNION ALL

Lecture 4: INTERSECT

Lecture 5: MINUS or EXCEPT

Chapter 6: Various Functions and Conditions in TeraData

Lecture 1: String Manipulation

Lecture 2: Date and Time Functions

Lecture 3: Built in Functions

Lecture 4: Aggregate Functions

Lecture 5: CASE, COALESCE and NULLIF

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

Lecture 1: Primary Index

Lecture 2: Joins

Lecture 3: Subqueries

Chapter 8: Advanced Concepts in TeraData

Lecture 1: Table Types

Lecture 2: Space Concepts

Lecture 3: Secondary Indexes

Lecture 4: Statistics in Teradata

Lecture 5: Compression in Teradata

Lecture 6: Explain in Teradata

Lecture 7: Hashing Algorithm

Lecture 8: Join Index

Lecture 9: Views in Teradata

Lecture 10: Macros

Lecture 11: Stored Procedures

Lecture 12: Join Strategies

Lecture 13: Partitioned Primary Index

Lecture 14: OLAP Functions

Lecture 15: Data Protection

Lecture 16: User Management

Lecture 17: Performance Tuning

Lecture 18: Fastload

Instructors

Anurag Kaushik
Hi there I am here to share my knowledge to the world.

Rating Distribution

1 stars: 1 votes

2 stars: 0 votes

3 stars: 0 votes

4 stars: 1 votes

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