翰竺科技（北京）有限公司

首页

关于我们

IT服务

技术专长

培训服务

成功案例

新闻中心

加入我们

联系我们



	·企业培训服务企业管理培训 IT技术培训 →Sun Solaris →Teradata →Cisco →JAVA开发 →SQL Server →IBM DB2 数据库 →Linux下C开发 →实施NetScreen安全网关 →软件测试

	·社会培训服务

	·院校合作

	·中国软件实训就业联盟

>>> 首页 > 培训服务 > 企业培训服务

主要课程

在参加本课程之前，你需要具备以下知识和经验：
●关系数据库概念，逻辑数据模型，SQL。
●数据处理的基本概念。
课程介绍：
本课程培训Teradata数据库的概念、设计、实施和管理。有动手实验，能够访问Teradata数据库，使用数据加载工具，包含：
●Teradata基本概念、特点和功能。
●海量并行处理系统结构。
●Teradata物理数据库设计，理解数据的分布、访问、连接技术，选择正确的索引。
●Teradata应用工具：BTEQ、FastLoad、FastExport、MultiLoad和TPump。
●Teradata数据库管理，数据字典、数据库层次结构、创建用户和数据库、访问权限、系统工具。

本课程提供4本教材，提供通过下列Teradata认证考试的必要信息：
●认证1：Teradata Certified Professional
●认证2：Teradata Certified Implementation Specialist
●认证4：Teradata Certified Administrator
●认证5：Teradata Certified Designer

培訓目标：
●了解Teradata数据库的特点和功能。
●了解Teradata数据库和海量并行处理系统的体系结构。
●使用Teradata进行物理数据库设计。
●使用Teradata应用工具加载数据。
●对Teradata数据库进行一般性管理。

培训安排：

时间：每天9:00AM-5:30PM，共10个工作日，周六、日休息。

所用教材：Teradata 数据仓库系列教程，共四册：
1. Teradata Concepts— Teradata 基本原理和体系结构
2. Teradata Physical Database Design— Teradata数据库物理设计
3. Teradata Application Utilities— Teradata应用工具
Teradata Database Administration— Teradata数据库管理

课程安排：

天	星期	授课内容
Day 1	Monday/Morning	Book 1 – Teradata Concepts
		0. Teradata Factory Overview and class introductions
		1. Teradata concepts and competitive advantages
		2. Relational database concepts and terminology
		3. Teradata basics – data distribution, parallelism, & scalability
		4. Teradata RDBMS components and architecture
	Monday/Afternoon	Book 1 – Teradata Concepts
		5. Teradata implementations
		6. Creating a Teradata database
		7. Storing and accessing data rows
		8. Primary Index Mechanics
		9. Secondary indexes and table scans
		10. Data protection (RAID, Cliques, Clusters, Locks, and Journals)
Day 2	Tuesday/Morning	Book 1 – Teradata Concepts
		11. Introduction to NCR Systems – Teradata platforms overview
		12. NCR 49xx/53xx Configurations and Disk Arrays - detail discussion
		13. How Teradata uses NCR Systems (FSG Cache, Vdisks, and Pdisks)
	Tuesday/Afternoon	Book 2 – Physical Database Design
		1. Logical Modeling, 3NF, and denormalization issues overview
		2. Data Distribution, Hashing, and Index Access
Day 3	Wednesday/Morning	Book 2 – Physical Database Design
		3. File System Writes
		4. Analyze Primary Index Criteria and Lab
	Wednesday/Afternoon	Book 2 – Physical Database Design
		5. Partitioned Primary Indexes and Lab
		6. Secondary Index Usage
Day 4	Thursday/Morning	Book 2 – Physical Database Design
		7. Choosing Secondary Indexes
		8. Access Issues and Constraints
		9. Referential Integrity
	Thursday/Afternoon	Book 2 – Physical Database Design
		10. Sizing and Lab Exercise
		11. SQL Parser
		12. Optimizer and Collecting Statistics
		13. The EXPLAIN Facility and Lab
Day 5	Friday/Morning	Book 2 – Physical Database Design
		14. Visual Explain and demonstration
		15. Join Processing Analysis
		16. Explains of Joins and Index Choices
	Friday/Afternoon	Book 2 – Physical Database Design
		17. Additional Index Choices – Join Indexes, Hash Indexes, etc.
		18. Miscellaneous SQL Features
Day 6	Monday/Morning	Book 3 – Application Utilities
		1. Overview of Load and Unload utilities
		2. BTEQ and Lab Exercise 2
	Monday/Afternoon	Book 3 – Application Utilities
		3. FastLoad and Lab Exercise 3
		4. Support Environment for MultiLoad, FastExport, Tpump
		5. FastExport
Day 7	Tuesday/Morning	Book 3 – Application Utilities
		5. FastExport and Lab Exercise 5
		6. MultiLoad and Lab Exercise 6
	Tuesday/Afternoon	Book 3 – Application Utilities
		7. MultiLoad Part II and Lab Exercise 7
		8. Tpump and Lab Exercise 8
		9. Making the right choice of a utility
Day 8	Wednesday/Morning	Book 4 – Database Administration
		1. Building the Database Environment
		2. The Data Dictionary/Directory and Lab Exercise 2
		3. Space allocation and usage
	Wednesday/Afternoon	Book 4 – Database Administration
		4. Users, Accounts and Accounting and Lab Exercise 4
		5. Access Rights
		6. Roles and Profiles and Lab Exercise
Day 9	Thursday/Morning	Book 4 – Database Administration
		7. System Access Controls and Lab Exercise
		8. Access and Query Logging
		9. Access Rights for Referential Integrity and Triggers and Lab Exercise
	Thursday/Afternoon	Book 4 – Database Administration
		10. Utilities overview and Teradata DB Window
		11. Configuration Utilities & Priority Scheduler
		12. Performance Monitoring
		13. Teradata Manager and Teradata DQM
		14. System Restarts
Day 10	Friday/Morning	Book 4 – Database Administration
		15. Diagnostic and Recovery utilities
		16. Permanent Journals
		17. A Tale of Three Tables – Example of using Permanent Journals
		18. Data Archiving – Archive commands
		19. Restoring Data – Restore commands
		20. Data Recovery – Checkpoint, RollForward, and RollBack commands
		21. Administrative Tools Recap – Tables to Monitor
	Friday/Afternoon	TF Review and Q&A
	Friday/Afternoon	TF Examination

ITMS IT技术培训项目组
地址：北京市海淀区清华东路25号电子六所大厦2层
邮编：100083
电话：+86 10 82306282/6261/6295/6252/6279/6253/6275
传真：+86 10 82306289
邮件：px@itms.com.cn