Mastering SQL Server 2017

More Information
  • Use columnstore indexes to get storage and performance improvements
  • Extend database design solutions using temporal tables
  • Exchange JSON data between applications and SQL Server
  • Migrate historical data to Microsoft Azure by using Stretch database
  • Design the architecture of a modern Extract Transform and Load (ETL) solution
  • Implement ETL solutions using Integration Services for both on-premises and Azure data

Mastering SQL Server 2017 brings in the power of R and Python for machine learning and containerization-based deployment on Windows and Linux. By knowing how to use the features of SQL Server 2017 to your advantage, you can build scalable applications and easily perform data integration and transformation.

This Learning Path shows you how to use Query Store, columnstore indexes, and In-Memory OLTP in your applications. You'll learn to integrate Python code in SQL Server and graph database implementations for development and testing. Next, you'll learn how to design and build SQL Server Integration Services (SSIS) data warehouses packages using SQL server data tools. You'll also learn 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 have the required information to easily design efficient, high-performance database applications. You'll also have explored on-premises big data integration processes to create a classic data warehouse.

This Learning Path includes content from the following Packt products:

• SQL Server 2017 Developer's Guide by Miloš Radivojević, Dejan Sarka, William Durkin

• SQL Server 2017 Integration Services Cookbook by Christian Cote, Dejan Sarka, Matija Lah

  • Work with temporal tables to get information stored in a table at any time
  • Get familiar with the newly introduced features in SQL Server 2017 Integration Services
  • Program and extend your packages to enhance their functionality
Page Count 612
Course Length 18 hours 21 minutes
ISBN 9781838983208
Date Of Publication 11 Aug 2019