3.2 out of 5
3.2
136 reviews on Udemy

TERADATA: Data Warehousing technology

Teradata tutorial with complete real life examples for people who would like to get certification as DBA.
Instructor:
Jigar Vora
890 students enrolled
English [Auto-generated]
Understanding Datawarehousing concepts
Get Certified as : Teradata Certified Technical Specialist
Get Certified as : Teradata Database Administrator

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


Introduction to Datawarehousing and Teradata

1
Introduction to Teradata
2
Goal of this course
3
What are Data Marts
4
Active Warehouses
5
What is RDBMS
6
RDBMS example explained

Teradata Architechture

1
Symmetric Multi-Processing (SMP) vs. Massively Parallel Processing (MPP)
2
Teradata Architecture
3
What is Clique
4
What are Fall back Clusters

Data Storage in Teradata

1
Primary Indexing
2
Secondary Index
3
Additional Indexing options

Teradata Objects

1
User defined Database table
2
Macros

Logical Database Hierarchy

1
Access Rights
2
Space Options

Teradata Specific Features

1
Explain Plan info
2
Collecting Statistics and PPI

Teradata SQL

1
DDL / DML / DCL
2
Subquery joins and Views

OLAP Functions

1
Subtotals (With ..... BY)

Teradata Utilities

1
Fastload
2
Multiload - Fast Export
3
Teradata Utilities
You can view and review the lecture materials indefinitely, like an on-demand channel.
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!
3.2
3.2 out of 5
136 Ratings

Detailed Rating

Stars 5
24
Stars 4
42
Stars 3
37
Stars 2
16
Stars 1
17
5889f667c37216aa5736c9d0bbc8e170
30-Day Money-Back Guarantee

Includes

6 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion