Learning SQL Server Development on Linux

Go to class
Write Review

Free Online Course: Learning SQL Server Development on Linux provided by LinkedIn Learning is a comprehensive online course, which lasts for 1-2 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Learning SQL Server Development on Linux is taught by Joey D'Antoni.

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