Exploring SQL Server Tools and Language Enhancements
Offered By: Pluralsight
Course Description
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.
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
Related Courses
Deploying Databases with OctopusPluralsight SQL Server: Developer and DBA Collaboration
LinkedIn Learning Visual Studio Essential Training: 11 Data Tools
LinkedIn Learning Entity Framework Migrations Course (How To)
Treehouse Amazon Neptune: Best Practices
Pluralsight