Exploring SQL Server Tools and Language Enhancements | 630MB

Duration: 4h 13m | Video: AVC (.mp4) 848x640 15fps | Audio: AAC 44.1KHz 2ch

Genre: eLearning | Level: Intermediate | Language: English

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.