Learning SQL Server Development on Linux

Offered By: LinkedIn Learning

Tags

SQL Courses Linux Courses Relational Databases Courses Query Tuning Courses

Course Description

Overview

Get up to speed with all of the exciting new features available in Microsoft SQL Server 2017, and learn about SQL Server on Linux.

Syllabus

Introduction

Welcome
Tools and techniques

1. New Features Overview

New features: SQL Server 2017 overview
Introduction to SQL Graph
Querying with SQL Graph
Tuning SQL Graph queries
Temporal data enhancements
String functions in SQL 2017
Bulk insert using Azure Blob Storage

2. Adaptive Query Processing

Introduction to adaptive query processing
Batch mode adaptive joins
Batch mode memory grant feedback
Interleaved execution
Parameter sniffing overview
Automatic tuning

3. SQL Server on Linux

Introduction to SQL Server on Linux
Getting started with Docker containers and SQL
SQL Server on Linux development
Deploying CLR code with SQL Server on Linux
Command-line tools on Linux
SQL Server Agent on Linux

4. SQL Server Operations Studio

Getting started with SQL Operations Studio
Using snippets
Code deployment using GIT

Conclusion

Next steps

Taught by

Joey D'Antoni

Related Courses

Introduction to Linux
Linux Foundation via edX 操作系统原理（Operating Systems）
Peking University via Coursera Internet of Things: Setting Up Your DragonBoard™ Development Platform
University of California, San Diego via Coursera Information Security-3
Indian Institute of Technology Madras via Swayam Introduction to Embedded Systems Software and Development Environments
University of Colorado Boulder via Coursera