Duration

30 Hours(For Regular Course)

4-8 Hours(For Capsule Course)


Enroll Now

Request more information




Teradata Certification Training

This web-based training course on Teradata Training Course functionality, administration and development, is available online to all individuals, institutions, corporates and enterprises in India (New Delhi NCR, Bangalore, Chennai, Kolkatta), US, UK, Canada, Australia, Singapore, United Arab Emirates (UAE), China and South Africa. No matter where you are located, you can enroll for any training with us - because all our training sessions are delivered online by live instructors using interactive, intensive learning methods.


Teradata is a Relational Database Management System or RDBMS that was founded by Teradata Corp. The database management system is widely recognized for its capability to manage vast data warehousing operations. It runs on Windows Server Platform or UNIX MP-RAS. The database is basically designed to handle simple and complex analytical queries. It is very useful when it comes to developing big data warehousing applications. Teradata database 16.0 is the most recent version of the database management system. Teradata 15.0 has also been very popular among organizations for its effective management of large data warehousing operations.


Topic

  • Introduction to DW and Teradata
  • Introduction to Data Warehouse
  • DW Architecture
  • Data marts
  • Dimension and fact tables, schemas
  • OLAP system and Types
  • Intro to Teradata DBMS
  • Teradata Features
  • Teradata Architecture
  • Life Cycle of SQL request in TD
  • Teradata Structured Query Language (SQL)
  • Relational Model
  • Normalization
  • Fault Tolerance
  • Concurrency Control and Transaction Recovery
  • System Administration
  • SQL Requests
  • SQL Transaction Processing
  • Data Types
  • DDL, DML, DCL Statements
  • Creations of Table with Set/Multiset options.
  • Teradata Structured Query Language (SQL) - Contd
  • Temporary, Volatile, Global & Delivered Tables
  • CASE and SET operater
  • DATE TIME Function
  • OLAP Functions
  • HASH Functions
  • Data Type Conversions
  • Macros
  • Stored Procedures
  • Teradata Indexes
  • Database Design
  • Primary Index
  • Partitioned Primary Index
  • Secondary Index
  • Hash Index
  • SQL Joins
  • Joins Methods
  • Teradata Utilities
  • BTEQ
  • Fast Load
  • Multi Load
  • TPUMP
  • Fast Export

The use of Teradata in organizations helps in strengthening the analytical abilities and further assists them in enhancing their core business analytics. Compared to others, Teradata has the biggest flexible platform. The reason behind many organizations using Teradata is that regardless of the volumes of data, the platform can be scaled. Teradata is now used by some of the biggest organizations in the world and the trend is expected to continue in the future too. For those looking for a professional career in this Relational Database Management System there is a sure shot guarantee of success given that the professional holds a Teradata Certified Training from a reputed training provider.

1. Are lab-sessions available after theory sessions?

We provide online lab facilities to all our students, wherever possible & applicable, using a combination of one or more options, including global ASP setups, live-environments, real-time simulations, training-videos, PPTs, Screenshots and others.

2. Who and how qualified are the instructors?

All our instructors go through a rigorous and multiple processes of filtering and selection before they are appointed by us. Only the most qualified, most experienced and best suited candidates are chosen as instructors.

3.What are the machine requirements for the course?

You must have a fairly good desktop PC or laptop. You can even access these courses on your tabs or smart phones. For PCs and laptops the configuration should be at-least an Intel Pentium processor, 4GB of RAM and 50 to 100 GB of free hard disk space. You must also have a good and steady WiFi internet connection which works at 3G or 4G speeds.

4.How will I undergo practical training in the course?

Depending on the type of lab facilities available for the course you have enrolled in for our instructor would be happy to help you in your lab sessions.

5.What is the process to get my questions/queries answered?

Get in touch with your trainer. You can also consult your batch-mates. We believe in collaborative and practical learning.

6.Can a free demo session be provided?

We do not provide free demo sessions.

7.Will there be a provision for repetition if I miss a class?

We encourage our trainees to attend all sessions. If you have missed a session we will try out best to update you on it, if possible. Else you will need to pay a small fee to have a repeat session arranged specifically for you.

8.Does your organization provide assistance in job hunting?

We are connected across the industry in India and abroad. We will pass on any job openings from our customer to our trainees. But we are not a manpower placement provider.

9.How and where can I make the payment?

You can pay using any credit or debit card in India or abroad. You can also pay using your PayPal account.

10. Will practice material or tests be also provided with the course?

Yes. As required & as applicable.

11.What is the minimum or maximum batch size?

Minimum/maximum batch sizes vary from course to course, depending upon a number of factors. It can vary from as few as 2 to as many as a few hundred, in some cases. But that number does not impact the quality of training that we deliver due to our tight quality-control mechanisms.

All trainees will be provided with a course participation and completion certificate by Aurelius Corporate Solutions. Please note, we are an independent provider of learning solutions. We are not affiliated in any manner to any company or organization.

  1. List the phases in PE that a query will pass thru?
  2. List the different components in Teradata architecture
  3. Using which index data distribution happens in Teradata?
  4. Unique primary index is how many AMP operation?
  5. Unique secondary index is how many AMP operation?
  6. How AMP level data protection happens in Teradata
  7. How Disk level data protection happens in Teradata
  8. What are all different locks available in Teradata
  9. Suppose an exclusive lock has been placed on a table, what are all the other locks that can be allowed during that lock?
  10. What are all the different phases a query pass thru in Fastload?
  11. What are all the different phases a query pass thru in Multiload?
  12. What is a clique?
  13. What are the differences between Fastload and Multiload?
  14. What are statistics in Teradata?
  15. What is the difference between SET and MULTISET table
  16. What is the difference between global Temporary table and Volatile table
  17. What is the difference between inner join and outer join
  18. How do you see DDL for an existing table?
  19. How to execute fastload job in batch mode?
  20. How many tables you can load using Fastload at a time?
  21. What are all the different DML operations that Multi load supports?
  22. How many error tables will be there in Fastload and what is their purpose?
  23. What are the different temporary tables in Teradata
  24. What is the syntax of collect stats statememt?
  25. What are filters and throttles in Teradata Workload Management.
  26. What is the difference between SET and MULTISET table?
  27. Which is a key capability provided by the Teradata Parallel Database Extensions (PDE)?
  28. What is the equivalent TPT (Teradata Parallel Transporter) operator for Multiload operation?
  29. What differentiates a User from a Database?
  30. What are roles in Teradata?
  31. What information is utilized by the Teradata Optimizer to create the lowest cost execution plan?
  32. What does the hashing algorithm use to determine which AMP will receive the data?
  33. What is a purpose of the Primary Index in the Teradata Database?
  34. Which portlet in Teradata viewpoint to use check user queries?
  35. Which portlet is used to schedule the stats collection jobs in Teradata Viewpoint?
  36. Can we set-up database space alerts from Viewpoint?
  37. Role R1 is assigned the access rights Select, insert, update, delete on table emp_dtl. How can users U1 and U2 can select data from table emp_dtl?
  38. If user U1 and U2 has to share the spool space of 10GB, how to accomplish that using profiles.
  39. What are the ways that space can be moved from one database to another database.

Copyright © 2016 Aurelius Corporate Solutions Pvt. Ltd. All Rights Reserved.