積沙成塔

說明

對SQL Server相關技術有興趣的朋友有福了，如果您沒時間參加台灣微軟舉辦的各種免費研討會，或是沒預算去教育訓練機構進修，那麼不妨參考Microsoft Virtual Academy，這個線上學習網站提供各項微軟技術的線上教學，您可以挑選自己有興趣的課程內容來學習，而且非常有趣的是它會幫您累積經驗值，您上過多少課程都會忠實地被記錄下來，您可以跟台灣區域的網友們比賽您自修的經驗值，也可以和全球的技術同好來排名。

筆者幫各位整理了一系列SQL Server相關的學習課程以及電子書下載點，未來將持續更新，有興趣的朋友不妨參考看看。

---

Microsoft Virtual Academy

SQL Server版本	課程名稱	難易度等級
SQL Server 2014	Platform for Hybrid Cloud with SQL Server 2014 Jump Start	200
	Mission Critical Performance with SQL Server 2014 Jump Start	200
	SQL Server 2014 新特性	200
	SQL Server 2014 線上交易記憶體內資料庫簡介	200
	Updating your Database Management Skills to SQL Server 2014	100
	SQL Server 2014 Essentials for Oracle DBAs	200
	Faster Insights to Data with Power BI Jump Start	200
	Updating your Database Management Skills to SQL Server 2014	100
	必學的 SQL Server 2014 資料庫管理技巧	200
	SQL Server 2014 In-Memory 速成教學 (上)	200
	SQL Server 2014 In-Memory 速成教學 (下)	200
	SQL Server 於公有雲上的備份還原服務	200
	SQL Server 2014: Security, Optimizer, and Columnstore Index Enhancements	100
	必學的 SQL Server 2014 資料庫管理技巧	200
SQL Server 2012	Administering Microsoft SQL Server 2012 Jump Start	200
	Implementing a Data Warehouse with SQL Server Jump Start	200
	Private Cloud on your terms with Microsoft SQL Server 2012: Scale on demand	200
	Microsoft SQL Server 2012 training : Reporting Services	200
	Mission Critical Confidence using Microsoft SQL Server 2012	200
	Licensing SQL Server 2012	100
	Querying Microsoft SQL Server 2012 Databases Jump Start	200
	SQL Server 管理入門 (上)	100
	SQL Server 管理入門 (中)	100
	SQL Server 管理入門 (下)	100
	Breakthrough Insights using Microsoft SQL Server 2012 Training- Analysis Service	300
	Breakthrough Insights using Microsoft SQL Server 2012 - Scalable data warehouse	200
	SQL Server Essentials for Oracle DBAs Jump Start	200
	快速入门 : Microsoft SQL Server 2012 数据库查询	200
	SQL Server 管理入門 (一)：安裝、設定與連線	200
	SQL Server 管理入門 (二)：交易管理	200
	SQL Server 管理入門 (三)：安全性	200
	SQL Server 管理入門 (四)：自動化、維護與監控	200
	Tuning SQL Server 2012 for SharePoint 2013 Jump Start	200
	SQL Server Essentials for Oracle DBAs Jump Start	200
	Tuning SQL Server 2012 for SharePoint 2013 Jump Start	200
Microsoft Azure	SQL Azure in VM Role Jump Start	200
	SQL Server in Windows Azure Virtual Machines Jump Start	200
	Windows Azure SQL Database	200
	Faster Insights to Data with Power BI Jump Start	200
	SQL Server in Azure Virtual Machines - Developer Jump Start	100
	Platform for Hybrid Cloud with SQL Server 2014 Jump Start	200
	在 Microsoft Azure VM 上实现 SQL Server 高可用性及容灾设计	200
	雲端資料庫的 T-SQL 最佳化	200
	個頂尖雲端資料分析師 - 以 SQL Server 2014, Azure Machine Learning 及 HDinsight 活用微軟雲端大數據平台	200
	Azure SQL Database for Business-Critical Cloud Applications	200
	Virtualizing & Managing SQL Server Microsoft Cloud OS	200
	SQL Server 於公有雲上的備份還原服務	200
	Azure Gallery 一鍵佈署 SQL Server AlwaysOn	200
其他	如何做到企業系統的整併規劃、升級	200
	資料庫例行管理	200
	[DBI] 資料平台及商業智能 (Data Platform and Business Intelligence)	200
	Microsoft Corporate BI and SAP BI Integration Jump Start	200
Big Data	Big Data Analytics	200
	Getting Started with Microsoft Big Data	200

製表日期：2014/10/20 ｜ 資料來源：Microsoft Virtual Academy

---

E-Book Gallery for Microsoft Technologies

