自我修練 SQL Server 懶人包

筆者為您整理出一系列MVA有關SQL Server的精彩課程。

說明

對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