Your Career
Training Marketplace

Sign in SIGN UP FREE
Browse Catalog
Business Skills
All Your Business Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Finance
All Your Finance Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Health Care
All Your Health Care Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Human Resources
All Your Human Resources Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Industrial
All Your Industrial Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Information Technology
All Your IT Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Legal
All Your Legal Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677

Questions? Call Toll-Free: 1-866-540-9677

Business Skills
All Your Business Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Finance
All Your Finance Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Health Care
All Your Health Care Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Human Resources
All Your Human Resources Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Industrial
All Your Industrial Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Information Technology
All Your IT Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Legal
All Your Legal Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677

Course ID: 309867

Video Collection

Teradata Video Collection

When you register for training with TrainUp.com, you are also supporting local education. Find out how.

In-Person Group Onsite Info

This Video Collection Contains 155 Videos. View All Titles.

Teradata Video Collection

This Teradata Video Collection e-learning and video micro-learning bundle contains 155 videos to enhance your skills. Courses are instantly accessible after purchase, viewing is unlimited, and you get 6 month-access to the library.

What is eLearning?

eLearning is a topical piece of online training material that is available to learn at your convenience. It is typically delivered in the form of videos or an interactive presentation, conducted via electronic media, through the web. eLearning courses are accessible on demand through your My Training Portal. Learn it when you need it!

Contents

155 Videos

COLLECTION PRICE

$199.00

View Courses

Looking for Group eLearning Options?

Instant Access
From Anywhere
Unlimited
Viewing
6-12 Months
To Complete

When you register for training with TrainUp.com, you are also supporting local education. Find out how.

Browse Videos Included In This Collection

Teradata SQL: Creating Basic Tables

After watching this video, you will be able to create a table in Teradata using the CREATE TABLE statement.
Teradata SQL: Creating Advanced Tables

After watching this video, you will be able to create a table in Teradata using the CREATE TABLE statement which includes defining an index, column definitions, and table options.
Teradata SQL: Creating and Altering Databases

After watching this video, you will be able to create and alter a database in Teradata.
Teradata SQL: Creating and Managing Database Users

After watching this video, you will be able to create and manage database users for Teradata.
Teradata SQL: Altering Tables

After watching this video, you will be able to alter, manage, and drop tables in Teradata.
Teradata SQL: Using INTERSECT

After watching this video, you will be able to use the INTERSECT set operator in Teradata.
Teradata SQL: Using Set Operators in Advanced Queries

After watching this video, you will be able to use set operators in derived tables, subqueries, and SELECT...INSERT statements in Teradata.
Teradata SQL: Using Teradata Functions

After watching this video, you will be able to use functions, expressions, and operations in Teradata to work with data.
Teradata SQL: Using MINUS and EXCEPT

After watching this video, you will be able to use the MINUS and EXCEPT set operators in Teradata.
Teradata SQL: Using Union

After watching this video, you will be able to use the UNION set operator in Teradata.
Teradata SQL: Using NORMALIZED

After watching this video, you will be able to use NORMALIZED in a SELECT statement in Teradata.
Teradata SQL: Using the EXPAND ON Clause

After watching this video, you will be able to use the EXPAND ON clause in a SELECT statement in Teradata.
Teradata SQL: Altering Functions and Procedures

After watching this video, you will be able to alter, rename, and drop functions and stored procedures in Teradata.
Teradata SQL: Using the QUALIFY Clause

After watching this video, you will be able to use the QUALIFY clause in Teradata.
Teradata SQL: Creating and Altering Indexes

After watching this video, you will be able to create and alter indexes in Teradata.
Teradata SQL: Creating and Altering Views

After watching this video, you will be able to create and alter views in Teradata.
Teradata SQL: Creating Triggers

After watching this video, you will be able to create triggers in Teradata.
Teradata SQL: Creating Procedures

After watching this video, you will be able to create procedures in Teradata.
Teradata SQL: Creating Recursive Views

After watching this video, you will be able to create recursive views in Teradata.
Teradata SQL: Creating Macros