Virtualizing & Managing SQL Server Microsoft Cloud OS

語言	電子書
English	5 Tips for a Smooth SSIS Upgrade to SQL Server 2012
	A Hitchiker's Guide to Microsoft StreamInsight Queries
	Books Online: Backup and Restore of SQL Server Databases
	Books Online: Data Analysis Expressions (DAX) Reference
	Books Online: Data Mining Extensions (DMX) Reference
	Books Online: Data Quality Services
	Books Online: High Availability Solutions
	Books Online: Master Data Services
	Books Online: Monitor and Tune for Performance
	Books Online: Multidimensional Expressions (MDX) Reference
	Books Online: SQL Server Distributed Replay
	Books Online: Transact-SQL Data Definition Language (DDL) Reference
	Books Online: Transact-SQL Data Manipulation Language (DML) Reference
	Books Online: XQuery Language Reference
	Data Access for Highly-Scalable Solutions: Using SQL, NoSQL, and Polyglot Persistence
	Extracting and Loading SharePoint Data in SQL Server Integration Services
	Integration Services: Extending Packages with Scripting
	Introducing Microsoft SQL Server 2008 R2
	Introducing Microsoft SQL Server 2012
	Master Data Services Capacity Guidelines
	Master Data Services (MDS) Operations Guide
	Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery
	Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide
	Multidimensional Model Programming
	Optimized Bulk Loading of Data into Oracle
	Planning Disaster Recovery for Microsoft SQL Server Reporting Services in SharePoint Integrated Mode
	QuickStart: Learn DAX Basics in 30 Minutes
	SQLCAT's Guide to BI and Analytics
	SQLCAT's Guide to High Availability Disaster Recovery
	SQLCAT's Guide to Relational Engine
	SQL Server 2012 Tutorials: Analysis Services - Data Mining
	SQL Server 2012 Tutorials: Analysis Services - Multidimensional Modeling
	SQL Server 2012 Tutorials: Analysis Services - Tabular Modeling
	SQL Server 2012 Tutorials: Reporting Services
	SQL Server 2012 Tutorials: Writing Transact-SQL Statements
	SQL Server 2012 Upgrade Technical Guide
	SQL Server Community FAQs Manual
	Deploy SQL Server Business Intelligence in Windows Azure Virtual Machines
	Windows Azure and SQL Database Tutorials
簡體中文	SQL Server 2012 新功能简介白皮书
	SQL Server 2012 升级技术指南
	Microsoft SQL Server 2012 简介

製表日期：2014/1/7 ｜ 資料來源：Technet E-Book Gallery for Microsoft Technologies

---

免費電子書

來源	電子書名稱
redgate	Troubleshooting SQL Server: A Guide for the Accidental DBA
	Fundamentals of SQL Server 2012 Replication
	SQL Server Execution Plans, Second Edition
	Inside the SQL Server Query Optimizer
	The Red Gate Guide to SQL Server Team-based Development
	Defensive Database Programming
	SQL Server Transaction Log Management
	The Art of SQL Server FILESTREAM
	SQL Server Concurrency:Locking, Blocking and Row Versioning
	SQL Server Backup and Restore
	Troubleshooting SQL Server: A Guide for the Accidental DBA
	SQL Server Hardware
	SQL Server Statistics
	Performance Tuning with SQL Server Dynamic Management Views
	Brad's Sure Guide to SQL Server Maintenance Plans
	The Best of SQLServerCentral.com Vol 7
	Protecting SQL Server Data
	SQL Server Tacklebox
	How to become an Exceptional DBA, 2nd Edition
	SQL Server Stumpers Vol.5
	Mastering SQL Server Profiler
	SQL Server Execution Plans, Second Edition

製表日期：2014/5/30 | 資料來源：redgate

---

Channel 9

課程名稱	講師
如何做到企業系統的整併規劃，升級	Byron Hu
應用程式自動化佈署的好幫手 - InRelease for Visual Studio 2013
SQL Server 2014 線上交易記憶體內資料庫(Hekaton)概觀
深入了解 SQL Server 交易紀錄
SQL Server 2014預覽，劃時代的高效與雲端資料庫系統
如何做到企業系統的整併規劃、升級
跨洲際多點同時服務的資料庫解決方案，使用SQL Server 點對點的資料同步	Lewis Yang
深入討論Microsoft SQL Server索引使用技巧
DBA十大噩夢
SQL Server 2012 商業智慧語意表格式模型(BISM Tabular)開發與管理	Yin
Reporting Services整合SharePoint模式以建立企業級報表中心
運用 SQL Server 2012 Reporting Services 建立豐富視覺化報表
企業最佳公有雲整合應用: 延伸 SQL Server 至 Windows Azure SQL Database 並協助企業應用Windows Azure BizTalk Services 建立您第一個雲端B2B 服務	Hsu, Issac Song
你一定要知道：雲端資料庫的T-SQL最佳化	Lancelot Hsu
雲端資料庫的T-SQL最佳化
從Developer的角度來使用與整合Windows Azure SQL Database 與 SQL Server 2014	Sky Chang
在 Windows Azure 平台上進行資料庫處理及架構設計
Microsoft SQL Server 2014 In-Memory OLTP: Overview	Jos de Bruijn
Microsoft SQL Server 2014 In-Memory OLTP: DB Developer Deep Dive
Microsoft SQL Server 2014 In-Memory OLTP: Management Deep Dive

