Chapter 10

Database Features

Learning Objectives

By the end of this lesson, you will be able to:

  • Implement SQL Data Sync to sync an Azure SQL database with an on-premises database
  • Use SQL graph queries create and query graph tables
  • Implement SQL graph enhancements
  • Create a model to predict future sales using the Azure Machine Learning service

This lesson talks about improving performance using in-memory technologies, online and resumable DDL operations and also talks about SQL Graph queries and improvements.

This lesson also covers the machine learning feature to execute in-database R scripts.

Introduction

This lesson talks about the important database features available in an Azure SQL database. The lesson talks about SQL Data Sync ...

Get Professional Azure SQL Database Administration - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.