MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Exploring SQL Server Tools and Language Enhancements

Course Summary

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 d

  • +

    Course Syllabus

    ● Course Introduction and Overview
        ◦ Course Introduction and Overview
    ● Introducing SQL Server Data Tools (SSDT)
        ◦ What is SSDT?
        ◦ Database Development Pains
        ◦ SSDT to the Rescue
        ◦ Demo: SQL Server Object Explorer
        ◦ Demo: Using the Query Window
        ◦ Gathering New Requirements
        ◦ Demo: Table Designer and Power Buffer
    ● Advanced SSDT Features
        ◦ Introduction
        ◦ Demo: Creating a SQL Server Database Project
        ◦ Demo: Taking a Database Snapshot
        ◦ Demo: Revisiting the Table Designer Offline
        ◦ Demo: Creating a Foreign Key
        ◦ Demo: Working with LocalDb
        ◦ Demo: Updating a View
        ◦ Demo: Database Refactoring
        ◦ Demo: Debugging a Stored Procedure
        ◦ Demo: Deploying with Schema Compare
        ◦ Demo: Publishing to Windows Azure SQL Database
        ◦ Demo: Creating a Final Snapshot
        ◦ Summary
    ● Table-Valued Parameters (TVPs)
        ◦ Introducing Table-Valued Parameters
        ◦ Demo: Getting Started with TVPs
        ◦ Demo: Passing TVPs from ADO.NET
        ◦ Demo: Passing Collections to TVPs
        ◦ Demo: Using TVPs for Bulk Operations
        ◦ TVP Limitations
        ◦ Introducing MERGE
        ◦ Demo: Using MERGE to manage a stock portfolio
        ◦ Demo: Replicating Tables with MERGE
        ◦ Demo: Examining the Query Execution Plan for MERGE
        ◦ Introducing INSERT OVER DML
        ◦ Demo: Capturing Change Data with OUTPUT INTO
        ◦ Demo: Capturing Change Data with INSERT OVER DML
    ● Windowing and the OVER Clause
        ◦ Windows on Data
        ◦ Demo: OVER with Aggregate Functions
        ◦ Demo: Running Aggregations
        ◦ Demo: Sliding Aggregations
        ◦ Demo: ROWS vs. RANGE
        ◦ Understanding Lookup Functions
        ◦ Demo: Window Lookup Functions
        ◦ Understanding RANK and Percentiles
        ◦ Demo: Window Percentile Functions
    ● Additional T-SQL Language Enhancements
        ◦ Demo: New Logical Functions
        ◦ Demo: New String Functions
        ◦ Demo: New Conversion Functions
        ◦ Demo: New Date/Time Functions
        ◦ Demo: Changed Math Function
        ◦ Demo: The THROW Statement
        ◦ Demo: Server-Side Paging
        ◦ Demo: Sequences


Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top