Teradata is being widely used currently as a database for Data Warehousing Environment. Most of the Data Warehousing Databases which were earlier built on oracle or db2 databases are being replaced by Teradata database; this is due to the Teradata features of linear expandability, Scalability, and Parallelism. It Can handle data warehouses of very large sizes like thousands of terabytes of data, there are some clients which today have few petabytes of data on Teradata (1PB = 1024 TB), this is huge data.
As lots of organizations have now moved to Teradata for their data warehousing needs, and also many of them are moving currently to Teradata or have a plan to move to Teradata for their data warehousing it provides with immense career opportunities to the individuals who have good knowledge on Teradata. Considering the market scenario, there is a very huge demand for Teradata professionals.
The course is designed primarily from the perspective of building the knowledge required to become a Teradata Developer. It goes through the basic relational database concepts, Data warehousing need and its detailed overview, advantages of Teradata, the popularity of Teradata, the different reason of preferring Teradata over the other databases in data warehousing. Understanding Teradata Components & Architecture, Concepts of database and users. We will also go through practical session to create the databases and users in Teradata using sql assistant. Covering concepts of Data distribution and access in Teradata, Concepts of Primary key and primary index, NOPI tables , Columnar tables, Unique primary index access, Non-Unique Primary index access, Secondary index access, Full table scan, Partitioned tables .
We will go through the practical implementation of these concepts of Primary key, primary indexes, Secondary indexes, NOPI tables, columnar tables, Partitioning of tables using Teradata SQL Assistant. Understanding the difference between different types of table access and how to make the efficient use of those. Going through the fault tolerance techniques which give Teradata the advantage of no single point of failure and data protection. Different types of locks acquired on the tables and the priority of the locks.
We will understand how the locks are acquired and released in Teradata by practically implementing the same.
We will go through different tools and utilities provided by Teradata that makes the use of Teradata concepts and hence practically implementing those concepts. We will be using Teradata SQL Assistant most frequently in our course as it is required for firing any sort of SQL Query on Teradata database. We will be implementing BTEQ Scripts and also thoroughly understanding the scenarios where it can be used and its purpose. We will be also practically implementing the different utilities of Teradata like Fastload, Multiload, Tpump, FastExport & Teradata Parallel transporter. We will also go through the usage of Teradata Administrator tool and also make the practical of the tool.
While going through the whole course we will be implementing the concepts practically using some test case scenarios which we will be very much useful in understanding the concepts more clearly.
Udemy Coupon Code : https://www.udemy.com/teradata-and-informatica/?couponCode=TINTIN