Course
Skills Expanded
Exploring SQL Server Tools and Language Enhancements
An introduction to SQL Server Data Tools (SSDT) and T-SQL enhancements.
What you'll learn
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.
Table of contents
Course Introduction and Overview
5mins
Introducing SQL Server Data Tools (SSDT)
37mins
Advanced SSDT Features
53mins
- Introduction 1m
- Demo: Creating a SQL Server Database Project 6m
- Demo: Taking a Database Snapshot 2m
- Demo: Revisiting the Table Designer Offline 3m
- Demo: Creating a Foreign Key 2m
- Demo: Working with LocalDb 5m
- Demo: Updating a View 6m
- Demo: Database Refactoring 4m
- Demo: Debugging a Stored Procedure 8m
- Demo: Deploying with Schema Compare 9m
- Demo: Publishing to Windows Azure SQL Database 5m
- Demo: Creating a Final Snapshot 1m
- Summary 1m
Table-Valued Parameters (TVPs)
30mins
MERGE and INSERT OVER DML
33mins
Windowing and the OVER Clause
45mins