After watching this video, you will be able to create macros in Teradata.
Teradata SQL: Performing DDL on Temporal Tables

After watching this video, you will be able to perform DDL operations using their temporal form in Teradata.
Teradata SQL: Creating Temporal Tables

After watching this video, you will be able to create temporal tables in Teradata.
Teradata SQL: Loading Data into Temporal Tables

After watching this video, you will be able to load data into temporal tables in Teradata.
Teradata SQL: Using the UPDATE Statement

After watching this video, you will be able to use the UPDATE statement to update data in Teradata.
Teradata SQL: Using the DELETE Statement

After watching this video, you will be able to use the DELETE statement to remove data from Teradata.
Teradata SQL: Using the INSERT Statement

After watching this video, you will be able to use the INSERT statement to insert data into Teradata.
Teradata SQL: Improving Performance of Merge Joins

After watching this video, you will be able to identify how to improve the performance of merge joins in Teradata.
Teradata SQL: Overview of Temporal Concepts

After watching this video, you will be able to describe the basic temporal concepts in Teradata.
Teradata SQL: Using MERGE

After watching this video, you will be able to use MERGE to merge data into a table in Teradata.
Teradata SQL: Optimizing Query Design

After watching this video, you will be able to identify how to optimize query design in Teradata.
Teradata SQL: Performing DML on Temporal Tables

After watching this video, you will be able to perform DML operations using their temporal form in Teradata.
Teradata SQL: Performing DDL and DML in Teradata

After watching this video, you will be able to perform DDL and DML operations on regular and temporal tables in Teradata.
Teradata SQL: Performing Multitable Joins

After watching this video, you will be able to perform multitable joins in Teradata.
Teradata SQL: Performing Subqueries in Search Conditions

After watching this video, you will be able to perform subqueries in the search condition of a WHERE clause.
Teradata SQL: Performing Scalar Subqueries

After watching this video, you will be able to perform scalar subqueries to return results from Teradata.
Teradata SQL: Overview of the Types of Subqueries

After watching this video, you will be able to describe subqueries, scalar subqueries, and correlated subqueries, and how they are used in Teradata to retrieve results.
Teradata SQL: Performing Subqueries in a SELECT Statement

After watching this video, you will be able to perform basic subqueries in a SELECT statement to return results from Teradata.
Teradata SQL: Performing Theta Joins

After watching this video, you will be able to perform theta joins in Teradata.
Teradata SQL: Performing Inner Joins

After watching this video, you will be able to perform inner joins in Teradata.
Teradata SQL: Overview of Joins

After watching this video, you will be able to describe the different types of joins that can be performed in Teradata.
Teradata SQL: Performing Natural Joins

After watching this video, you will be able to perform natural joins in Teradata.
Teradata SQL: Performing Outer Joins

After watching this video, you will be able to perform outer joins in Teradata.
Teradata SQL: Performing Self Joins and Cross Joins

After watching this video, you will be able to perform self joins and cross joins in Teradata.
Teradata SQL: Using Attribute Functions

After watching this video, you will be able to use attribute functions to return descriptive information about their operand in Teradata.
Teradata SQL: Using String Functions

After watching this video, you will be able to use string functions to perform operations on strings of data in Teradata.
Teradata SQL: Using CASE Expressions

After watching this video, you will be able to use CASE expressions to evaluate a set of expressions in Teradata.
Teradata SQL: Using Calendar Functions

After watching this video, you will be able to use calendar functions to work with dates, months, and years in Teradata.
Teradata SQL: Using Regular Expression Functions

After watching this video, you will be able to use regular expression functions on data in Teradata.
Teradata SQL: Using Analytical Functions

After watching this video, you will be able to use the analytical functions in Teradata.
Teradata SQL: Using the SELECT Statement

After watching this video, you will be able to use the SELECT statement to perform queries, including performing joins and subqueries.
Teradata SQL: Overview of Functions and SQL Operators

After watching this video, you will be able to identify the different types of functions in Teradata and how expressions and SQL operators are used.
Teradata SQL: Performing Correlated Subqueries

