Teradata數(shù)據(jù)倉庫管理培訓
培訓班型: 企業(yè)內(nèi)訓、公開課
課程長度: 4天/24小時
培訓講師: 博學高級講師,Teradata專家
培訓地點: 杭州市文三路252號偉星大廈19樓博學國際教育培訓中心
環(huán)境要求: 人手一臺電腦、投影儀、接線板
培訓形式: 實例講授,現(xiàn)場演、練、及時溝通
培訓資料: 電子教材
課程內(nèi)容
Teradata基礎(chǔ) Teradata Basics
Teradata Database Architecture
PI Access and Mechanics
Secondary Indexes and Table Scans
Partitioned Primary Indexes
Transactions, Requests and Statements
Database Locking
Miscellaneous SQL Features
Join Processing Analysis
Explains of Joins and Index Choices
The EXPLAIN Facility
Optimizer and Collecting Statistics
Teradata管理 Database Administration and Building the Database Environment
Users, Accounts, and Accounting
Profiles
The Data Dictionary
Space Allocation and Usage
Access Rights
Teradata管理 Roles
BTEQ
FastLoad
FastExport
Additional Index Choices
System and Maintenance Utilities
Teradata管理 System Access Controls
Access and Query Logging
Data Protection
Archiving Data
Restoring Data
Warehouse Administration Recap