Mastering SQL Server 2017

Mastering SQL Server 2017 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. (Limited-time offer)

Table of Contents

• Introduction to SQL Server 2017
• SQL Server Tools
• JSON Support in SQL Server
• Stretch Database
• Temporal Tables
• Columnstore Indexes
• SSIS Setup
• What Is New in SSIS 2016
• Key Components of a Modern ETL Solution
• Dealing with Data Quality
• Unleash the Power of SSIS Script Task and Component
• On-Premises and Azure Big Data Integration
• Extending SSIS Custom Tasks and Transformations
• Scale Out with SSIS 2017

Download Free PDF / Read Online