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
Description
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.
Content