Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
The course covers teradata in detail with some best real life examples :
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
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction to Datawarehousing and Teradata|
Introduction to TeradataPreview
Goal of this course
What are Data MartsPreview
What is RDBMSPreview
RDBMS example explained
|Section 2: Teradata Architechture|
Symmetric Multi-Processing (SMP) vs. Massively Parallel Processing (MPP)
What is Clique
What are Fall back Clusters
|Section 3: Data Storage in Teradata|
Additional Indexing options
|Section 4: Teradata Objects|
User defined Database table
|Section 5: Logical Database Hierarchy|
|Section 6: Teradata Specific Features|
Explain Plan info
Collecting Statistics and PPI
|Section 7: Teradata SQL|
DDL / DML / DCL
Subquery joins and Views
|Section 8: OLAP Functions|
Subtotals (With ..... BY)
|Section 9: Teradata Utilities|
Multiload - Fast Export
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.