Exploring SQL Server Tools and Language Enhancements

An introduction to SQL Server Data Tools (SSDT) and T-SQL enhancements.
Course info
Rating
(124)
Level
Intermediate
Updated
December 19, 2012
Duration
4h 13m
Table of contents
Description
Course info
Rating
(124)
Level
Intermediate
Updated
December 19, 2012
Duration
4h 13m
Description

This course explores the new developer-centric SQL Server Data Tools introduced with SQL Server 2012, including advanced SSDT topics such as snapshots, schema compares, and database deployment to both on-premise and cloud-based servers. In addition to a deep exploration of SSDT, several enhancements to the T-SQL language in SQL Server 2008 and SQL Server 2012 are explored, including table-valued parameters (TVPs), MERGE, windowing, sequence objects, error handling and host of new built-in functions.

About the author
About the author

Leonard Lobel (Microsoft MVP, SQL Server) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner. Lenni is also a consultant, trainer, and frequent speaker at major industry conferences.

More from the author
SQL Server 2016 New Features for Developers
Intermediate
3h 42m
15 Oct 2016
Introduction to Azure DocumentDB
Beginner
5h 5m
24 Sep 2015
SQL Server 2012-2014 Native File Streaming
Intermediate
3h 51m
13 Feb 2015