Learning Teradata Vantage

Focused View

2:03:21

103 View

01 - Introduction

01 - Quick technology overview.mp4

05:58

02 - 1. Tables

01 - Teradata Vantage architecture.mp4

05:35

02 - Use cases for Teradata Vantage.mp4

04:58

03 - Downloading Teradata Vantage.mp4

03:05

04 - Setting up VMware Workstation Player.mp4

02:13

05 - Launching the Teradata Vantage Express VM.mp4

04:33

06 - Working with Teradata Studio.mp4

04:17

07 - Creating a database using a query.mp4

02:20

08 - Creating and populating a table.mp4

05:39

03 - 2. Connecting to Teradata from BTEQ

01 - Introducing the BTEQ utility.mp4

03:24

02 - Installing BTEQ on the host machine.mp4

04:16

03 - Connecting to Teradata Vantage in a VM.mp4

03:39

04 - Writing and running a script using BTEQ.mp4

04:12

04 - 3. Performing Operations on Tables in Teradata

01 - Setting up Teradata Studio on the host machine.mp4

05:08

02 - Adding columns to existing tables.mp4

05:05

03 - Modifying and removing data and tables.mp4

03:59

04 - Defining tables with the Data Transfer Utility.mp4

05:18

05 - Creating multiple related tables.mp4

03:19

05 - 4. Querying Data in Teradata

01 - Querying data in Teradata Vantage.mp4

05:16

02 - Applying different types of query filters.mp4

05:13

03 - Ordering query results.mp4

03:01

04 - Update and delete queries.mp4

04:30

05 - Performing aggregation operations.mp4

05:46

06 - Defining inner joins.mp4

04:23

07 - Performing left and right outer joins.mp4

05:43

06 - 5. Querying Data in Teradata

01 - Installing Anaconda.mp4

02:39

02 - Setting up teradatasqlalchemy.mp4

03:10

03 - Performing read and write operations from Python.mp4

05:57

07 - Conclusion

01 - Summary and next steps.mp4

00:45

Description

Explore Teradata, a powerful analytics tool, with an example Python application. Instructor Kishan Iyer walks you through the basics of Teradata Vantage, plus tables, connections, performing operations, and querying data. Kishan explains several advantages of using Teradata Vantage. He shows you the architecture of Teradata Vantage, as well as setting up and launching the Teradata Vantage Express VM, creating a Teradata database, and creating and adding rows to a Teradata table. Kishan goes over the full process of connecting to Teradata from the BTEQ command-line utility. He demonstrates adding columns to existing tables, modifying and removing data and tables, defining tables with the Data Transfer Utility, and creating multiple related tables. Kishan also covers querying data in Teradata, including applying query filters, updating and deleting queries, performing operations from Python, and more.

Note: This course was created by Kishan Iyer. We are pleased to host this training in our library.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Python

Data Analysis

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.