Exploring SQL Server Tools and Language Enhancements
An introduction to SQL Server Data Tools (SSDT) and T-SQL enhancements.
Authored by:
Leonard Lobel
Duration: 4h 13m
Level: Intermediate
Released: 12/19/2012
Features:
Duration: 4h 13m
Level: Intermediate
Released: 12/19/2012
Features:
Course Rating:
You are currently not signed in. Please sign in to access subscriber-only content.
Currently using: {{getCurrentPlayerName()}} [Change]
| expand all | collapse all | Progress | Duration | |
|---|---|---|---|
 Course Introduction and Overview |
|
00:05:04 | |
|
Course Introduction and Overview
|
|
05:04 | |
|
Introducing SQL Server Data Tools (SSDT) |
|
00:37:53 | |
|
What is SSDT?
|
|
03:07 | |
|
Database Development Pains
|
|
04:25 | |
|
SSDT to the Rescue
|
|
09:28 | |
|
Demo: SQL Server Object Explorer
|
|
03:01 | |
|
Demo: Using the Query Window
|
|
06:05 | |
|
Gathering New Requirements
|
|
02:55 | |
|
Demo: Table Designer and Power Buffer
|
|
08:52 | |
|
Advanced SSDT Features |
|
00:53:27 | |
|
Introduction
|
|
01:05 | |
|
Demo: Creating a SQL Server Database Project
|
|
05:41 | |
|
Demo: Taking a Database Snapshot
|
|
01:35 | |
|
Demo: Revisiting the Table Designer Offline
|
|
02:58 | |
|
Demo: Creating a Foreign Key
|
|
02:16 | |
|
Demo: Working with LocalDb
|
|
05:29 | |
|
Demo: Updating a View
|
|
06:14 | |
|
Demo: Database Refactoring
|
|
03:39 | |
|
Demo: Debugging a Stored Procedure
|
|
08:12 | |
|
Demo: Deploying with Schema Compare
|
|
08:44 | |
|
Demo: Publishing to Windows Azure SQL Database
|
|
05:10 | |
|
Demo: Creating a Final Snapshot
|
|
01:14 | |
|
Summary
|
|
01:10 | |
|
Table-Valued Parameters (TVPs) |
|
00:30:43 | |
|
Introducing Table-Valued Parameters
|
|
03:01 | |
|
Demo: Getting Started with TVPs
|
|
09:22 | |
|
Demo: Passing TVPs from ADO.NET
|
|
04:41 | |
|
Demo: Passing Collections to TVPs
|
|
07:10 | |
|
Demo: Using TVPs for Bulk Operations
|
|
04:56 | |
|
TVP Limitations
|
|
01:33 | |
|
MERGE and INSERT OVER DML |
|
00:33:54 | |
|
Introducing MERGE
|
|
06:30 | |
|
Demo: Using MERGE to manage a stock portfolio
|
|
05:11 | |
|
Demo: Replicating Tables with MERGE
|
|
05:00 | |
|
Demo: Examining the Query Execution Plan for MERGE
|
|
02:50 | |
|
Introducing INSERT OVER DML
|
|
02:38 | |
|
Demo: Capturing Change Data with OUTPUT INTO
|
|
03:57 | |
|
Demo: Capturing Change Data with INSERT OVER DML
|
|
07:48 | |
|
Windowing and the OVER Clause |
|
00:45:30 | |
|
Windows on Data
|
|
06:25 | |
|
Demo: OVER with Aggregate Functions
|
|
03:04 | |
|
Demo: Running Aggregations
|
|
02:36 | |
|
Demo: Sliding Aggregations
|
|
03:15 | |
|
Demo: ROWS vs. RANGE
|
|
02:33 | |
|
Understanding Lookup Functions
|
|
01:37 | |
|
Demo: Window Lookup Functions
|
|
08:10 | |
|
Understanding RANK and Percentiles
|
|
08:09 | |
|
Demo: Window Percentile Functions
|
|
09:41 | |
|
Additional T-SQL Language Enhancements |
|
00:46:39 | |
|
Demo: New Logical Functions
|
|
03:55 | |
|
Demo: New String Functions
|
|
07:07 | |
|
Demo: New Conversion Functions
|
|
03:55 | |
|
Demo: New Date/Time Functions
|
|
04:11 | |
|
Demo: Changed Math Function
|
|
01:19 | |
|
Demo: The THROW Statement
|
|
12:26 | |
|
Demo: Server-Side Paging
|
|
06:14 | |
|
Demo: Sequences
|
|
07:32 |
