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

Pluralsight

Exploring SQL Server Tools and Language Enhancements

via Pluralsight

Overview

An introduction to SQL Server Data Tools (SSDT) and T-SQL enhancements.

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.

Syllabus

  • Course Introduction and Overview 5mins
  • Introducing SQL Server Data Tools (SSDT) 37mins
  • Advanced SSDT Features 53mins
  • Table-Valued Parameters (TVPs) 30mins
  • MERGE and INSERT OVER DML 33mins
  • Windowing and the OVER Clause 45mins
  • Additional T-SQL Language Enhancements 46mins

Taught by

Leonard Lobel

Reviews

4.6 rating at Pluralsight based on 136 ratings

Start your review of Exploring SQL Server Tools and Language Enhancements

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.