|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/teradata-database-administrator/
课程评论：没有评论
课程名称：Teradata 数据库管理员 课程概述：Teradata 是一种封闭技术，用户在数据库管理方面常常面临查询结果不尽如人意的问题。为了帮助解决这些日常数据库管理相关的问题，本课程专门设计，提供详细的指导，从下载虚拟机和配置测试环境开始，直到加载示例数据以供实践。课程重点围绕 Teradata 数据库管理的关键概念，深入探讨日常数据库管理员（DBA）的任务。 课程内容包括 Teradata 工具的使用，如 BTEQ 和 FastLoad，这些工具主要被 Teradata 开发者使用。同时，课程深入讲解 SQL 的概念，教授如何通过 JOIN 从单个表或多个表中提取数据，以生成报告，课程内容还涵盖了 GROUP BY 和 WHERE 子句的详细运用。此外，课程深入介绍了在 Teradata 中的日志记录和监控知识，包括如何启用或禁用对象的查询日志，以监控对对象执行的活动。课程还讨论了数据库查询日志（DBQL），用于故障排除和容量规划。 完成此课程后，您将能够自信地称自己为一名操作型数据库管理员，具备高效处理日常 Teradata DBA 任务的能力。
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.
