Teradata Database Administrator

Teradata Database Administrator, available at $49.99, has an average rating of 4.3, with 33 lectures, based on 19 reviews, and has 2075 subscribers.

You will learn about Understanding to Teradata Studio Basics of Teradata Database Administration Teradata SQL, DDL, DML – SELECT statement and Clauses User Management, Access Rights Management This course is ideal for individuals who are Beginners It is particularly useful for Beginners.

Enroll now: Teradata Database Administrator

Summary

Title: Teradata Database Administrator

Price: $49.99

Average Rating: 4.3

Number of Lectures: 33

Number of Published Lectures: 33

Number of Curriculum Items: 33

Number of Published Curriculum Objects: 33

Original Price: $34.99

Quality Status: approved

Status: Live

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

Who Should Attend

Beginners

Target Audiences

Beginners

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.

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.

Course Curriculum

Chapter 1: Installation & Configuration

Lecture 1: VMWare Installation

Lecture 2: Hosting Teradata Vantage Express in VMWare Player

Lecture 3: Teradata Studio Overview

Lecture 4: Teradata Viewpoint Configuration

Lecture 5: Adding Teradata System to Viewpoint for Monitoring

Lecture 6: PDCR (Performance Data Collection Report) Configuration

Lecture 7: PDCR (Performance Data Collection Report)

Lecture 8: Managing Teradata Studio Connection Profile

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

Lecture 1: Introduction to BTEQ (A Teradata Utility)

Lecture 2: Introduction to Fast Load

Lecture 3: Creating Database – Create Table

Lecture 4: Fast Load Scripting

Lecture 5: Loading Sample Data using FastLoad utility

Chapter 3: User Management

Lecture 1: User Management Overview using Teradata Studio

Lecture 2: User Profile Management using Teradata Studio

Lecture 3: User Locking / Unlocking

Lecture 4: User Access Rights Management using Access Roles

Lecture 5: Assigning Multiple Roles To User

Lecture 6: Setting Default Role to User

Chapter 4: Teradata SQL

Lecture 1: Introduction to SELECT

Lecture 2: Create Table

Lecture 3: Create Database / Table using BTEQ

Lecture 4: SQL Joins – Joining Data from Multiple Tables

Lecture 5: GROUP BY Clause

Lecture 6: CREATE TABLE FROM ANOTHER TABLE

Lecture 7: CREATE TABLE – Advanced

Lecture 8: DDLs (Data Definition Language) / DML (Data Manipulation Language)

Lecture 9: Deploying Views

Chapter 5: Logging & Monitoring

Lecture 1: Access Logging

Lecture 2: Enabling / Disabling Query Logging

Lecture 3: DBQLs (Database Query Logs)

Lecture 4: Viewpoint (Teradata Monitoring Tool)

Lecture 5: Dictionary Tables (DBC Tables)

Instructors

Mubashar Sajjad
Teradata Database Administrator

Rating Distribution

1 stars: 1 votes

2 stars: 0 votes

3 stars: 2 votes

4 stars: 7 votes

5 stars: 9 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!