Teradata: Beginner Teradata 14

  • 16 Courses | 15h 13m 54s
  • 4 Books | 14h 5m
Likes 33
 
Whether it's Big Data, data warehousing or analysis, Teradata provides solutions for businesses. Come explore its technologies.

GETTING STARTED

Introducing SELECT Statement Queries

  • Playable
    1. 
    Overview of SQL for Teradata
    8m 14s
    NOW PLAYING
  • Playable
    2. 
    Overview of the Basic Teradata Query Utility
    5m 43s
    UP NEXT

COURSES INCLUDED

Introducing SELECT Statement Queries
Teradata supports the use of ANSI SQL to query data housed in a database system, and with ANSI SQL, it supports Teradata extensions. Discover how to use the SELECT statement to perform queries.
4 videos | 30m has Assessment available Badge
Working with Clauses, Operators, Expressions, & Aggregates
Learn how to work with clauses, operators, expressions, and aggregates in Teradata using ANSI SQL and Teradata extensions.
8 videos | 1h 1m available Badge
Performing Joins
Introduce yourself to joins in Teradata! Discover how to use ANSI SQL and Teradata extensions to perform a number of different joins, including inner, outer, self, and cross joins.
7 videos | 53m available Badge
Performing Subqueries & Correlated Subqueries
A subquery is simply a query contained within another query. Discover how to use ANSI SQL and Teradata extensions to perform subqueries and correlated subqueries in Teradata.
7 videos | 49m available Badge
Working with Functions, Times, Dates, & Intervals
Teradata supports the use of functions, expressions, and operators to perform operations on data. Explore attribute, string, and analytical functions, as well as times, dates, and intervals in Teradata.
14 videos | 1h 32m available Badge
Working with Data Conversions & SET Operations
You can use functions, expressions, and operators to perform operations on data in Teradata. Learn how to perform data conversions and computations, and use SET operators.
12 videos | 1h 3m available Badge
Working with Data Definition Language (DDL)
Teradata supports the use of SQLs data definition language (DDL) to create, modify, and remove objects in a database. Work with DDL to create and alter databases, tables, indexes, triggers, and more.
12 videos | 1h 31m available Badge
Working with DML, Optimization, & Temporal Concepts
Teradata supports the use of SQLs data manipulation language (DML) to retrieve, insert, update, and delete data in a database. Explore DDL and DML operations in a database or temporal tables.
15 videos | 1h 12m available Badge
Relational Database & Data Warehouse Basics
Teradata provides a relational database system that offers various tools and utilities for management, administration, and querying. Explore the basics of Teradata including what a data warehouse is along with its architecture and design.
14 videos | 1h 8m has Assessment available Badge
Relational Database Management System (RDBMS)
Teradata offers a high quality system using a parallel database architecture providing a "share nothing" architecture. Explore a relational database system and the hardware and software used by Teradata for the database architecture.
9 videos | 34m has Assessment available Badge
Client Communication
As with any RDBMS the database needs to be secure and accessible. Teradata is no exception and requires workstation and mainframe access. Explore the workstation and mainframe attachment communication methods.
5 videos | 22m has Assessment available Badge
Communication & Database Security
As with any RDBMS, the database needs to be secured to ensure only authorized users can access it. Discover workstation and mainframe attachment communication methods and how to configure users, profiles, and roles.
12 videos | 1h 10m has Assessment available Badge
Authentication & Security
As with any RDBMS, the database needs to be secured to ensure only authorized users can access it. Discover how to configure security, including logging on, views, macros, and UDFs.
8 videos | 42m has Assessment available Badge
Primary & Partitioned Indexes
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.
8 videos | 53m has Assessment available Badge
Secondary & Join Indexes
Teradata offers various types of indexes which can be used based on the type of data and how it is accessed by the users. Discover how to create the secondary and join indexes used by