After watching this video, you will be able to perform correlated subqueries to return results from Teradata.
Teradata SQL: Using Derived Tables

After watching this video, you will be able to create and use derived tables in Teradata.
Teradata SQL: Using Arithmetic Functions

After watching this video, you will be able to use arithmetic functions and operators on data in Teradata.
Teradata SQL: Overview of SQL for Teradata

After watching this video, you will be able to describe SQL and how it can be used in Teradata.
Teradata SQL: Using GROUPING SETS, ROLLUP, and CUBE

After watching this video, you will be able to use GROUPING SETS, ROLLUP, and CUBE to analyze data across a dimension in Teradata.
Teradata SQL: Using the WITH clause

After watching this video, you will be able to use the WITH clause in a SELECT statement in Teradata.
Teradata SQL: Using TOP, SAMPLE and SAMPLEID

After watching this video, you will be able to use TOP, SAMPLE, and the SAMPLEID expression in a SELECT statement to limit results in Teradata.
Teradata SQL: Using Aggregations

After watching this video, you will be able to use MIN, MAX, COUNT, AVG, SUM aggregates in a SELECT statement in Teradata.
Teradata SQL: Performing Basic SELECT Statements

After watching this video, you will be able to perform basic SELECT statements in Teradata.
Teradata SQL: Performing Basic WHERE Clause Searches

After watching this video, you will be able to use basic WHERE clause in a SELECT statement to perform conditional queries in Teradata.
Teradata SQL: Overview of the Basic Teradata Query Utility

After watching this video, you will be able to launch and use the BTEQ command line tool and identify how it is used as a query management tool.
Teradata SQL: The SELECT Statement

After watching this video, you will be able to describe the different clauses in a SELECT statement.
Teradata SQL: Using the GROUP BY and HAVING Clauses

After watching this video, you will be able to use the GROUP BY and HAVING clauses to perform grouping in query results in Teradata.
Teradata SQL: Performing Advanced WHERE Clause Searches

After watching this video, you will be able to perform advanced WHERE clause searches in a SELECT statement to limit results in Teradata.
Teradata SQL: Using the ORDER BY Clause

After watching this video, you will be able to use the ORDER BY clause in a SELECT statement to perform a query in Teradata.
Teradata SQL: Using DateTime and Interval Functions (Part 2)

After watching this video, you will be able to use the different DateTime and Interval functions, LAST_DAY, NEXT_DAY, TRUNC, ROUND, EXTRACT in Teradata.
Teradata SQL: Overview of Data Type Conversions

After watching this video, you will be able to identify the three ways data types are converted in Teradata.
Teradata SQL: Using DateTime and Interval Functions (Part 1)

After watching this video, you will be able to use the different DateTime and Interval functions, ADD_MONTHS, OADD_MONTHS, AND MONTHS_BETWEEN in Teradata.
Teradata SQL: Using Data Type Conversion Functions (Part 1)

After watching this video, you will be able to use data type conversion functions to convert characters in Teradata with CAST.
Teradata SQL: Using Data Type Conversion Functions (Part 2)

After watching this video, you will be able to use data type conversion to convert numbers, times, and intervals in Teradata with CAST.
Teradata SQL: Understanding Implicit Type Conversions

After watching this video, you will be able to identify when implicit data conversion is performed and what the supported data types are.
Teradata SQL: Overview of Using CAST

After watching this video, you will be able to identify the syntax and rules for using CAST to perform data conversions in Teradata.
Teradata SQL: Using Arithmetic DateTime and Interval Functions

After watching this video, you will be able to use arithmetic operators, ANSI DateTime, and Interval Data Types in Teradata.
Teradata SQL: Using Scalar Operations and DateTime Functions

After watching this video, you will be able to use scalar operations with DateTime functions to work with dates and times in Teradata.
Teradata SQL: Using ANSI DateTime Expressions

