• Post category:StudyBullet-14
  • Reading time:5 mins read

Teradata Database Administration – Basics. Teradata Studio, SQL Concepts (Joins, Group By etc)

What you will learn

Understanding to Teradata Studio

Basics of Teradata Database Administration

Teradata SQL, DDL, DML – SELECT statement and Clauses

User Management, Access Rights Management


Teradata is a closed box technology and even after spending hours of search you don’t get desired results for your query especially in perspective of database administration. Keeping that in view, this course is designed to address day to day database administration related issues in a pin point manner.

A detailed overview right from downloading the virtual machine and configuration for building a test environment and loading sample data into that machine for practice.

Get Instant Notification of New Courses on our Telegram channel.

This course is about key concepts of Teradata Database Administrations. Day to day DBAย related tasks are covered in depth. It is covering the usage of Teradata Utilities like BTEQ, Fast load primarily used by Teradata developers. It covers in depth concepts of SQLย to write query for data extraction from single table / multiple tables using JOINS which helps generating reports. Group by and where clause are well covered in this course. Further it is covering in depth knowledge of Logging / Monitoring in Teradata. How to enable / disable query logging on objects to monitor the activities performed on / by objects. DBQLs are covered which are used for trouble shooting / capacity planning. After completion of this course you can claim yourself an operational Database Administrator with the capability of handling day to day Teradata DBAย tasks in a prefect manner.



Installation & Configuration

VMWare Installation
Hosting Teradata Vantage Express in VMWare Player
Teradata Studio Overview
Teradata Viewpoint Configuration
Adding Teradata System to Viewpoint for Monitoring
PDCR (Performance Data Collection Report) Configuration
PDCR (Performance Data Collection Report)
Managing Teradata Studio Connection Profile

Teradata Utilities (BTEQ and Fast Load) – Loading Sample Data into Teradata Data

Introduction to BTEQ (A Teradata Utility)
Introduction to Fast Load
Creating Database – Create Table
Fast Load Scripting
Loading Sample Data using FastLoad utility

User Management

User Management Overview using Teradata Studio
User Profile Management using Teradata Studio
User Locking / Unlocking
User Access Rights Management using Access Roles
Assigning Multiple Roles To User
Setting Default Role to User

Teradata SQL

Introduction to SELECT
Create Table
Create Database / Table using BTEQ
SQL Joins – Joining Data from Multiple Tables
DDLs (Data Definition Language) / DML (Data Manipulation Language)
Deploying Views

Logging & Monitoring

Access Logging
Enabling / Disabling Query Logging
DBQLs (Database Query Logs)
Viewpoint (Teradata Monitoring Tool)
Dictionary Tables (DBC Tables)