Learning Objectives -  In this module, you will learn about Teradata's history, comparison with other RDBMS, architecture, components (PE, BYNET, AMP), interaction between components, storage and retrieval architecture, mainframe connectivity, and advanced architecture. 

Topics- Fundamental Relational Concepts, What is Teradata? What are its benefits over other RDBMS? Teradata Architecture, Teradata Components, Teradata Services How do components interact with one another? How is data saved and retrieved? Connection to Mainframe and Network Applications, Tools and Utilities Unified Data Architecture by Teradata

Learning Objectives- This lesson will teach you about various indexing principles in Teradata and how they affect data storage and retrieval. You will comprehend the significance of the primary index and how it impacts data storage, as well as the use of secondary and partition primary indexes in data retrieval. You'll also learn about the hashing technique and the numerous join strategies Teradata uses to link tables.

Topics - What is the difference between a primary key and a primary index? Types and the primary index What role does the primary index play in data distribution and retrieval? Secondary indexes and their variations Secondary index data retrieval The primary partition index and its variants, The Benefits of PPI, Combine tactics, The method via which data is redistributed for Join processing.

Learning Objectives- This lesson will teach you about Teradata SQL commands. You will learn how to build, modify, and delete database objects as well as conduct different SQL operations on the data contained in Teradata tables.  

Topics - Data types, DDL statements (CREATE, ALTER, DROP), DML statements (Insert, Delete, Update), and DCL statements are all examples of DDL statements. (Grant, Revoke), String functions, Cast and Format functions, HELP and Show Functions, Date Functions, Built-In Functions, Aggregation, Joins (INNER and OUTER).

Learning Objectives - This session will teach you about the various data protection mechanisms available in Teradata. You will learn how to manage AMP failures, Node failures, Transaction failures, and Disk failures. 

Topics - Clusters, transaction locks, and fallback tables Cliques, Hot Standby nodes, Permanent Journal, Down AMP Recovery Journal, Transient Journal Data Dictionary for RAID 1 and RAID 5.

Learning Objectives -  This lesson will teach you more about SQL commands in Teradata. Subqueries, OLAP functions, Transaction modes, and temporary tables will all be covered. You will learn how to comprehend Explain statements and gather data. 

Topics- Subqueries, Upsert, Case, Coalesce, Nullif, OLAP Functions, Rank & Row Number, Transaction Modes, and Temporary Tables are all examples of OLAP functions. (Derived, Volatile and Global Temporary), Explain, then gather statistics.

Learning Objectives - You will learn about more database objects like as views, macros, stored procedures, and join indexes in this module. You'll also look into popular performance tuning choices. 

Topics - Views, macros, stored procedures, join indexes, and performance tuning advice.