Teradata

Today all databases are failed for Big Data warehouse. Teradata is only database which sustain in market because of it speed and linear scalability. Most of the global airlines using teradara .good number of global financial organizations are using teradara. Most of the global retailers use teradata.

Syllabus:

• Teradata Basics
• 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
• 1. Logical Modeling
• Logical Modeling – Primary and Foreign Keys
• A Normalized Data Warehouse
• Normalization
• Dimensional Modeling also called Star Schema 
• 2. 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
• 3. 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
• 4. Secondary Indexes
• Secondary Indexes
• The Secondary Index Subtable
• 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)
•  
• 5. 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
• and more.