製表日期：2014/4/22 | 資料來源：Channel 9

---

TechNet Virtual Labs

SQL Server 版本	Lab 名稱
SQL Server 2014	What's new in SQL Server 2014 for DBAs
	Implementing HA/DR with SQL Server 2014 AlwaysOn Availability Groups
	Exploring AlwaysOn Failover Cluster Instances in SQL Server 2014
	Exploring AlwaysOn Availability Groups in SQL Server 2014
	Exploring online database operations in SQL Server 2014
	Exploring updatable ColumnStore indexes in SQL Server 2014
	Exploring Resource Governor IO enhancements in SQL Server 2014
	Exploring Buffer Pool Extensions in SQL Server 2014
	Exploring Distributed Replay in SQL Server 2014
	Exploring organizational security and auditing in SQL Server 2014
	Exploring Filestream Storage in SQL Server 2014
	Exploring In-Memory OLTP in SQL Server 2014
	Exploring self-service BI in SQL Server 2014, Microsoft Azure and Excel 2013
	Exploring corporate BI in SQL Server 2014
	Exploring Master Data Services and Data Quality Services in SQL Server 2014 and Excel 2013
	Exploring SQL Server 2014 database deployment in Microsoft Azure Virtual Machines
	Exploring manual and automatic database backup using Microsoft Azure storage in SQL Server 2014
SQL Server 2012	What's new for T-SQL in SQL Server 2012
	Creating a Microsoft SQL Server Reporting Services Report Based on a Tabular BI Semantic Model
	Creating a PowerPivot Workbook in Microsoft Excel 2013
	Creating a PerformancePoint Services dashboard based on a SQL Server 2012 BI Semantic Model
	Developing a SQL Server 2012 Tabular BI Semantic Model using SQL Server Data Tools
	Exploring Power View in SQL Server 2012
	Optimizing a SQL Server 2012 Tabular BI Semantic Model
	Implementing and Managing AlwaysOn Availability Groups
	Upgrading to SQL Server 2012 from SQL 2005/2008
	Installing SQL Server 2012 on Windows Server 2012
	Installing SQL Server 2012 on Windows 2012 Server Core
	Data Platform Showcase on SQL Server 2012
	Introduction to SQL Server 2012 AlwaysOn Availability Groups
	Exploring Power Map in Excel 2013
	Exploring Power Query in Excel 2013
	Exploring Power View in Excel 2013
SQL Server 2008 R2	Developing and Consuming Shared Components in SQL Server 2008 R2 Reporting Services
	Exploring PowerPivot for SharePoint
	Microsoft SQL Server 2008 R2: Up and Running with MDS
	Multi Server Management in Microsoft® SQL Server® 2008 R2
	SQL server 2008 R2 Power Pivot
	SQL Server 2008 R2 Reporting Services: Sparklines, Databars, and Indicators
	Upgrading to SQL Server 2008 R2 from SQL Server 2000 and SQL Server 2005
SQL Server 2008	Installing a SQL 2008 R2 Clustered Instance
	Managed Self-service BI
	Visualizing Data with Maps in Microsoft SQL Server 2008 R2 Reporting Services
Power BI	Using Power Query and Power Map in Excel 2013
	Exploring Office 365 Power BI
	Exploring SQL Server Data Tools for databases in Visual Studio 2013

製表日期：2014/9/17 | 資料來源：TechNet Virtual Labs

---

Microsoft Press

書名	作者	發行日期
Introducing Microsoft SQL Server 2014	Ross Mistry and Stacia Misner	April 2014
Introducing Microsoft Azure HDInsight	Avkash Chauhan, Valentine Fontama, Michele Hart, Wee Hyong Tok, and Buck Woody	May 2014
Microsoft Azure Essentials: Fundamentals of Azure	Michael S. Collier and Robin E. Shahan	February 2015

製表日期：2015/2/4 | 資料來源：Microsoft Press