Teradata Course

 

Teradata Course Overview

Teradata is a fully scalable relational database management system produced by Teradata Corp. It is widely used to manage large data warehousing operations. This course will acquaint you with the Teradata technology. With Teradata, you can develop business led data strategies and architect and implement diverse analytic ecosystems. This course will prepare you to code and maintain Teradata RDBMS systems with confidence and help you to solve problems within the database.

The features Code massive parallel processing architectures and complex algorithms in Teradata DBMS. Handle analytical queries and focus on scalability, parallel processing and performance on Teradata DBMS systems. Teradata culture is evolving and will be the future data warehousing entity.

Teradata is leading data and analytics platform. It is built on scratch using parallelism. It is currently being used by world’s largest organizations to drive their insights from the data produced. 

This course is designed for the absolute beginner, developers, database analysts anyone interested to change career into Teradata.

No programming skills required to take course. Individual who have database knowledge is easier to take the course.

After completion of the course, you will get an opportunity as Amazon Data engineer, Data consultant, Developer in cigniti, Mphasis , tech Mahindra, Accenture, cognizant, IBM and more.

This course contains main concepts Teradata Architecture, Logical Modeling, the Primary Index, Teradata Distributes and Retrieves, Secondary Indexes, Partitioned Tables, Space, Join Indexes, Active Data Warehousing, Teradata Hardware, Software and Security and more.

Teradata Course Syllabus

The Teradata Architecture

  • The Teradata Architecture
  • The Parsing Engine
  • The AMPs
  • Born to be parallel
  • The BYNET
  • Watch the Tera-Tom Video on Architecture
  • Collecting Statistics
  • Parsing Engine uses Statistics for the Plan
  • Columns and Indexes to Collect Statistics On
  • A Scalable Architecture
  • VProcs
  • Nodes and MPP
  • Watch the Tera-Tom Video on How AMPS store and process rows in Parallel

 Logical Modeling

  • Logical Modeling Primary and Foreign Keys
  • A Normalized Data Warehouse
  • Normalization
  • Dimensional Modeling also called Star Schema

The Primary Index

  • Physical Modeling – The Primary Index
  • Two Types of Primary Indexes (UPI or NUPI)
  • Unique Primary Index (UPI)
  • Non-Unique Primary Index (NUPI)
  • Multi-Column Primary Indexes
  • When do you define the Primary Index?
  • Watch the Tera-Tom Video on Primary Indexes

Teradata Distributes and Retrieves

  • How Teradata Distributes and Retrieves Data
  • How Teradata Distributes and Retrieves Rows
  • Hashing the Primary Index Value
  • The Hash Map
  • Laying a Row onto the Proper AMP
  • Retrieving a Row by way of the Primary Index
  • Placing Non-Unique Primary Indexes (NUPI) Rows
  • Non-Unique Primary Indexes Continued
  • Placing (NUPI) Rows Continued
  • Retrieving (NUPI) Rows
  • Even Distribution with an UPI
  • Uneven Distribution with a NUPI
  • Unacceptable Distribution with a NUPI
  • Big Trouble – A Picture of a Full Table Scan
  • A Visual for Data Layout
  • Watch the Tera-Tom Video on Data Placement
  • Bonus Video – Tera-Tom Video on the Row-ID
  • Test your Teradata Primary Index Knowledge

Secondary Indexes

  • The Secondary Index Sub table
  • USI – Always a Two-AMP Operation
  • USI Summary
  • Watch the Tera-Tom Video on Unique Secondary Indexes (USI)
  • NUSI Sub table is AMP-Local
  • NUSI Recap
  • Secondary Index Summary
  • Watch the Tera-Tom Video on Non-Unique Secondary Indexes (NUSI)

 Partitioned Tables

  • A Table used for our Partitioning Example
  • Range Queries
  • Why we had to perform a Full Table Scan
  • A Partitioned Table
  • A Partitioned Table
  • One Year of Orders Partitioned
  • Fundamentals of Partitioning
  • Add the Partition to the Row-ID for the Row Key
  • Multi-Level Partitioning
  • Partitioning Rules
  • Watch the Tera-Tom Video on Partitioning

Space

  • The most Powerful USER
  • DBC owns all the Disk Space
  • DBC Example of 1000 GBs
  • DBC will first CREATE a USER or a DATABASE
  • Teradata is Hierarchical
  • Only two Objects can Receive PERM Space
  • PERM, SPOOL and TEMP Space
  • Spool is like a Speed Limit
  • All Space is calculated on a Per AMP Basis
  • Watch the Tera-Tom Video on Space

  Join Indexes

  • Introduction to a Join Index
  • Join Index Fundamentals
  • A Multi-Table Join Index Example
  • Multi-Table Join Index Picture
  • Single-Table Join Index
  • Aggregate Join Index
  • Join Index Details to Remember
  • Watch the Tera-Tom Video on the Parody Teradata Query Search-Off

 Data Protection

  • Data Protection
  • Transaction Concept
  • Transient Journal
  • RAID 1 – Mirroring
  • Cliques
  • VProcs Migrate when a Node Fails
  • Cliques – An 8-Node Example
  • Hot Standby Nodes
  • Hot Standby Nodes in Action
  • FALLBACK Protection
  • How Fallback Works
  • Fallback Clusters Exercise
  • Fallback Clusters
  • The Six Rules of Fallback
  • Down AMP Recovery Journal (DARJ)
  • Permanent Journal
  • Permanent Journal Rules

Locking

  • The Four Locks of Teradata
  • Teradata has 3 levels of Locking
  • Locking Modifiers – The Access Lock
  • Locks and their compatibility

The Steps to Active Data Warehousing

  • The Active Data Warehouse
  • Operational Data Stores Vs the Data Warehouse
  • How is all Started – OLTP, DSS, OLCP, and OLAP
  • Data Marts
  • Distributed Data Warehousing – The Future
  • Watch the Tera-Tom Video on the Nexus Nerds
  • Centralized Data Warehousing

Teradata Hardware, Software and Security

  • Teradata V12 Platforms
  • Teradata V12 Operating Systems
  • A Typical Cabinet and Node
  • LAN Connection for Network Attached Clients
  • Mainframe Connection to Teradata
  • LDAP
  • Access Rights
  • Automatic, Implicit, and Explicit Rights
  • Roles
  • Profiles
  • Views
  • Macros
  • Stored Procedures
  • User Defined Functions (UDF)

Teradata Tools

  • Teradata Analyst Pack
  • Teradata Visual Explain Utility
  • TSET
  • Index Wizard
  • Statistics Wizard
  • Three Levels of Workload Management
  • Teradata Dynamic Workload Manager
  • Priority Scheduler Fundamentals
  • Priority Scheduler with Additional Partitions
  • Database Query Log (DBQL)
  • Teradata Workload Analyzer
  • Performance Monitor

Load Utilities

  • Teradata Load Utilities
  • Teradata Load Utilities Continued
  • BTEQ
  • The Four Types of BTEQ Exports
  • BTEQ IMPORT Script
  • FastLoad
  • FastLoad has Two Phases
  • A Sample FastLoad Script
  • The SmartScript FastLoad Builder
  • MultiLoad
  • A Sample MultiLoad Script
  • The SmartScript MultiLoad Builder
  • TPump
  • Limitations of TPump
  • A Sample TPump Script
  • The SmartScript TPump Builder
  • FastExport
  • Teradata Parallel Transport
  • TPT Operators and their Functions
  • TPT Operator Types
  • TPT Operators and their Equivalent Load Utility
  • How to Run a TPT Script