Teradata數(shù)據(jù)倉(cāng)庫(kù)管理培訓(xùn)
培訓(xùn)班型: 企業(yè)內(nèi)訓(xùn)、公開(kāi)課
課程長(zhǎng)度: 4天/24小時(shí)
培訓(xùn)講師: 博學(xué)高級(jí)講師,Teradata專家
培訓(xùn)地點(diǎn): 杭州市文三路252號(hào)偉星大廈19樓博學(xué)國(guó)際教育培訓(xùn)中心
環(huán)境要求: 人手一臺(tái)電腦、投影儀、接線板
培訓(xùn)形式: 實(shí)例講授,現(xiàn)場(chǎng)演、練、及時(shí)溝通
培訓(xù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