After watching this video, you will be able to use ANSI DateTime expressions to do computations with Time Zones and interval values in Teradata.
Teradata SQL: Using ANSI Interval Expressions

After watching this video, you will be able to use ANSI Interval expressions to perform calculations on Interval values in Teradata.
Teradata SQL: Overview of Using Set Operators

After watching this video, you will be able to describe the set operators, their syntax, and order precedence for use in Teradata.
Teradata SQL: Using Data Type Conversion Functions

After watching this video, you will be able to identify and use the data type conversion functions to convert data in Teradata.
Teradata Basics: Teradata Virtual Storage

After watching this video, you will be able to describe Teradata virtual storage, its benefits, and considerations.
Teradata Basics: Intelligent Memory

After watching this video, you will be able to identify how Teradata uses intelligent memory.
Teradata Basics: Request Processing

After watching this video, you will be able to describe how Teradata performs request processing using the dispatcher and AMPs.
Teradata Basics: The Teradata Database and Architecture

After watching this video, you will be able to identify and describe the Teradata database and architecture concepts.
Teradata Basics: Components of a Teradata Architecture

After watching this video, you will be able to identify the main components of a Teradata architecture.
Teradata Basics: The Parsing Engine

After watching this video, you will be able to describe the parsing engine in a Teradata database.
Teradata Basics: The BYNET

After watching this video, you will be able to describe the BYNET and how it is used in a Teradata database.
Teradata Basics: The Access Module Processor

After watching this video, you will be able to describe AMPs and how they are used in a Teradata database.
Teradata Basics: The Normalization Process

After watching this video, you will be able to describe the normalization process.
Teradata Basics: The Teradata Database Capabilities

After watching this video, you will be able to identify the capabilities of a Teradata database, its software, and tools.
Teradata Basics: Overview of Teradata Database Security

After watching this video, you will be able to identify the security elements used in a Teradata database.
Teradata Basics: Overview of Database Privileges and Roles

After watching this video, you will be able to identify the different database privileges and roles in Teradata.
Teradata Basics: User Authentication

After watching this video, you will be able to identify the authentication methods, logon format and controls, and password format requirements.
Teradata Basics: The JDBC Driver for Teradata

After watching this video, you will be able to describe how the JDBC driver for Teradata is used for workstation attached systems.
Teradata Basics: The OLE DB Provider for Teradata

After watching this video, you will be able to describe the OLE DB data provider for Teradata workstation attached systems.
Teradata Basics: Overview of Database Objects

After watching this video, you will be able to identify the different objects within a Teradata database.
Teradata Basics: Defining Databases and Users

After watching this video, you will be able to describe Teradata databases and users.
Teradata Basics: Workstation Attachment Methods

After watching this video, you will be able to identify the workstation attachment methods used to connect clients to a Teradata database.
Teradata Basics: Mainframe Attachment Methods

After watching this video, you will be able to describe Teradata's mainframe attachment method that provides the interface between applications and TDP on a mainframe client.
Teradata Basics: The ODBC Driver for Teradata

After watching this video, you will be able to describe how the ODBC driver for Teradata is used for workstation attached systems.
Teradata Basics: Overview of a Data Warehouse

After watching this video, you will be able to describe what a data warehouse is and how it is used with Teradata.
Teradata Basics: The Active Data Warehouse

After watching this video, you will be able to describe an active data warehouse in Teradata.
Teradata Basics: Overview of Teradata

After watching this video, you will be able to identify what Teradata has to offer.
Teradata Basics: Entities, Attributes, and Relationships

After watching this video, you will be able to identify entities, attributes, and relationships in an E-R logical model.
Teradata Basics: Data Warehouse Design Overview

After watching this video, you will be able to identify the database design life cycle and how logical data modeling is completed.
Teradata Basics: The Three-Schema Architecture

After watching this video, you will be able to describe the three-schema architecture.
Teradata Basics: The Logical Data Model Frameworks

After watching this video, you will be able to identify the Teradata logical data model frameworks and their pros and cons.
Teradata Basics: Semantic Data Modeling Overview

