Mastering SQL Server 2017
暫譯: 精通 SQL Server 2017
Radivojevic, Milos, Sarka, Dejan, Durkin, William
- 出版商: Packt Publishing
- 出版日期: 2019-08-14
- 售價: $2,060
- 貴賓價: 9.5 折 $1,957
- 語言: 英文
- 頁數: 696
- 裝訂: Quality Paper - also called trade paper
- ISBN: 1838983201
- ISBN-13: 9781838983208
-
相關分類:
MSSQL、SQL
海外代購書籍(需單獨結帳)
商品描述
Microsoft SQL Server 2017 uses the power of R and Python for machine learning and containerization-based deployment on Windows and Linux. By learning how to use the features of SQL Server 2017 effectively, you can build scalable apps and easily perform data integration and transformation.
You’ll start by brushing up on the features of SQL Server 2017. This Learning Path will then demonstrate how you can use Query Store, columnstore indexes, and In-Memory OLTP in your apps. You'll also learn to integrate Python code in SQL Server and graph database implementations for development and testing. Next, you'll get up to speed with designing and building SQL Server Integration Services (SSIS) data warehouse packages using SQL server data tools. Toward the concluding chapters, you’ll discover how to develop SSIS packages designed to maintain a data warehouse using the data flow and other control flow tasks.
By the end of this Learning Path, you'll be equipped with the skills you need to design efficient, high-performance database applications with confidence.
This Learning Path includes content from the following Packt books:
SQL Server 2017 Developer's Guide by Miloš Radivojević, Dejan Sarka, et. al
SQL Server 2017 Integration Services Cookbook by Christian Cote, Dejan Sarka, et. al
商品描述(中文翻譯)
Microsoft SQL Server 2017 利用 R 和 Python 的強大功能進行機器學習以及在 Windows 和 Linux 上的容器化部署。透過有效學習 SQL Server 2017 的功能,您可以構建可擴展的應用程式,並輕鬆執行資料整合和轉換。
您將首先回顧 SQL Server 2017 的功能。這條學習路徑將展示如何在您的應用程式中使用查詢儲存(Query Store)、列儲索引(columnstore indexes)和記憶體內 OLTP(In-Memory OLTP)。您還將學習如何在 SQL Server 中整合 Python 代碼以及圖形資料庫的實作以進行開發和測試。接下來,您將熟悉使用 SQL Server 數據工具設計和構建 SQL Server 整合服務(SSIS)資料倉儲包。在最後幾章中,您將發現如何開發旨在維護資料倉儲的 SSIS 包,使用資料流和其他控制流任務。
在這條學習路徑結束時,您將具備設計高效、高性能資料庫應用程式所需的技能,並能夠自信地進行開發。
這條學習路徑包含以下 Packt 書籍的內容:
《SQL Server 2017 Developer's Guide》由 Miloš Radivojević、Dejan Sarka 等人著作
《SQL Server 2017 Integration Services Cookbook》由 Christian Cote、Dejan Sarka 等人著作
作者簡介
Miloš Radivojević
Miloš Radivojević is a data platform MVP and specializes in SQL Server for application developers and performance/ query tuning. Miloš is a co-founder of PASS Austria.
Dejan Sarka
Dejan Sarka, MCT and Microsoft Data Platform MVP, is an independent trainer and consultant who focuses on the development of database and business intelligence applications. He is the founder of the Slovenian SQL Server and .NET Users Group.
William Durkin
William Durkin is a data platform architect for Data Masterminds, he is a regular speaker at conferences around the globe, a Data Platform MVP, and the founder of the popular SQLGrillen event.
Christian Coté
Christian Coté is an MS-certified technical specialist in business intelligence (MCTS-BI). His ETL projects have used various ETL tools and plain code with various RDBMSes (such as Oracle and SQL Server).
Matija Lah
Matija Lah has more than 15 years of experience working with Microsoft SQL Server, mostly from architecting data-centric solutions in the legal domain.
作者簡介(中文翻譯)
Miloš Radivojević
Miloš Radivojević 是一位數據平台 MVP,專注於應用開發者的 SQL Server 以及性能/查詢調優。Miloš 是 PASS Austria 的共同創辦人。
Dejan Sarka
Dejan Sarka,MCT 和 Microsoft Data Platform MVP,是一位獨立的培訓師和顧問,專注於數據庫和商業智慧應用的開發。他是斯洛維尼亞 SQL Server 和 .NET 使用者群的創辦人。
William Durkin
William Durkin 是 Data Masterminds 的數據平台架構師,他是全球各地會議的常規演講者,數據平台 MVP,以及受歡迎的 SQLGrillen 活動的創辦人。
Christian Coté
Christian Coté 是一位 MS 認證的商業智慧技術專家 (MCTS-BI)。他的 ETL 項目使用了各種 ETL 工具和純代碼,並與多種 RDBMS(如 Oracle 和 SQL Server)配合使用。
Matija Lah
Matija Lah 擁有超過 15 年的 Microsoft SQL Server 工作經驗,主要專注於法律領域的數據中心解決方案架構。