Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Learning SQL Server Development on Linux

via LinkedIn Learning

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.

The release of Microsoft SQL Server 2017 introduces a wide range of new features for developers—including the ability to leverage the power of the SQL Server engine on Linux operating systems. In this course, get up to speed with all of the exciting new features available in this platform, and learn about SQL Server on Linux. Instructor Joey D'Antoni also covers adaptive query processing, discussing batch mode adaptive joins, interleaved execution, and automatic tuning. He wraps up the course with a discussion of SQL Operations Studio, an open-source tool that you can use to manage SQL Server and Azure SQL Database from any platform.

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

Reviews

Start your review of Learning SQL Server Development on Linux

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free