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!