2012
Pluralsight
Christopher Harrison
3h 40m
English
Part 2 of 2 in the SQL Server 2012 Querying (70-461) series is designed to teach students how to query and work with a SQL Server 2012 database.
Skills gained will include querying a database using joins and data aggregations and query optimization.
This course includes basic management of database objects and using XML SQL Server.
FileName Size Length Bit rate Data rate Resolution Frame Rate Parent Folder
01.Introduction 1.85 MB 0:01:03 128kbps 387.00 1024x768 15 frames/second 01.Managing Transactions
02.Transactions 9.88 MB 0:06:27 128kbps 421.00 1024x768 15 frames/second 01.Managing Transactions
03.Concurrency 6.95 MB 0:04:54 128kbps 95.00 1024x768 15 frames/second 01.Managing Transactions
04.Concurrency Issues 8.55 MB 0:05:51 128kbps 114.00 1024x768 15 frames/second 01.Managing Transactions
05.Read Noncommitted 4.46 MB 0:02:38 128kbps 412.00 1024x768 15 frames/second 01.Managing Transactions
06.Read Committed 4.44 MB 0:02:15 128kbps 757.00 1024x768 15 frames/second 01.Managing Transactions
07.Repeatable Read 7.81 MB 0:04:41 128kbps 525.00 1024x768 15 frames/second 01.Managing Transactions
08.Serializable 9.39 MB 0:05:47 128kbps 179.00 1024x768 15 frames/second 01.Managing Transactions
09.Snapshot 11.0 MB 0:06:17 128kbps 649.00 1024x768 15 frames/second 01.Managing Transactions
01.Try-Catch 14.7 MB 0:09:12 128kbps 462.00 1024x768 15 frames/second 02.Implementing Error Handling
02.Raising Errors 5.90 MB 0:03:41 128kbps 477.00 1024x768 15 frames/second 02.Implementing Error Handling
03.Using THROW 5.55 MB 0:03:13 128kbps 466.00 1024x768 15 frames/second 02.Implementing Error Handling
01.Introduction 1.23 MB 0:00:50 128kbps 70.00 1024x768 15 frames/second 03.XML Basics
02.XML Concepts 4.75 MB 0:03:24 128kbps 74.00 1024x768 15 frames/second 03.XML Basics
03.Well-Formed Documents 8.12 MB 0:05:34 128kbps 474.00 1024x768 15 frames/second 03.XML Basics
04.Validation 8.65 MB 0:05:33 128kbps 472.00 1024x768 15 frames/second 03.XML Basics
01.Using FOR XML 14.2 MB 0:08:16 128kbps 496.00 1024x768 15 frames/second 04.Retrieving XML
02.FOR XML AUTO 9.91 MB 0:05:22 128kbps 546.00 1024x768 15 frames/second 04.Retrieving XML
03.Controlling XML Creation 7.29 MB 0:04:17 128kbps 536.00 1024x768 15 frames/second 04.Retrieving XML
01.XML Datatype 8.20 MB 0:05:17 128kbps 547.00 1024x768 15 frames/second 05.Importing XML
02.Using OPENXML 3.98 MB 0:02:50 128kbps 71.00 1024x768 15 frames/second 05.Importing XML
03.OPENXML Demo 8.38 MB 0:05:03 128kbps 385.00 1024x768 15 frames/second 05.Importing XML
01.Designing Tables 13.9 MB 0:09:52 128kbps 87.00 1024x768 15 frames/second 06.Creating and Altering Tables
02.Managing Tables 5.80 MB 0:03:41 128kbps 317.00 1024x768 15 frames/second 06.Creating and Altering Tables
03.Altering Tables 6.04 MB 0:02:59 128kbps 555.00 1024x768 15 frames/second 06.Creating and Altering Tables
01.Introduction 962 KB 0:00:37 128kbps 88.00 1024x768 15 frames/second 07.Data Validation with Constraints
02.Data Validation Concepts 4.53 MB 0:03:15 128kbps 56.00 1024x768 15 frames/second 07.Data Validation with Constraints
03.Implementing Constraints 9.32 MB 0:05:27 128kbps 573.00 1024x768 15 frames/second 07.Data Validation with Constraints
04.Identity Columns 18.3 MB 0:10:51 128kbps 613.00 1024x768 15 frames/second 07.Data Validation with Constraints
05.Primary Key Constraints 6.57 MB 0:03:50 128kbps 623.00 1024x768 15 frames/second 07.Data Validation with Constraints
06.Foreign Key Cascade Options 2.45 MB 0:01:42 128kbps 68.00 1024x768 15 frames/second 07.Data Validation with Constraints
07.Foreign Key Cascade Demo 18.8 MB 0:11:28 128kbps 451.00 1024x768 15 frames/second 07.Data Validation with Constraints
01.Introduction 1.23 MB 0:00:47 128kbps 103.00 1024x768 15 frames/second 08.Creating and Modifying Triggers
02.Trigger Concepts 5.77 MB 0:03:56 128kbps 84.00 1024x768 15 frames/second 08.Creating and Modifying Triggers
03.Creating Triggers 3.76 MB 0:02:36 128kbps 79.00 1024x768 15 frames/second 08.Creating and Modifying Triggers
04.Triggers Demo 16.6 MB 0:10:41 128kbps 489.00 1024x768 15 frames/second 08.Creating and Modifying Triggers
01.View Concepts 9.72 MB 0:06:55 128kbps 129.00 1024x768 15 frames/second 09.Creating and Modifying Views
02.View Syntax 4.96 MB 0:03:33 128kbps 87.00 1024x768 15 frames/second 09.Creating and Modifying Views
03.View Demo 8.98 MB 0:05:15 128kbps 456.00 1024x768 15 frames/second 09.Creating and Modifying Views
01.Stored Procedure Concepts 5.16 MB 0:03:38 128kbps 96.00 1024x768 15 frames/second 10.Creating and Modifying Stored Procedures
02.Creating Stored Procedures 7.29 MB 0:05:10 128kbps 82.00 1024x768 15 frames/second 10.Creating and Modifying Stored Procedures
03.Stored Procedure Demo 6.66 MB 0:04:19 128kbps 430.00 1024x768 15 frames/second 10.Creating and Modifying Stored Procedures
01.Introduction 997 KB 0:00:38 128kbps 97.00 1024x768 15 frames/second 11.Creating and Modifying User Defined Functions
02.User Defined Function Concepts 2.64 MB 0:01:50 128kbps 73.00 1024x768 15 frames/second 11.Creating and Modifying User Defined Functions
03.Creating User Defined Functions 17.2 MB 0:10:35 128kbps 595.00 1024x768 15 frames/second 11.Creating and Modifying User Defined Functions
04.Apply Operators 6.75 MB 0:03:47 128kbps 537.00 1024x768 15 frames/second 11.Creating and Modifying User Defined Functions
Download File Size:278.11 MB
|
