Primary & Partitioned Indexes

Teradata 14    |    Beginner
  • 8 videos | 53m 14s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 12 users Rating 4.7 of 12 users (12)
Teradata databases use indexes to store and access rows of data from tables. Discover how to create the various primary and partitioned indexes used by Teradata.

WHAT YOU WILL LEARN

  • Describe how indexes are defined and used in teradata
    Identify the different types of indexes that can be used in teradata
    Describe the different types of primary indexes, upi, nupi, used in teradata and how data is processed with the index
    Describe a nopi object in teradata and when it is used, and its benefits
  • Describe ppi, and their advantages and disadvantages
    Create the different types of primary indexes in teradata
    Partition tables using nopi and ppi in teradata
    Describe and create column partitioning on teradata tables

IN THIS COURSE

  • 8m 10s
    After completing this video, you will be able to describe how indexes are defined and used in Teradata. FREE ACCESS
  • 11m 30s
    Learn how to identify the different types of indexes that can be used in Teradata. FREE ACCESS
  • Locked
    3.  Primary Indexes
    5m 42s
    Upon completion of this video, you will be able to describe the different types of primary indexes, UPI, and NUPI, used in Teradata and how data is processed with the index. FREE ACCESS
  • Locked
    4.  NoPI Objects
    4m 10s
    Upon completion of this video, you will be able to describe a NoPI object in Teradata, when it is used, and its benefits. FREE ACCESS
  • Locked
    5.  Partitioned Primary Index
    7m 59s
    Upon completion of this video, you will be able to describe PPI, and their advantages and disadvantages. FREE ACCESS
  • Locked
    6.  Creating Primary Indexes
    3m 45s
    In this video, you will learn how to create different types of primary indexes in Teradata. FREE ACCESS
  • Locked
    7.  Partitioning Tables
    6m 21s
    In this video, you will partition tables using Non-Partitioned Indexes (NPI) and Partitioned Primary Indexes (PPI) in Teradata. FREE ACCESS
  • Locked
    8.  Column Partitioned Tables
    5m 37s
    After completing this video, you will be able to describe and create column partitioning on Teradata tables. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Secondary & Join Indexes
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
Journey How to Transform Tables with SQL
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Channel Interskill Databases

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Book Teradata SQL
Course Azure Data Fundamentals: Non-relational Data Workloads
Rating 4.6 of 15 users Rating 4.6 of 15 users (15)
Course Working with DML, Optimization, & Temporal Concepts
Rating 4.7 of 15 users Rating 4.7 of 15 users (15)