Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
Learning Teradata Vantage

Learning Teradata Vantage

2h 3mAdvanced2022-08-26

Authors

Kishan Iyer

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

Related learn paths

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
zarinpal
zibal