2012
Pluralsight
Leonard Lobel
4h 13m
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.
FileName Size Length Bit rate Data rate Resolution Frame Rate Parent Folder
01.Course Introduction and Overview.mp4 6.81 MB 0:05:04 106kbps 78.00 848x640 15 frames/second 01.Course Introduction and Overview
01.What is SSDT.wmv 1.98 MB 0:03:06 48kbps 95.00 1024x768 15 frames/second 02.Introducing SQL Server Data Tools (SSDT)
02.Database Development Pains.wmv 2.80 MB 0:04:24 48kbps 171.00 1024x768 15 frames/second 02.Introducing SQL Server Data Tools (SSDT)
03.SSDT to the Rescue.wmv 7.57 MB 0:09:27 48kbps 448.00 1024x768 15 frames/second 02.Introducing SQL Server Data Tools (SSDT)
04.Demo - SQL Server Object Explorer.wmv 4.16 MB 0:03:01 48kbps 1720.00 1024x768 15 frames/second 02.Introducing SQL Server Data Tools (SSDT)
05.Demo - Using the Query Window.wmv 5.56 MB 0:06:04 48kbps 394.00 1024x768 15 frames/second 02.Introducing SQL Server Data Tools (SSDT)
06.Gathering New Requirements.wmv 2.66 MB 0:02:55 48kbps 192.00 1024x768 15 frames/second 02.Introducing SQL Server Data Tools (SSDT)
07.Demo - Table Designer and Power Buffer.wmv 10.3 MB 0:08:51 48kbps 399.00 1024x768 15 frames/second 02.Introducing SQL Server Data Tools (SSDT)
01.Introduction.mp4 1.31 MB 0:01:04 123kbps 46.00 848x640 15 frames/second 03.Advanced SSDT Features
02.Demo - Creating a SQL Server Database Project.mp4 13.8 MB 0:05:41 125kbps 210.00 848x640 15 frames/second 03.Advanced SSDT Features
03.Demo - Taking a Database Snapshot.mp4 3.10 MB 0:01:35 118kbps 151.00 848x640 15 frames/second 03.Advanced SSDT Features
04.Demo - Revisiting the Table Designer Offline.mp4 7.03 MB 0:02:57 127kbps 202.00 848x640 15 frames/second 03.Advanced SSDT Features
05.Demo - Creating a Foreign Key.mp4 5.77 MB 0:02:15 125kbps 229.00 848x640 15 frames/second 03.Advanced SSDT Features
06.Demo - Working with LocalDb.mp4 14.3 MB 0:05:28 126kbps 237.00 848x640 15 frames/second 03.Advanced SSDT Features
07.Demo - Updating a View.mp4 18.2 MB 0:06:14 127kbps 277.00 848x640 15 frames/second 03.Advanced SSDT Features
08.Demo - Database Refactoring.mp4 12.2 MB 0:03:38 125kbps 343.00 848x640 15 frames/second 03.Advanced SSDT Features
09.Demo - Debugging a Stored Procedure.mp4 25.3 MB 0:08:11 127kbps 302.00 848x640 15 frames/second 03.Advanced SSDT Features
10.Demo - Deploying with Schema Compare.mp4 25.7 MB 0:08:43 126kbps 283.00 848x640 15 frames/second 03.Advanced SSDT Features
11.Demo - Publishing to Windows Azure SQL Database.mp4 12.9 MB 0:05:10 125kbps 222.00 848x640 15 frames/second 03.Advanced SSDT Features
12.Demo - Creating a Final Snapshot.mp4 2.72 MB 0:01:14 119kbps 186.00 848x640 15 frames/second 03.Advanced SSDT Features
13.Summary.mp4 1.25 MB 0:01:09 129kbps 20.00 848x640 15 frames/second 03.Advanced SSDT Features
01.Introducing Table-Valued Parameters.mp4 5.22 MB 0:03:00 117kbps 122.00 848x640 15 frames/second 04.Table-Valued Parameters (TVPs)
02.Demo - Getting Started with TVPs.mp4 27.8 MB 0:09:21 123kbps 290.00 848x640 15 frames/second 04.Table-Valued Parameters (TVPs)
03.Demo - Passing TVPs from ADO.NET.mp4 14.0 MB 0:04:40 122kbps 292.00 848x640 15 frames/second 04.Table-Valued Parameters (TVPs)
04.Demo - Passing Collections to TVPs.mp4 25.5 MB 0:07:09 122kbps 374.00 848x640 15 frames/second 04.Table-Valued Parameters (TVPs)
05.Demo - Using TVPs for Bulk Operations.mp4 16.5 MB 0:04:55 123kbps 344.00 848x640 15 frames/second 04.Table-Valued Parameters (TVPs)
06.TVP Limitations.mp4 2.40 MB 0:01:32 109kbps 105.00 848x640 15 frames/second 04.Table-Valued Parameters (TVPs)
01.Introducing MERGE.mp4 9.41 MB 0:06:29 122kbps 77.00 848x640 15 frames/second 05.MERGE and INSERT OVER DML
02.Demo - Using MERGE to manage a stock portfolio.mp4 15.1 MB 0:05:10 125kbps 282.00 848x640 15 frames/second 05.MERGE and INSERT OVER DML
03.Demo - Replicating Tables with MERGE.mp4 13.6 MB 0:05:00 123kbps 254.00 848x640 15 frames/second 05.MERGE and INSERT OVER DML
04.Demo - Examining the Query Execution Plan for MERGE.mp4 7.82 MB 0:02:50 122kbps 260.00 848x64015 frames/second 05.MERGE and INSERT OVER DML
05.Introducing INSERT OVER DML.mp4 4.68 MB 0:02:37 119kbps 127.00 848x640 15 frames/second 05.MERGE and INSERT OVER DML
06.Demo - Capturing Change Data with OUTPUT INTO.mp4 10.5 MB 0:03:56 122kbps 248.00 848x640 15 frames/second 05.MERGE and INSERT OVER DML
07.Demo - Capturing Change Data with INSERT OVER DML.mp4 21.5 MB 0:07:47 124kbps 258.00 848x640 15 frames/second 05.MERGE and INSERT OVER DML
01.Windows on Data.mp4 12.5 MB 0:06:24 120kbps 149.00 848x640 15 frames/second 06.Windowing and the OVER Clause
02.Demo - OVER with Aggregate Functions.mp4 10.9 MB 0:03:03 122kbps 374.00 848x640 15 frames/second 06.Windowing and the OVER Clause
03.Demo - Running Aggregations.mp4 9.67 MB 0:02:36 120kbps 396.00 848x640 15 frames/second 06.Windowing and the OVER Clause
04.Demo - Sliding Aggregations.mp4 11.7 MB 0:03:14 118kbps 385.00 848x640 15 frames/second 06.Windowing and the OVER Clause
05.Demo - ROWS vs. RANGE.mp4 7.13 MB 0:02:33 116kbps 271.00 848x640 15 frames/second 06.Windowing and the OVER Clause
06.Understanding Lookup Functions.mp4 2.67 MB 0:01:37 118kbps 109.00 848x640 15 frames/second 06.Windowing and the OVER Clause
07.Demo - Window Lookup Functions.mp4 33.1 MB 0:08:09 126kbps 439.00 848x640 15 frames/second 06.Windowing and the OVER Clause
08.Understanding RANK and Percentiles.mp4 13.6 MB 0:08:08 122kbps 109.00 848x640 15 frames/second 06.Windowing and the OVER Clause
09.Demo - Window Percentile Functions.mp4 32.7 MB 0:09:41 125kbps 343.00 848x640 15 frames/second 06.Windowing and the OVER Clause
01.Demo - New Logical Functions.mp4 8.41 MB 0:03:54 124kbps 174.00 848x640 15 frames/second 07.Additional T-SQL Language Enhancements
02.Demo - New String Functions.mp4 22.3 MB 0:07:06 126kbps 308.00 848x640 15 frames/second 07.Additional T-SQL Language Enhancements
03.Demo - New Conversion Functions.mp4 11.6 MB 0:03:55 124kbps 288.00 848x640 15 frames/second 07.Additional T-SQL Language Enhancements
04.Demo - New DateTime Functions.mp4 13.2 MB 0:04:10 125kbps 316.00 848x640 15 frames/second 07.Additional T-SQL Language Enhancements
05.Demo - Changed Math Function.mp4 4.08 MB 0:01:18 126kbps 308.00 848x640 15 frames/second 07.Additional T-SQL Language Enhancements
06.Demo - The THROW Statement.mp4 36.8 MB 0:12:25 127kbps 284.00 848x640 15 frames/second 07.Additional T-SQL Language Enhancements
07.Demo - Server-Side Paging.mp4 14.5 MB 0:06:14 126kbps 197.00 848x640 15 frames/second 07.Additional T-SQL Language Enhancements
08.Demo - Sequences.mp4 16.9 MB 0:07:32 122kbps 187.00 848x640 15 frames/second 07.Additional T-SQL Language Enhancements
http://pluralsight.com/training/Courses/TableOfContents/sql2012-tools-and-enhancements
Download File Size:607.54 MB
|