After watching this video, you will be able to describe performing entity relationships analysis for semantic data modeling.
Teradata Basics: The Relational Database System

After watching this video, you will be able to describe the concepts of a relational database system and its terminology.
Teradata Basics: The Data Warehouse Architectures

After watching this video, you will be able to describe the goals of a Teradata data warehouse and its architecture.
Teradata Basics: Data Marts

After watching this video, you will be able to describe data marts and when they are appropriate to use with Teradata.
Teradata Basics: The Enterprise Data Model

After watching this video, you will be able to describe the enterprise data model.
Teradata Basics: Teradata Active Solutions

After watching this video, you will be able to describe Teradata active solutions.
Teradata Basics: Creating Secondary Indexes

After watching this video, you will be able to create USI and NUSI in Teradata.
Teradata Basics: Types of Join Indexes

After watching this video, you will be able to identify the different types of join indexes that can be used in Teradata.
Teradata Basics: Uses and Storage of Join Indexes

After watching this video, you will be able to identify when to use a join index in Teradata and their storage.
Teradata Basics: Creating Join Indexes

After watching this video, you will be able to create join indexes in Teradata.
Teradata Basics: Partitioning Tables

After watching this video, you will be able to partition tables using NoPI and PPI in Teradata.
Teradata Basics: Column Partitioned Tables with Columnar

After watching this video, you will be able to describe and create column partitioning on Teradata tables.
Teradata Basics: Types of Secondary Indexes

After watching this video, you will be able to describe secondary index use in a Teradata Database.
Teradata Basics: Data Access with Secondary Indexes

After watching this video, you will be able to describe data accessing using USI and NUSI in Teradata databases.
Teradata Basics: Partitioned Primary Index

After watching this video, you will be able to describe PPI, and their advantages and disadvantages.
Teradata Basics: Creating Primary Indexes

After watching this video, you will be able to create the different types of primary indexes in Teradata.
Teradata Basics: Logging on Using Database Authentication

After watching this video, you will be able to login to a Teradata database using database authentication and authorization.
Teradata Basics: Logging on Using LDAP Authentication

After watching this video, you will be able to login to a Teradata database using LDAP authentication and authorization
Teradata Basics: Creating Roles

After watching this video, you will be able to create roles in Teradata.
Teradata Basics: Granting Privileges Directly to Users

After watching this video, you will be able to grant privileges directly to users in Teradata.
Teradata Basics: Managing Database Passwords

After watching this video, you will be able to manage Teradata database passwords.
Teradata Basics: About Logging on to Teradata

After watching this video, you will be able to describe the login techniques and elements for logging on to Teradata.
Teradata Basics: Data Protection

After watching this video, you will be able to identify how Teradata protects data in a database.
Teradata Basics: Creating a Teradata Database

After watching this video, you will be able to create a Teradata database.
Teradata Basics: Creating Users in Teradata

After watching this video, you will be able to create a user in Teradata.
Teradata Basics: Creating Profiles

After watching this video, you will be able to create profiles in Teradata.
Teradata Basics: NoPI Objects

After watching this video, you will be able to describe a NoPI object in Teradata and when it is used, and its benefits.
Teradata Basics: Overview of Indexes in Teradata

After watching this video, you will be able to describe how indexes are defined and used in Teradata.
Teradata Basics: Overview of the Types of Indexes

After watching this video, you will be able to identify the different types of indexes that can be used in Teradata.
Teradata Basics: Primary Indexes

After watching this video, you will be able to describe the different types of primary indexes, UPI, NUPI, used in Teradata and how data is processed with the index.
Teradata Basics: Using Views

After watching this video, you will be able to create and use views to implement security measures in Teradata.
Teradata Basics: Using Macros

After watching this video, you will be able to create and use macros to implement security measures in Teradata.
Teradata Basics: Using UDFs

After watching this video, you will be able to create and use UDFs to implement security measures in Teradata.
Teradata Basics: Communication and Database Security

