MCSA: SQL 2016 Database Administration (2科) 國際認可證書課程
課程簡稱：MCSA SQL Training Course (2016)

關於本課程之相關考試：

Microsoft 已停止提供本課程的相關考試。

雖然學員已不能應考本課程的相關考試，
但學員仍能透過本課程所學的知識及實習，廣泛地應用於工作上。

合格保障：學員若考試不合格，本中心均會代付考試費，令學員可 半費重考 ！詳情...

本中心是 Microsoft 認可的合作夥伴 (Microsoft Certified Partner)。

私有雲端 (Private Cloud) 是將雲基礎設施與軟硬體資源建立在企業防火牆內，以供機構或企業內各部門共享數據中心內的資源。私有雲端是完全為您的機構或企業而運作的雲端基礎設施，管理者也通常是您的機構或企業的全職 I.T. 管理員。

由於私有雲端資料庫能為公司儲存重要資料，再加上電腦網絡的發展蓬勃，故此有很多公司，不論大、中或小型，都紛紛為公司加上資料庫並自設私有雲端 (Private Cloud) 來獲得最佳效益及資訊安全性，以致 Microsoft 的私有雲端資料庫產品 SQL Server 2016 大受歡迎，形成市場對 Microsoft 企業自設雲端認證 (Microsoft Cloud-built Certification) 人材的強大需求，所以他們的市場價值亦相對其他行業為高。

而 Microsoft SQL Server 系列產品經歷十多年來不斷進步，效能和功能愈來愈強，不論大、中或小型的項目都紛紛採用Microsoft SQL Server 作為基礎資料平台。

雲端世代的 Microsoft 認證 : 掌握雲端運算科技，迎接未來挑戰

MCSE (Microsoft Certified Solutions Expert - 微軟認證解決方案專家) 是 Microsoft 新一代的「專家」級國際認證考試，能證實該合格考生可順利執行某項工作所需的完整技能集。這些技能包括設計、專案管理、作業管理及規劃能力，而這些能力是IT 卓越技能的全球通用標準，此認證證明您擁有各種解決方案的深度專業技能並具備各領域技術的最新技能。

MCSE Logo

MCSA (Microsoft Certified Solutions Associate - 微軟認證解決方案技術師) 是 Microsoft 新一代的「入門」級國際認證考試，能夠讓合格考生將目標放在特定的技術上，並且透過在他們工作中會使用的技術，展示他們的知識及獨特的專長，來突顯出自己的能力。

MCSA Logo

本中心為Microsoft指定的考試試場。報考時請致電本中心，登記欲報考之科目考試編號、考試日期及時間 (最快可即日報考)。臨考試前要出示身份證及繳付每科 HK$1,025 之考試費。

考試題目由澳洲考試中心傳送到你要應考的電腦，考試時以電腦作答。所有考試題目均為英文，而大多數的考試題目為單項及多項選擇題，其餘則為實戰題。作答完成後會立即出現合格的要求分數及你的分數，結果即考即知！

考試合格後會收到來自Microsoft的作實電郵，並進入該電郵內的連結，登入 Microsoft Credentials Dashboard 下載您的證書。

考試不合格便可重新報考，不限次數。欲知道作答時間、題目總數、合格分數等詳細考試資料，可瀏覽本中心網頁 "各科考試分數資料"。

1. SQL Server 2016 Overview
1.1 Introduction to SQL Server 2016
1.2 Major Components of SQL Server 2016
1.3 Editions and Feature Comparisons of SQL Server 2016

2. Deploying SQL Server 2016
2.1 Windows Domain Environment
2.2 Configuring the domain network environment for deploying SQL Server 2016
2.3 SQL Server 2016 Hardware Requirements
2.4 SQL Server 2016 Enterprise Edition Software Requirements
2.5 Installing SQL Server 2016 and prequisites
2.6 Installing the SQL Server Management Studio

3. Network Protocols
3.1 Client – Server 2 tier SQL Networking Model
3.2 Server Network Protocols
3.3 Client Network Protocols – SQL Native Client
3.4 Configuring Windows Firewall to allow SQL Server Communications
3.5 Choosing , Comparing SQL Network Protocols

4. Basic Concept of SQL Server Database
4.1 Creating SQL Server Database
4.2 Table
4.3 Using ODBC to access SQL Server Database
4.4 Using OLE DB to access SQL Server 2016 Database

5. SQL Native Client
5.1 Introduction to SQL Native Client
5.2 SQL Native Client features
5.3 Deploying SQL Native Client 11.0
5.4 Connecting to SQL Sever Database by using SQL Native Client
5.5 More about Windows Kerberos Authentication

6. Fully Qualified Names

7. System Meta Data
7.1 System Databases
7.2 System Views
7.3 Resource Database

8. Transaction Log
8.1 A Case Study of Roll Back
8.2 A Case Study of Roll Forward

9. Error Logging
9.1 Database Engine Error Severities
9.2 System Table for all error messages
9.3 Obtaining SQL Server Database Engine log

10. Alerts
10.1 Starting of SQL Server Agent
10.2 Database Mail
10.3 Setting Up an Alert Event for SQL Server Agent

11. Scheduled Jobs
11.1 Configuring Scheduled Jobs
11.2 Scripting Scheduled Jobs

12. Table Size

