Learning Teradata Vantage
2h 3mAdvanced2022-08-26
Authors

Kishan Iyer
Content Engineer, DevOps Expert, and Google Cloud Platform Power User
Course details
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.
Skills covered
TeradataAdvancedDatabase DevelopmentDatabase ManagementSoftware Development
Concepts
0. Introduction
- 01 - Quick technology overview
1. Tables
- 02 - Teradata Vantage architecture
- 03 - Use cases for Teradata Vantage
- 04 - Downloading Teradata Vantage
- 05 - Setting up VMware Workstation Player
- 06 - Launching the Teradata Vantage Express VM
- 07 - Working with Teradata Studio
- 08 - Creating a database using a query
- 09 - Creating and populating a table
2. Connecting to Teradata from BTEQ
- 10 - Introducing the BTEQ utility
- 11 - Installing BTEQ on the host machine
- 12 - Connecting to Teradata Vantage in a VM
- 13 - Writing and running a script using BTEQ
3. Performing Operations on Tables in Teradata
- 14 - Setting up Teradata Studio on the host machine
- 15 - Adding columns to existing tables
- 16 - Modifying and removing data and tables
- 17 - Defining tables with the Data Transfer Utility
- 18 - Creating multiple related tables
4. Querying Data in Teradata
- 19 - Querying data in Teradata Vantage
- 20 - Applying different types of query filters
- 21 - Ordering query results
- 22 - Update and delete queries
- 23 - Performing aggregation operations
- 24 - Defining inner joins
- 25 - Performing left and right outer joins
5. Querying Data in Teradata
- 26 - Installing Anaconda
- 27 - Setting up teradatasqlalchemy
- 28 - Performing read and write operations from Python
Conclusion
- 29 - Summary and next steps
Related courses
- Linux Performance Tuning
- Learning MongoDB
- Microsoft Entra ID for Developers: A Beginner's Guide (2023)
- Introduction to SQLite
- Learning BIM 360 Building Ops
- Learning Power Automate Desktop for Non-Developers
- The OWASP API Security Top 10: An Overview
- Azure VMware Solution: Planning and Troubleshooting Basics