TERADATA: Data Warehousing technology
3.5 (55 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.
521 students enrolled
Wishlisted Wishlist

Please confirm that you want to add TERADATA: Data Warehousing technology to your Wishlist.

Add to Wishlist

TERADATA: Data Warehousing technology

Teradata tutorial with complete real life examples for people who would like to get certification as DBA.
3.5 (55 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.
521 students enrolled
Created by Jigar Vora
Last updated 6/2015
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understanding Datawarehousing concepts
  • Get Certified as : Teradata Certified Technical Specialist
  • Get Certified as : Teradata Database Administrator
View Curriculum
Requirements
  • Nothing. This course will cover the concepts from basics till an intermediate level
  • basic understanding of computers is a must
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


Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
25 Lectures
06:07:03
+
Introduction to Datawarehousing and Teradata
6 Lectures 01:29:44

Goal of this course
17:20


Active Warehouses
15:59


RDBMS example explained
18:33
+
Teradata Architechture
4 Lectures 01:01:51
Symmetric Multi-Processing (SMP) vs. Massively Parallel Processing (MPP)
13:34


What is Clique
11:29

What are Fall back Clusters
17:11
+
Data Storage in Teradata
3 Lectures 54:05

Secondary Index
20:23

Additional Indexing options
15:47
+
Teradata Objects
2 Lectures 18:07
User defined Database table
09:57

Macros
08:10
+
Logical Database Hierarchy
2 Lectures 29:17
Access Rights
14:44

Space Options
14:33
+
Teradata Specific Features
2 Lectures 28:48
Explain Plan info
13:56

Collecting Statistics and PPI
14:52
+
Teradata SQL
2 Lectures 33:36
DDL / DML / DCL
14:32

Subquery joins and Views
19:04
+
OLAP Functions
1 Lecture 09:24
Subtotals (With ..... BY)
09:24
+
Teradata Utilities
3 Lectures 42:11
Fastload
11:11

Multiload - Fast Export
15:06

Teradata Utilities
15:54
About the Instructor
Jigar Vora
3.5 Average rating
367 Reviews
22,616 Students
8 Courses
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.