- 資料庫基礎知識
- 瞭解 SQL 語法和查詢
觀眾
- Database 管理員 (DBA)
- 開發人員
- IT 專業人員
SQL 伺服器 Management Studio (SSMS) 是一個集成環境,用於管理從 SQL 伺服器到 Azure SQL Database 的任何 SQL 基礎結構。SSMS 提供用於配置、監視和管理 SQL 伺服器和資料庫實例的工具。
這種以講師為主導的現場培訓(現場或遠端)針對中級資料庫管理員,他們希望學習必要的技能和知識,以使用SQL伺服器Management Studio有效地管理和管理SQL伺服器資料庫。
在培訓結束時,參與者將能夠:
- 了解系統要求並執行安裝。
- 使用 SSMS 建立、配置和管理資料庫。
- 管理登錄名、使用者、角色和許可權。
- 執行各種類型的備份和還原資料庫。
- 使用 SQL Server Agent 創建、計劃和管理作業。
- 實施高效、安全的最佳實踐 SQL 伺服器管理。
課程形式
- 互動講座和討論。
- 大量的練習和練習。
- 在現場實驗室環境中實際實施。
課程定製選項
- 如需申請此課程的定製培訓,請聯繫我們進行安排。
SQL 伺服器 Management Studio (SSMS) 簡介
- SQL 伺服器版本和元件概述
- SSMS 的介面和功能
- 使用 SSMS 進行資料庫管理的好處
安裝和配置
- SQL 伺服器和 SSMS 的系統要求
- 安裝 SQL 伺服器和 SSMS
- 安裝後配置
- 連接到SQL 個伺服器實例
Database 架構和存儲
- 瞭解 SQL 伺服器資料庫和實例
- SQL 伺服器資料庫架構
- 檔組和數據檔
創建和管理 Databases
- 使用 SSMS 建立資料庫
- 管理資料庫屬性
- 附加和分離資料庫
安全 Management
- SQL伺服器安全簡介
- 管理登錄名和使用者
- 分配角色和許可權
- 實施安全最佳實踐
備份和恢復
- 備份和還原的重要性
- 備份類型:完整備份、差異備份、事務日誌備份
- 使用SSMS執行備份
- 從備份還原資料庫
Database 維護計劃
- 定期資料庫維護的重要性
- 創建和安排維護計劃
- 對維護計劃進行監控和故障排除
監視和性能調優
- 監控 SQL 伺服器性能
- 確定性能瓶頸
- 索引 Management 和優化
- 使用 SQL 伺服器分析器和擴展事件
使用 SQL Server Agent 自動執行任務
- SQL Server Agent 簡介
- 創建和管理作業
- 計劃作業和警報
- 監視 SQL 伺服器代理作業
高可用性和災難恢復
- 高可用性選項概述
- 實現資料庫鏡像
- 配置記錄傳送
- AlwaysOn 可用性組簡介
升級和遷移 SQL 伺服器
- 規劃 SQL 伺服器升級
- 就地升級與並行升級
- 將資料庫遷移到新實例
- 遷移後任務
摘要和後續步驟
United Arab Emirates - SQL Server Management Studio (SSMS) Administration
Qatar - SQL Server Management Studio (SSMS) Administration
Egypt - SQL Server Management Studio (SSMS) Administration
Saudi Arabia - SQL Server Management Studio (SSMS) Administration
South Africa - SQL Server Management Studio (SSMS) Administration
Brasil - SQL Server Management Studio (SSMS) Administration
Canada - SQL Server Management Studio (SSMS) Administration
中国 - SQL Server Management Studio (SSMS) Administration
香港 - SQL Server Management Studio (SSMS) Administration
澳門 - SQL Server Management Studio (SSMS) Administration
台灣 - SQL Server Management Studio (SSMS) Administration
USA - SQL Server Management Studio (SSMS) Administration
Österreich - SQL Server Management Studio (SSMS) Administration
Schweiz - SQL Server Management Studio (SSMS) Administration
Deutschland - SQL Server Management Studio (SSMS) Administration
Czech Republic - SQL Server Management Studio (SSMS) Administration
Denmark - SQL Server Management Studio (SSMS) Administration
Estonia - SQL Server Management Studio (SSMS) Administration
Finland - SQL Server Management Studio (SSMS) Administration
Greece - SQL Server Management Studio (SSMS) Administration
Magyarország - SQL Server Management Studio (SSMS) Administration
Ireland - SQL Server Management Studio (SSMS) Administration
Luxembourg - SQL Server Management Studio (SSMS) Administration
Latvia - SQL Server Management Studio (SSMS) Administration
España - SQL Server Management Studio (SSMS) Administration
Italia - SQL Server Management Studio (SSMS) Administration
Lithuania - SQL Server Management Studio (SSMS) Administration
Nederland - SQL Server Management Studio (SSMS) Administration
Norway - SQL Server Management Studio (SSMS) Administration
Portugal - SQL Server Management Studio (SSMS) Administration
România - SQL Server Management Studio (SSMS) Administration
Sverige - SQL Server Management Studio (SSMS) Administration
Türkiye - SQL Server Management Studio (SSMS) Administration
Malta - SQL Server Management Studio (SSMS) Administration
Belgique - SQL Server Management Studio (SSMS) Administration
France - SQL Server Management Studio (SSMS) Administration
日本 - SQL Server Management Studio (SSMS) Administration
Australia - SQL Server Management Studio (SSMS) Administration
Malaysia - SQL Server Management Studio (SSMS) Administration
New Zealand - SQL Server Management Studio (SSMS) Administration
Philippines - SQL Server Management Studio (SSMS) Administration
Singapore - SQL Server Management Studio (SSMS) Administration
Thailand - SQL Server Management Studio (SSMS) Administration
Vietnam - SQL Server Management Studio (SSMS) Administration
India - SQL Server Management Studio (SSMS) Administration
Argentina - SQL Server Management Studio (SSMS) Administration
Chile - SQL Server Management Studio (SSMS) Administration
Costa Rica - SQL Server Management Studio (SSMS) Administration
Ecuador - SQL Server Management Studio (SSMS) Administration
Guatemala - SQL Server Management Studio (SSMS) Administration
Colombia - SQL Server Management Studio (SSMS) Administration
México - SQL Server Management Studio (SSMS) Administration
Panama - SQL Server Management Studio (SSMS) Administration
Peru - SQL Server Management Studio (SSMS) Administration
Uruguay - SQL Server Management Studio (SSMS) Administration
Venezuela - SQL Server Management Studio (SSMS) Administration
Polska - SQL Server Management Studio (SSMS) Administration
United Kingdom - SQL Server Management Studio (SSMS) Administration
South Korea - SQL Server Management Studio (SSMS) Administration
Pakistan - SQL Server Management Studio (SSMS) Administration
Sri Lanka - SQL Server Management Studio (SSMS) Administration
Bulgaria - SQL Server Management Studio (SSMS) Administration
Bolivia - SQL Server Management Studio (SSMS) Administration
Indonesia - SQL Server Management Studio (SSMS) Administration
Kazakhstan - SQL Server Management Studio (SSMS) Administration
Moldova - SQL Server Management Studio (SSMS) Administration
Morocco - SQL Server Management Studio (SSMS) Administration
Tunisia - SQL Server Management Studio (SSMS) Administration
Kuwait - SQL Server Management Studio (SSMS) Administration
Oman - SQL Server Management Studio (SSMS) Administration
Slovakia - SQL Server Management Studio (SSMS) Administration
Kenya - SQL Server Management Studio (SSMS) Administration
Nigeria - SQL Server Management Studio (SSMS) Administration
Botswana - SQL Server Management Studio (SSMS) Administration
Slovenia - SQL Server Management Studio (SSMS) Administration
Croatia - SQL Server Management Studio (SSMS) Administration
Serbia - SQL Server Management Studio (SSMS) Administration
Bhutan - SQL Server Management Studio (SSMS) Administration
Nepal - SQL Server Management Studio (SSMS) Administration
Uzbekistan - SQL Server Management Studio (SSMS) Administration