Teradata Database Administrator

This is about basics of BTEQ utility and How to connect with Teradata database using BTEQ

You will know about Fast Load which is a main utility used for loading data from files systems to Teradata Database.

After this you will be able to create Teradata database using Teradata Studio and tables into that database

User Management is key responsibility of DBA and this lecture will teach you a complete cycle of user management

This will teach you about managing User Profile in Teradata for applying password policy & sharing spool memory.

This is quite common in an organization that users are locked because of wrong password attempt. This is requested to DBA then to unlock the user. This is a step to step guide for unlocking Teradata users

In this lecture you will learn the role of Access Roles, How the access rights are assigned to access roles and finally how the roles are assigned to users

This will teach you How multiple roles are assigned to a user

As single user may have more than one roles and setting default roles is important to make sure that user can perform the action according to roles assigned to him.

SELECT is an important part of SQL and used by DBA very extensively to trouble shoot day to day task / provide reporting. This lecture will brief you about SELECT and it's usage

In this lecture you will learn about CREATE TABLE command which is majorly used by DBA during deployment of release packages.

This will teach you creating tables using BTEQ utility. BTEQ is majorly used by ETL developers

JOINS are mainly used to combine data from more than single tables and represent as single data set. This lecture is about in depth understanding of JOINS in SQL.

This lecture will teach you about copying data / structure of an existing table using CREATE TABLE AS statement.

This is about conceptual understanding of DDL (Data Definition Language) and DML (Data Manipulation Language)

This lecture is about deploying views and know how about DBA part to support developers for deploying their views.

This will help you learning enabling Logging to keep history of object access which might be demanded by management / development team any time.

In any organization very first thing after user creation is to make sure that user activity is being logged. This will teach you enabling / disabling logging for user activities.

This lecture will teach you about DBQLs (Database Query Logs). these sets of tables contain all the logging information about Queries and helps DBA a lot to identify bad / problematic Queries or even in capacity planning.

This lecture is about Teradata Viewpoint which is a monitoring tool to monitor and manage Teradata System in an organization

This lecture is brief and usage about dictionary tables known as DBC tables. These tables contain all the information about system and system configurations