13. Index
13.1 Creating an Index
13.2 Nonclustered and Clustered Index
13.3 Non-Clustered Index with Included Columns
13.4 Using Included Columns to Avoid Size Limits
13.5 Summary of using Included Columns of a Non-clustered Index
13.6 Index Usage
13.7 Fill Factor
13.8 Filtered Index
13.9 Reorganizing Index
13.10 Using Database Maintenance Task for Index Reorganization of Entire Database

14. Data Model
14.1 Normalization
14.2 Cases of Normalization
14.3 Relationship
14.4 Using Normalized Database Design

15. SQL Server Identity and Access Control
15.1 Principals
15.2 Windows-level principals
15.3 SQL Server-level principal
15.4 Database Level Principals
15.5 Roles
15.6 Fixed Server Roles
15.7 Database Roles
15.8 Choosing an Authentication Mode
15.9 Securables
15.10 Permission Hierarchy
15.11 Reporting Permission
15.12 Assigning Permissions on database and within database securables
15.13 The DENY Permission
15.14 The GRANT OPTION
15.15 Granting Permission on Server level securables
15.16 Relationship between Database User, Fixed Database Role, Database Role and Schema
15.17 General Steps of Permission Check Algorithm
15.18 Row level permission

16. Physical Database Architecture
16.1 Database Files
16.2 Filegroups

17. Physical Table Architecture
17.1 Table Organization
17.2 Partitioned Tables and Indexes
17.3 General Guidelines for Implementing Horizontally Partitioned Tables
17.4 Preparing a large table and Benchmarking a large table scan
17.5 Adding Extra Filegoups and Data Files
17.6 Understanding Partition Functions
17.7 Creating Partition Functions
17.8 Understanding Partition Scheme
17.9 Creating Partition Scheme
17.10 Partitioning Table Data by Datetime column
17.11 Benchmarking Partitioned Table
17.12 Guideline for Partitioned Index
17.13 Aligned Index Partitioning for Partitioned Tables
17.14 Aligned Index Partitioning for Partitioned-Clustered Tables
17.15 Comparison

18. Monitoring SQL Server
18.1 SQL Server Profiler
18.2 Advanced Usage of SQL Profiler
18.3 Detect Blocking
18.4 Ad hoc Blocking removal
18.5 Using Tuning Template

19. Databaes Engine Tuning Advisor
19.1 Introduction to Database Engine Tuning Advisor (DTA)
19.2 Using a Workload file
19.3 More references about DTA tuning options

20. Views
20.1 Understanding Standard View
20.2 Using View to provide Backward Compatibility
20.3 CHECK OPTION
20.4 Designing and Implementing Indexed View
20.5 Using Hints with Indexed View
20.6 Detecting Discrepancy between Table and Indexed View

21. Statistics
21.1 Concept of Statistics
21.2 About Index Statistics
21.3 Optimizing Statistics Update process

22. Maintenance Plan
22.1 Transaction Information
22.2 Structural and Logical Integrity of a database
22.3 Automated Maintenance Plan
22.4 Emergency Administration

23. Resource Monitoring
23.1 About SQL Server Performance objects
23.2 Monitoring overall Memory Usage
23.3 Monitoring Memory used by SQL Server

24. Disaster Recovery
24.1 Three Recovery Models
24.2 Types of Backup supported in Full Recovery Model
24.3 Performing Backup
24.4 Performing Restore
24.5 Performing a Backup/Restore with SQL Server Management Studio
24.6 Information about a Backup File

25. Configuring High-Availability - Standby Server
25.1 Configuring a Standby SQL Server

26. Configuring High-Availability – Log Shipping
26.1 About Log Shipping
26.2 Typical Log Shipping Configuration
26.3 Configuring Log Shipping

27. Configuring High-Availability – Database Mirroring
27.1 Database Mirroring Overview
27.2 Benefits of Database Mirroring
27.3 Configuring Database Mirroring
27.4 Database Mirroring High Safey Operating Mode
27.5 Database Mirroring High Performance Operating Mode
27.6 Connecting Clients to a Mirrored Database
27.7 Removing Database Mirroring
27.8 Combining Database Mirroring and Log Shipping

28. Configuring High-Availability – Database Replication
28.1 Elements of Replication
28.2 Choosing Suitable Replication Role
28.3 Types of Replication
28.4 Configuring Transactional Replication
28.5 Replication Performance
28.6 Comparing High – Availability Technologies

29. Distributed Queries
29.1 Introduction to Distributed Queries
29.2 Ad Hoc Connection
29.3 Linked Servers
29.4 Configuring a Linked Server Mapped Login
29.5 Pass-through Query

30. Basic Concepts of WSFC
30.1 About Windows Server Failover Clusters

31. Implementing SQL Server Always On Failover Cluster Instance
31.1 Overview of SQL Server Always On FCI
31.2 Installing Always-On FCI

32. Implementing SQL Server Always On Availability Group
32.1 Overview of Always On Availability Group
32.2 Creating WSFC for Availability Group
32.3 Creating Always On Database Availability Group
32.4 Availability Group Listener
32.5 Read-Only Routing

33. SQL Server Encryption and Data Protection
33.1 Encryption Keys in SQL Server
33.2 Encrypting a Column of Data
33.3 Transparent Data Encryption
33.4 Encryption Without Keys
33.5 Security Catalog Views
33.6 Encrypting Connections to SQL Server