TERADATA: Data Warehousing technology

Teradata tutorial with complete real life examples for people who would like to get certification as DBA.
4.1 (25 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.
386 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 25
  • Length 6 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2015 English

Course Description

The course covers teradata in detail with some best real life examples :

The training:

  • Emphasis on teaching concepts, rather than just covering topics.
  • Animated and pictorial PPT slides for better understanding of concepts.
  • Examples used are from real life project scenarios.
  • Sessions are theoretical as well as practical.
  • Practical sessions are done by sharing the Teradata environment on trainers screen and showing the exact way of doing things in Teradata Client Software.
  • Very Interactive sessions with best audio and screen sharing.


The course covers the following Topics:

1 ) Teradata Architechture

2) Space management and data protection

3) Data Distribution

4) Indexing and Explain Plan development

5) Teradata SQL

6) Performance turning and query optimization

7) Teradata utilities and best practices.


The Final Goal of this course is to get the student acquainted to best practices in Teradata and get them capable enough to get a certification as follows:

1) Teradata Certified Professional

2) Teradata Certified database Administrator

3) Teradata Certified Technical Specialist


What are the requirements?

  • Nothing. This course will cover the concepts from basics till an intermediate level
  • basic understanding of computers is a must

What am I going to get from this course?

  • Understanding Datawarehousing concepts
  • Get Certified as : Teradata Certified Technical Specialist
  • Get Certified as : Teradata Database Administrator

What is the target audience?

  • This course is designed for starters who would like to learn what is Datawarehousing. How one can use an RDBMS Teradata to store and retrieve data. This course will cover all the concepts that one might need to complete a certification in Teradata Datawarehouse management.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to Datawarehousing and Teradata
Introduction to Teradata
Preview
09:55
Goal of this course
17:20
What are Data Marts
Preview
14:26
Active Warehouses
15:59
What is RDBMS
Preview
13:31
RDBMS example explained
18:33
Section 2: Teradata Architechture
Symmetric Multi-Processing (SMP) vs. Massively Parallel Processing (MPP)
13:34
Teradata Architecture
Preview
19:37
What is Clique
11:29
What are Fall back Clusters
17:11
Section 3: Data Storage in Teradata
Primary Indexing
Preview
17:55
Secondary Index
20:23
Additional Indexing options
15:47
Section 4: Teradata Objects
User defined Database table
09:57
Macros
08:10
Section 5: Logical Database Hierarchy
Access Rights
14:44
Space Options
14:33
Section 6: Teradata Specific Features
Explain Plan info
13:56
Collecting Statistics and PPI
14:52
Section 7: Teradata SQL
DDL / DML / DCL
14:32
Subquery joins and Views
19:04
Section 8: OLAP Functions
Subtotals (With ..... BY)
09:24
Section 9: Teradata Utilities
Fastload
11:11
Multiload - Fast Export
15:06
Teradata Utilities
15:54

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Jigar Vora, Planning Manager at Panasonic

I have a degree of Masters in Computer science and currently work as a Planning manager in the field of Logistics for a $10 billion dollar company.

I have number of years of experience working with Directors and Vice Presidents of companies presenting them alternate solutions to optimize their supply chain network.

I also own a consulting firm Aarya Global Services currently providing consulting services for supply chain network planning and Optimization to various companies.

Ready to start learning?
Take This Course