Exam 70-228
Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
完成本科目，你便可建設到下列的網路環境 (可按圖放大)：
1. Basic Concept of Microsoft SQL Server
Client/Server Environment (環境)
Relational DataBase Management System (RDBMS, 關聯性資料庫管理系統)
Transact-SQL
2. Installation of Microsoft SQL Server 2000
3. Basic Concept of SQL Server Database (資料庫)
Creating SQL Server Database
Table (資料表)
Data Transformation Services (DTS)
Creating Views
Using ODBC to Access SQL Server Database
Using MSDE to Access SQL Server Database
4. Login Access to SQL Server
Adding a SQL Server Account for Logon to SQL Server
Granting (批准) a Windows Account for Logon to SQL Server
5. Authentication (驗證)
Authentication Modes (模式) on SQL Server
Comparison (比較)
6. Granting Access to Databases
Granting Database Access to Login Users
Default User Accounts in a Database
Revoking Database Access
7. Roles (角色)
Fixed Server Roles
Database Roles
8. Permissions
Granting Permission to Users by SQL Server Enterprise Manager
Granting, denying and revoking permissions to users by SQL statements
Permissions to Create Objects in the Database
9. Fully Qualified Names (完全合格名)
10. System Databases and System Tables
Master Database
Model Database
Tempdb Database
System Tables Present in Every Database
System Tables Present in Master Database Only
11. Transaction Log (交易記錄)
A Case Study of Roll Back
A Case Study of Roll Forward
12. Alerts (警報)
Starting of SQL Server Agent
Configuration of a Mail Profile (描述) for SQL Server Agent
Setting Up an Alert Event for SQL Server Agent
13. Scheduled Jobs
Configuring Scheduled Jobs
Scripting (手稿化) Scheduled Jobs
14. Table Size
15. Index (索引)
Creating an Index
Nonclustered and Clustered Index
Fill Factor (填滿指數)
Composite Index (組合索引)
Statistics (統計)
16. Data Model
Normalization (正常化)
Cases
Relationship (關聯)
Using Normalized Database Design
17. Database Files and Filegroups
Data Files
Log File
Properties of Database File
Creation of Filegroup and Placing a Whole Table to a Filegroup
Placing Parts of a Table to Another Filegroup
Properties of Filegroup
18. Backup and Restore
Types of Backup
Performing Backup
Performing Restore
Filegroup Backup and Restore
Performing a Backup/Restore with SQL Server Enterprise Manager
Recovery Model
Information about a Backup File
19. Standby Server
Configuring a Standby SQL Server
Log Shipping (記錄運送)
20. Importing (匯入) / Exporting (匯出) Data
SELECT INTO
INSERT INTO
Bulk (大量) Copy Program (bcp utility)
Bulk (大量) INSERT
Data Transformation Services (DTS，資料轉換服務)
DTS Packages (包裝)
21. Replication (複製)
Elements (元素) of Replication
Choosing Suitable Replication Role
Types of Replication
Configuring Replication
22. Linked Servers (被連結的伺服器)
Configuring a Linked Server
Configuring a Linked Server Login
23. Monitoring (監察) SQL Server
SQL Profiler (描述器)
System Monitor
C2 Auditing (核算)
24. SQL Server Maintenance and Troubleshooting
Database Checking and Database Repairing
Table Contiguity (鄰近性)
Detaching / Attaching a Database
Network Libraries
Collation (整理)
70-228實習清單
下列為本中心 Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition (070-228) 課程的實習清單，全部實習均會於上堂時由導師進行，而深黑色的實習亦會由學生於家中進行：
Installing Microsoft SQL Server 2000
Creating SQL Server Database (資料庫)
Creating a table (資料表)
Inputting data into a table
Creating Relationships (關係) between tables
Using Data Transformation Services (DTS) to import (匯入) external (外來的) data to a table
Creating Views
Changing the Design of Views
Using ODBC to Access SQL Server Database
Using MSDE to Access SQL Server Database
Adding a SQL Server Account for Logon to SQL Server
Granting (批准) a Windows Account for Logon to SQL Server
Choosing SQL Server Authentication Modes
Granting Database Access to Login Users
Adding a Guest User Account
Revoking Database Access
Adding , Removing a Member to a Fixed Server Role (角色)
Adding a Member to a Fixed Database Role
Adding , Removing a User-Defined Database Role
Adding , Activating , Removing an Application Role
Granting Permission to Users by SQL Server Enterprise Manager
Granting, Denying and Revoking permissions to users by SQL statements
Granting , Revoking Permissions to Create Objects in the Database
Using Fully Qualified Names (完全合格名)
Trying out Transaction Log (交易紀錄) Roll Back
Trying out Transaction Log Roll Forward
Starting of SQL Server Agent
Configuring a Mail Profile (描述) for SQL Server Agent
Setting Up an Alert Event for SQL Server Agent
Configuring Scheduled Jobs
Scripting (手稿化) Scheduled Jobs
Creating a Nonclustered Index (非群集索引)
Creating a Clustered Index (群集索引)
Configuring Fill Factor (填滿指數) for a table
Configuring Composite Index (組合索引) on a table
Configuring Statistics (統計) for a database
Creating One-to-Many (一對多) Relationship (關聯) between tables
Retrieving (抽取) Data in a Normalized (正常化) Database
Using JOIN Query
Deploying Unique Constraint (獨一限制)
Cascading (串接) Update and Delete
Assigning Data Files for a database
Assigning Log File for a database
Creation of Filegroup and Placing a Whole Table to a Filegroup
Placing Parts of a Table to Another Filegroup
Performing a Full Database Backup (完整備份)
Performing a Transaction Log Backup (交易紀錄備份)
Restoring from a Full Database Backup
Restoring from a Differential (差額) Database Backup
Restoring from a Transaction Log Backup
Restoring Up to a Specific Time
Restoring Up to the Point of Failure (失敗點)
Performing Filegroup Backup
Restoring Filegroup from Backup
Performing a Backup/Restore with SQL Server Enterprise Manager
Switching SQL Server Recovery Model
Extracting Information from a Backup File
Configuring a Standby SQL Server
Bringing a Standby SQL Server Online
Configuring Log Shipping (紀錄運送)
Allowing a database to assume (假設) Primary Role (主角色)
Using SELECT INTO statement to create a new table
Using SELECT INTO statement to create a temporary (臨時的) table
Using INSERT INTO statement to append data to an existing table
Using Bulk (大量) Copy Program (bcp utility) to import data to SQL Server
Using Bulk INSERT statement to import data to SQL Server
Using Data Transformation Services (DTS，資料轉換服務) to convert and import data to SQL Server
Using Data Transformation Services to export (匯出) data from SQL Server
Creating a DTS Packages (包裝)
Enabling Transaction in a DTS package
Configuring Precedence (優先) Constraint (限制) in a DTS Package
Configuring BULK INSERT task in a DTS Package
Using Microsoft Data Link in a DTS Package
Scheduling (排程) Execution of a DTS Package
Configuring the Replication (複製) Publisher/Distributor
Enabling Desired (喜好的) Subscriber
Configuring Subscriber
Starting the Snapshot (影快相) Agent
Configuring a Linked Server (被連結的伺服器)
Configuring a Linked Server Login (登入)
Using SQL Profiler (描述器) to create a Trace (追?) and Capture events to a File
Replaying (重播) a Trace File
Adding SQL Server Counters to System Monitor
Enabling C2 Auditing (核算)
Database Checking and Database Repairing
Ensuring Table Contiguity (鄰近性)
Detaching , Attaching a Database
Enabling SQL Server Network Libraries
Configuring Collation (整理) for SQL Server
Configuring Collation for a Databse
Configuring Collation for a Linked Server
Exam 70-229
Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
1. Transact-SQL
Creating a New Database
Updating Records from Another Table
Aggregate (合成) Functions
Group By
TOP
DISTINCT (不同)
COALESCE (聯合產生)
Subquery (子查詢)
2. Index
Execution Plan (執行計劃)
Index Tuning Wizard (索引調較精靈)
DBCC DBREINDEX
3. Views
CHECK OPTION
Indexed View
4. Transaction
ROLLBACK TRANSACTION
Programming Transaction
Implicit Transactions
5. JOIN
Updating Records with JOIN
Types of JOIN
6. Constraints (限制)
Primary Key Constraint
Unique Constraint
Foreign Key Constraint
Check Constraint (檢查限制)
7. Triggers (觸發裝置)
Creating a Simple Trigger
Creating a Trigger to Perform Verification (核對)
Creating a Trigger to Backup Modified Data
Creating a Trigger to Examine New Data
Creating a Trigger to Perform Update on Other Table
INSTEAD OF (取而代之) TRIGGER
8. Stored Procedure
A Simple Stored Procedure
Using Parameters (參數) in Stored Procedures
Returning Status from a Stored Procedure
Logging Message in a Stored Procedure
Limiting Access by a Stored Procedure
Recompiling a Stored Procedure
Encrypting (加密) a Stored Procedure
Inline Functions
9. Cursor (草稿)
10. Working with XML
Overview (概論) of XML
An XML Example
Retrieving Data From SQL Server in XML Format
Importing Data to SQL Server from XML Document
70-229實習清單
下列為本中心 Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition (070-229) 課程的實習清單，全部實習均會於上堂時由導師進行，而深黑色的實習亦會由學生於家中進行：
Using Transact-SQL statements to Create a New Database
Using Transact-SQL statements to Update Records from Another Table
Using Transact-SQL Aggregate (合成) Functions
Using Transact-SQL Group By Statement
Using Transact-SQL TOP Statement
Using Transact-SQL DISTINCT (不同) Statement
Using Transact-SQL COALESCE (聯合產生) Statement
Using Transact-SQL Subquery (子查詢) Statement
Showing SQL Server Execution Plan (執行計劃)
Using Index Tuning Wizard (索引調較精靈)
Preparing Workload File by SQL Server Profiler
Rebuilding (重建) SQL Server Index by DBCC DBREINDEX Statement
Enabling CHECK OPTION in Database Views
Creating Indexed View
Performing ROLLBACK TRANSACTION
Programming Transaction
Enabling Implicit (暗講) Transactions on SQL Clients
Updating Records with JOIN Statement
Enabling Check Constraint (檢查限制)
Creating a Simple Trigger (觸發裝置)
Creating a Trigger to Perform Verification (核對)
Creating a Trigger to Backup Modified Data
Creating a Trigger to Examine New Data
Creating a Trigger to Perform Update on Other Table
Creating a INSTEAD OF (取而代之) TRIGGER
Creating a Simple Stored Procedure
Using Parameters (參數) in Stored Procedures
Returning Status from a Stored Procedure
Logging Message in a Stored Procedure
Limiting Access by a Stored Procedure
Encrypting (加密) a Stored Procedure
Creating Inline Functions
Declaring a Cursor (草稿)
Retrieving Data From SQL Server in XML Format
Importing Data to SQL Server from XML Document
|
浙公网安备 33010602011771号