After watching this video, you will be able to describe and implement client communication and database security for a Teradata database.
Teradata Basics: Logging on Using Single Sign-on and Sign-on AS

After watching this video, you will be able to login to a Teradata database using single sign-on and sign-on AS.
Teradata Basics: Locking Considerations

After watching this video, you will be able to identifying the locking conderations in a Teradata database.
Teradata Basics: Two-Phasing Locking and Serializability

After watching this video, you will be able to describe how the two-phase locking and serializability works in Teradata.
Teradata Basics: Using the LOCKING Request Modifier

After watching this video, you will be able to use the LOCKING request modifier in a Teradata SQL read operation.
Teradata Basics: Understanding Deadlocks

After watching this video, you will be able to describe a deadlock and how they are handled in a Teradata database.
Teradata Basics: Using EXPLAIN to Determine Index Usefulness

After watching this video, you will be able to use the EXPLAIN request modifiers to determine the usefulness of indexes in a Teradata database.
Teradata Basics: Full-Table Scans

After watching this video, you will be able to identify when and how a full-table scan is used to access data in Teradata tables.
Teradata Basics: Using Indexes or Full-Table Scans

After watching this video, you will be able to identify SQL queries that will use an index or perform a full-table scan in Teradata.
Teradata Basics: Overview of Locking

After watching this video, you will be able to describe how Teradata uses locking and the different types of locks.
Teradata Basics: Overview of Cliques and Hot Standby Nodes

After watching this video, you will be able to describe how cliques, hot standby, and RAID are used for data protection in Teradata.
Teradata Basics: Overview of RAID

After watching this video, you will be able to describe how RAID is used for data protection in Teradata.
Teradata Basics: Create Indexes and Use Locking

After watching this video, you will be able to create the different types of indexes for a Teradata database, use locking, and describe performance availability features.
Teradata Basics: Overview of Fallback and Journals

After watching this video, you will be able to describe how fallback and journaling are used for data protection in Teradata.
Teradata Basics: Managing Space

After watching this video, you will be able to describe how perm, spool, and TEMP are used to manage space for a user.
Teradata Basics: Estimating Space Requirements

After watching this video, you will be able to estimate space requirements in Teradata.

Join The 50,000+ Companies That Have Purchased Training from TrainUp.com

50K+ Companies Trained
Including 90% Of Fortune 500 Companies Have Purchased Training With TrainUp.com
300K+ Courses & Videos
Live Instructor-Led (Classroom & Virtual), Self-Paced E-learning & Custom OnSite Training Solutions From Leading Training Providers
800+ Expert Instructors
Industry-Leading Subject Matter Experts (SMEs).Tenured &
Award-Winning Instructor Network

Terms and Conditions

Please read these Terms and Conditions carefully before using Capital One Spring member exclusives (the “Service”) at TrainUp.com.

Your access to and use of the Service is conditioned upon your acceptance of and compliance with these Terms. These Terms apply to all Capital One Spring members who wish to access or use the Service and by accessing or using the Service you agree to be bound by these Terms.

This site uses cookies. We will never sell or rent your information. By signing up for a TrainUp.com account as a Capital One Spring member, you will receive emails in relationship to your content registration and monthly updates. You will only receive emails from TrainUp.com and never a third-party source.

By signing up for a free TrainUp.com account you will be asked to provide basic information about yourself and company, If you wish to purchase any product or service made available through the Service, you may be asked to supply certain additional information relevant to your purchase.

The Service may employ the use of third-party services to allow access to course contents. By submitting your information, you grant us the right to provide the information to these third parties as needed to support your use of the service.

You acknowledge and agree that TrainUp.com shall not be responsible or liable, directly or indirectly, for any damage or loss caused or alleged to be caused by or in connection with use of or reliance on any such content, goods or services available on or through any such third party web sites or services.

We may terminate or suspend your account and bar access to the service immediately, without prior notice or liability, under our sole discretion, for any reason whatsoever and without limitation, including but not limited to a breach of the Terms. If you wish to terminate your account, you may simply discontinue using the service.