AI Data and Machine Learning, Workshops

M02 Workshop: SQL Server for Developers: The Grand Expedition

10/07/2019

8:00am - 5:00pm

Level: Intermediate

Andrew Brust

Founder and CEO

Blue Badge Insights

Leonard Lobel

MVP

CTO

Sleek Technologies, Inc.

This all-day workshop on SQL Server will provide coverage of a wide range of the platform's capabilities and optimal usage of them, from core features like security and T-SQL language improvements; to new innovations like running SQL Server in containers and utilizing temporal tables; to the latest in operational analytics, machine learning (ML) and Big Data. You'll learn about critical features that have been in the product for some time, as well as many of the latest features, delivered in SQL Server 2019. That's the tl;dr. For details, read on!

We'll kick things off with the most important features added to the relational engine, including broad multi-platform support across Windows, Linux, and Docker. Then you'll explore all the latest T-SQL enhancements, including more convenient DDL statements, new string split, join, and aggregate functions, partition truncation, and other language improvements. But data platforms aren't just about operational databases anymore, and neither is SQL Server. So we'll next move on to its analytics capabilities, starting with columnstore indexes: what they are; how to create them; how they benefit massive data warehouse-style queries; and tips for monitoring how they're used in query plans.

From there we'll look at PolyBase, including its connectivity to data lakes on Hadoop clusters and cloud storage as well new connectivity to databases like Oracle, Teradata, MongoDB and even additional SQL Server instances. Next, we'll look at SQL Server's Big Data clusters and their incorporation of technologies like Apache Spark, the Hadoop Distributed File System (HDFS) and data stored in the Apache Parquet columnar format.

We'll start to wind down our analytics tour with a look at SQL Server's machine learning capabilities, including in-database features made possible by native hosting of the Python and R programming languages. And as the last stop on our analytics tour, we'll take in how to use Azure Data Studio to query SQL Server and the platforms it integrates with, as well as leverage SQL Server's data science features.

Our workshop continues with the latest security features, including dynamic data masking (DDM), row level security (RLS), and Always Encrypted. You'll also get a look at the new "secure enclaves" feature in SQL Server 2019 that enables rich query and range operations on always encrypted data. We'll conclude by exploring temporal tables (versioned tables that enable instant point-in-time queries over your data) and Stretch DB for online archival of historical data.

Attend this workshop, designed especially for developers, and get up-to-speed on both the latest relevant SQL Server features and the product's classic critical capabilities!

You will learn:

  • How to accelerate your database development process by running cross-platform SQL Server inside containers with Docker
  • The latest T-SQL language enhancements, plus DDM, RLS, Always Encrypted, temporal tables, and Stretch DB
  • How to use SQL Server for data warehouse, big data and machine learning workloads
  • The basics of new SQL Server-integrated open source technologies, including Spark, HDFS, Python, R and Parquet