Teradata: beginner Teradata 14
- 16 Courses | 15h 6m 13s
- 4 Books | 14h 5m
Whether it's Big Data, data warehousing or analysis, Teradata provides solutions for businesses. Come explore its technologies.
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
Assessment
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
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
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
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 31m
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 2m
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
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 11m
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
Assessment
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
Assessment
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
Assessment
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 9m
Assessment
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 |
41m
Assessment
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
Assessment
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 Teradata.
9 videos |
47m
Assessment
Badge
Locking & Data Protection
To control concurrency, Teradata uses different locking mechanisms. Discover the different locking mechanisms and performance availability features, such as RAID, failover, cliques, and hot standby.
11 videos |
57m
Assessment
Badge
SHOW MORE
FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES
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.BOOKS INCLUDED
Book
V14 Certification: Teradata SQLDesigned to boost both your confidence and knowledge, this book will not only help you pass the V14 certification exam, but is also an incredible reference guide, learning tool, and foundation for passing all tests required for becoming a Teradata Certified Master.
4h 21m
By Leona Coffing, Tom Coffing
Book
V14 Certification: Teradata BasicsWith an aim to boost your level of confidence and knowledge, this book provides an incredible reference guide, learning tool, and foundation for passing all the tests and becoming a Teradata Certified Master.
3h 9m
By John Nolan, Tom Coffing
Book
Teradata SQL Quick Reference Guide: Simplicity by Design, Second EditionAsking the right questions is half the battle to greatly impacting the company's bottom line. Dedicated to assisting users in asking the right questions, this concise reference details the commands, syntax, hints, troubleshooting, and examples of SQL.
2h 7m
By Michael Larkins, Steve Wilmes, Tom Coffing
Book
Teradata SQLWith a step-by-step building block approach, this book starts at the most basic level, then moves to the most advanced level with over 1,000 examples that work and explain exactly what is going on.
4h 28m
By Mike Larkins, Tom Coffing
SHOW MORE
FREE ACCESS
