Teradata

by Radical Technologies Claim Listing

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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Radical Technologies Logo

img Duration

Please Enquire

Course Details

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.
  • Kochi Branch

    Office No 44/71,44/72 , KP Varkey Complex MKK Nair Road, PO, Kochi
  • Pune Branch

    4th Floor, Medhi Park, DP Rd, above Bata Showroom, opposite Shiv Sagar Hotel, Harmony Society, Ward No. 8, Wireless Colony, Aundh, Pune
  • Thrissur Branch

    Suharsha Towers, 2nd, Complex, Thrissur

Check out more Teradata courses in India

JKSkillhub Institute Logo

MySQL Course

Embark on a transformative learning journey with our best MYSQL course, spanning over 3 months. Tailored for beginners, this program equips you with essential skills in Structured Query Language (SQL). Dive into the basics of database management, mastering the art of data retrieval and manipulation...

by JKSkillhub Institute [Claim Listing ]
  • Price
  • Start Date
  • Duration
Achievers Academy Logo

MS SQL Server

Achiever Academy one of the best SQL Server Training Center in Gurgaon India. Who Provides Complete MS SQL Server Certification Training Solutions like SQL Server Corporate Training in Amritsar India, Classroom Training, Boot Camp Training etc.

by Achievers Academy [Claim Listing ]
ZebLearn Logo

MySQL Training

Master MySQL with Zeblearn's specialized training program. Learn to design, administer, and optimize MySQL databases for various applications. Gain hands-on experience in SQL queries, database design, indexing, replication, and performance tuning.

by ZebLearn [Claim Listing ]
Axcel Computer Learning Institute Logo

Oracle

Oracle course is offered by Axcel Computer Learning Institute. Axcel Computer Learning Institute is a leading computer learning Institute operating from Mapusa Goa providing complete training for students who wish to learn the latest technology.

by Axcel Computer Learning Institute [Claim Listing ]
LearnoVita Logo

Oracle Admin Training

Oracle admin was one of the most in-demand technologies and it is ranked as the world’s most popular programming language among professional software developers as well as the first most wanted programming language. Learn Oracle admin in real-time with LearnoVita experts practically with live tra...

by LearnoVita [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy