Database Engine 教學課程Database Engine Tutorials

適用於: 是SQL Server 是Azure SQL Database 否Azure SQL 資料倉儲 否平行處理資料倉儲 APPLIES TO: yesSQL Server yesAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

本節包含 SQL Server 2017 資料庫引擎SQL Server 2017 Database Engine的教學課程。This section contains tutorials for SQL Server 2017 資料庫引擎SQL Server 2017 Database Engine.

教學課程:資料庫引擎使用者入門Tutorial: Getting Started with the Database Engine
本教學課程將說明如何連接到 Database EngineDatabase Engine的執行個體。This tutorial teaches how to connect to an instance of the Database EngineDatabase Engine.

教學課程:SQL Server Management StudioTutorial: SQL Server Management Studio
本教學課程將為您介紹用來管理 SQL ServerSQL Server 基礎結構的整合式環境。This tutorial introduces you to the integrated environment for managing your SQL ServerSQL Server infrastructure. SQL Server Management StudioSQL Server Management Studio 提供設定、監視和管理 SQL ServerSQL Server執行個體的圖形介面。presents a graphical interface for configuring, monitoring, and administering instances of SQL ServerSQL Server. 也讓您部署、監視以及升級應用程式所使用的資料層元件,例如資料庫和資料倉儲。It also allows you to deploy, monitor, and upgrade the data-tier components used by your applications, such as databases and data warehouses. SQL Server Management StudioSQL Server Management Studio 也提供用於編輯和偵錯指令碼的 Transact-SQLTransact-SQL、MDX、DMX 和 XML 語言編輯器。also provides Transact-SQLTransact-SQL, MDX, DMX, and XML language editors for editing and debugging scripts.

教學課程:撰寫 Transact-SQL 陳述式Tutorial: Writing Transact-SQL Statements
本教學課程將提供撰寫 Transact-SQLTransact-SQL 陳述式以便建立和管理 SQL ServerSQL Server 資料庫中各種物件的基本技巧。This tutorial teaches the fundamental skills of writing the Transact-SQLTransact-SQL statements for creating and managing objects in a SQL ServerSQL Server database.

教學課程:Database Engine Tuning AdvisorTutorial: Database Engine Tuning Advisor
本教學課程將為您介紹如何使用此建議程式來檢查查詢的處理方式,然後檢閱改善查詢效能的建議。This tutorial introduces you to using the advisor to examine how queries are processed, and then review recommendations for improving query performance.

教學課程:使用 hierarchyid 資料類型Tutorial: Using the hierarchyid Data Type
本教學課程將說明如何轉換資料表為階層結構,然後管理該資料表中的資料。This tutorial teaches how to convert a table to a hierarchical structure, and then manage the data in the table.

教學課程:使用憑證簽署預存程序Tutorial: Signing Stored Procedures with a Certificate
這個教學課程說明如何使用由 SQL ServerSQL Server產生的憑證來簽署預存程序。This tutorial illustrates signing stored procedures using a certificate generated by SQL ServerSQL Server.

教學課程:擁有權鏈結和環境切換Tutorial: Ownership Chains and Context Switching
這個教學課程利用案例來說明涉及擁有權鏈結和使用者內容切換的 SQL ServerSQL Server 安全性概念。This tutorial uses a scenario to illustrate SQL ServerSQL Server security concepts involving ownership chains and user context switching.

教學課程:使用原則式管理來管理伺服器Tutorial: Administering Servers by Using Policy-Based Management
這個教學課程將說明如何建立強制執行網站管理標準的原則。This tutorial teaches how to create policies that enforce site administration standards.

教學課程:SQL Server 備份及還原至 Windows Azure Blob 儲存體服務Tutorial: SQL Server Backup and Restore to Windows Azure Blob Storage Service
本教學課程將說明如何執行 SQL Server 備份及還原到 Windows Azure Blob 儲存體服務。This tutorial illustrates how to do a SQL Server backup and restore to the Windows Azure Blob Storage Service.

教學課程:搭配使用 Microsoft Azure Blob 儲存體服務和 SQL Server 2016 資料庫Tutorial: Using the Microsoft Azure Blob storage service with SQL Server 2016 databases
本教學課程可協助您了解如何直接將 SQL Server 資料檔案儲存在 Windows Azure Blob 儲存體服務中。This tutorial helps you understand how to store SQL Server data files in the Windows Azure Blob storage service directly.

另請參閱See Also

適用於 SQL Server 2016 的教學課程Tutorials for SQL Server 2016
TechNet WIKI:SQL Server 2012 Samples (SQL Server 2012 範例)TechNet WIKI: SQL Server 2012 Samples