Price: Check with seller


Teradata Training Course Syllabus

This Teradata training class was designed by an experienced Teradata Developers with many years of experience in BI and Datawarehousing. This Teradata training course can be taught using Version 12, 13, or 14.

  • The Rules of Data Warehousing

    • Teradata certification

    • A logical view of the teradata architecture

    • The Parsing Engine (PE)

    • The Access Module Processors (AMPs)

    • The BYNET

    • A visual for data layout

    • How Teradata handles data access

    • Teradata cabinets, nodes, Vprocs, and disks

    • Three types of parallelism with Teradata

    • Multi-step parallelism

    • Multi-statement parallelism

    • The active data warehouse

    • OLTP environments

    • The DSS environment

    • Teradata maximums

    • Teradata maximums per release

  • Data Layout: AutoMagically

    • Data distribution explained

    • Rows and columns

    • The primary index

    • The two types of primary indexes

    • Unique primary index (UPI)

    • Non-unique primary index

    • Data layout summary

  • Partition Primary Indexes

    • V2R5 partition primary indexes

    • V2R4 example

    • V2R5 partitioning

    • Partitioning doesn’t have to be part of the primary index

    • Partition elimination can avoid full table scans

    • The Bad NEWS about partitioning on a column that is not part of the Primary Index

    • Two ways to handle partitioning on a column that is not part of the Primary Index

    • Partitioning with CASE_N

    • Partitioning with RANGE_N


The Extended Logical Data Model

  • The application development life cycle

  • Asking the right questions

  • Logical data model

  • Primary keys

  • Foreign keys

  • Normalization

  • A normalized data warehouse

  • Dimensional modeling

  • Extended logical data model

  • The end goal of the ELDM is to build Table templates

  • Column ACCESS in the WHERE clause

  • Data demographics

  • Extended logical data model template

  • The physical data model

  • How to pick an excellent primary index

  • Denormalization

  • Derived data

  • Temporary tables

  • Derived tables

  • Volatile temporary tables

  • Global temporary tables

More Details

Total Views:8
Reference Id:#515421
Phone Number:8939915577
Website URL:Click To Visit
Current Rating: /5 0 Vote
Copyright © 2019 |   All Rights Reserved | |   24x7 support |   Email us : info[at]