2012
Pluralsight
Christopher Harrison
5h 12m
English
Part 1 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.Intended Audience 4.73 MB 0:03:00 128kbps 406.00 1024x768 15 frames/second 01.Introduction to SQL Server 2012
02.Using This Course 5.80 MB 0:03:58 128kbps 84.00 1024x768 15 frames/second 01.Introduction to SQL Server 2012
03.Syntax Notes 2.45 MB 0:01:42 128kbps 59.00 1024x768 15 frames/second 01.Introduction to SQL Server 2012
01.Introduction 1.69 MB 0:01:07 128kbps 95.00 1024x768 15 frames/second 02.Introduction to Relational Databases
02.Database Concepts 4.53 MB 0:03:12 128kbps 88.00 1024x768 15 frames/second 02.Introduction to Relational Databases
03.Table Concepts 19.8 MB 0:13:45 128kbps 77.00 1024x768 15 frames/second 02.Introduction to Relational Databases
04.Table Design 5.34 MB 0:03:41 128kbps 90.00 1024x768 15 frames/second 02.Introduction to Relational Databases
05.Design Scenario 13.2 MB 0:08:56 128kbps 146.00 1024x768 15 frames/second 02.Introduction to Relational Databases
06.Orders and Products Notes 5.98 MB 0:04:08 128kbps 118.00 1024x768 15 frames/second 02.Introduction to Relational Databases
07.Working with Data 4.58 MB 0:03:09 128kbps 88.00 1024x768 15 frames/second 02.Introduction to Relational Databases
01.Management Studio Basics 18.3 MB 0:11:39 128kbps 609.00 1024x768 15 frames/second 03.Introduction to SELECT Statements
02.Referencing Objects 7.23 MB 0:05:16 128kbps 105.00 1024x768 15 frames/second 03.Introduction to SELECT Statements
03.Structure of a SELECT Statement 2.80 MB 0:01:53 128kbps 64.00 1024x768 15 frames/second 03.Introduction to SELECT Statements
04.Using SELECT Statements 18.0 MB 0:11:32 128kbps 546.00 1024x768 15 frames/second 03.Introduction to SELECT Statements
05.Column Aliases 8.33 MB 0:04:28 128kbps 639.00 1024x768 15 frames/second 03.Introduction to SELECT Statements
01.WHERE Statements 8.58 MB 0:05:38 128kbps 470.00 1024x768 15 frames/second 04.Filtering Results with WHERE Statements
02.Predicate Keywords 10.6 MB 0:05:05 128kbps 994.00 1024x768 15 frames/second 04.Filtering Results with WHERE Statements
03.Querying Strings with LIKE 14.0 MB 0:07:54 128kbps 648.00 1024x768 15 frames/second 04.Filtering Results with WHERE Statements
04.Filtering NULL Data 2.32 MB 0:01:14 128kbps 488.00 1024x768 15 frames/second 04.Filtering Results with WHERE Statements
01.Join Basics 7.08 MB 0:04:59 128kbps 102.00 1024x768 15 frames/second 05.Utilizing Joins
02.Join Syntax 9.73 MB 0:06:39 128kbps 487.00 1024x768 15 frames/second 05.Utilizing Joins
03.Inner Joins 9.01 MB 0:05:31 128kbps 647.00 1024x768 15 frames/second 05.Utilizing Joins
04.Outer Joins 9.00 MB 0:06:01 128kbps 438.00 1024x768 15 frames/second 05.Utilizing Joins
05.Self Joins 8.56 MB 0:05:55 128kbps 377.00 1024x768 15 frames/second 05.Utilizing Joins
06.Cross Joins 4.70 MB 0:02:34 128kbps 726.00 1024x768 15 frames/second 05.Utilizing Joins
01.Subquery Concepts 3.93 MB 0:02:37 128kbps 106.00 1024x768 15 frames/second 06.Executing Subqueries and UNION Statements
02.Using Subqueries 13.3 MB 0:08:07 128kbps 427.00 1024x768 15 frames/second 06.Executing Subqueries and UNION Statements
03.Predicates Used with Subqueries 12.6 MB 0:07:20 128kbps 448.00 1024x768 15 frames/second 06.Executing Subqueries and UNION Statements
04.UNION Statements 1.37 MB 0:00:54 128kbps 94.00 1024x768 15 frames/second 06.Executing Subqueries and UNION Statements
05.UNION Requirements 8.00 MB 0:04:42 128kbps 588.00 1024x768 15 frames/second 06.Executing Subqueries and UNION Statements
01.Introduction 2.04 MB 0:01:24 128kbps 78.00 1024x768 15 frames/second 07.Aggregating Data
02.Using Aggregate Functions 11.6 MB 0:07:43 128kbps 428.00 1024x768 15 frames/second 07.Aggregating Data
03.Using GROUP BY 7.09 MB 0:04:25 128kbps 456.00 1024x768 15 frames/second 07.Aggregating Data
04.Using HAVING 4.74 MB 0:02:56 128kbps 574.00 1024x768 15 frames/second 07.Aggregating Data
05.HAVING vs. WHERE 5.59 MB 0:03:24 128kbps 587.00 1024x768 15 frames/second 07.Aggregating Data
06.Data Rollups 19.1 MB 0:11:06 128kbps 535.00 1024x768 15 frames/second 07.Aggregating Data
07.GROUPING SETS 4.69 MB 0:02:42 128kbps 735.00 1024x768 15 frames/second 07.Aggregating Data
08.GROUPING and GROUPING_ID 7.64 MB 0:03:56 128kbps 576.00 1024x768 15 frames/second 07.Aggregating Data
01.Common Table Expressions (CTEs) 8.01 MB 0:04:58 128kbps 399.00 1024x768 15 frames/second 08.Advanced Data Aggregations
02.PIVOT and UNPIVOT 17.9 MB 0:10:58 128kbps 709.00 1024x768 15 frames/second 08.Advanced Data Aggregations
03.Sorting Data 7.76 MB 0:04:47 128kbps 528.00 1024x768 15 frames/second 08.Advanced Data Aggregations
04.TOP 2.68 MB 0:01:26 128kbps 543.00 1024x768 15 frames/second 08.Advanced Data Aggregations
05.Ranking Functions 8.45 MB 0:05:06 128kbps 479.00 1024x768 15 frames/second 08.Advanced Data Aggregations
06.Paging 5.32 MB 0:03:05 128kbps 701.00 1024x768 15 frames/second 08.Advanced Data Aggregations
07.DISTINCT Statement 6.51 MB 0:03:42 128kbps 530.00 1024x768 15 frames/second 08.Advanced Data Aggregations
01.Using Functions 8.81 MB 0:05:45 128kbps 435.00 1024x768 15 frames/second 09.Built-In Functions
02.Date-Time Functions 11.8 MB 0:06:31 128kbps 583.00 1024x768 15 frames/second 09.Built-In Functions
03.String Functions 10.2 MB 0:06:19 128kbps 496.00 1024x768 15 frames/second 09.Built-In Functions
04.Data Type Conversions 7.66 MB 0:04:21 128kbps 462.00 1024x768 15 frames/second 09.Built-In Functions
05.New Logic Functions 6.18 MB 0:03:27 128kbps 460.00 1024x768 15 frames/second 09.Built-In Functions
01.Introduction 1.20 MB 0:00:48 128kbps 80.00 1024x768 15 frames/second 10.Query Optimization
02.Indexes 9.67 MB 0:06:37 128kbps 89.00 1024x768 15 frames/second 10.Query Optimization
03.Statistics 3.49 MB 0:02:23 128kbps 67.00 1024x768 15 frames/second 10.Query Optimization
04.Query Plans 14.8 MB 0:09:09 128kbps 519.00 1024x768 15 frames/second 10.Query Optimization
05.Query Hints 4.75 MB 0:03:16 128kbps 68.00 1024x768 15 frames/second 10.Query Optimization
06.Dynamic Management Objects 2.95 MB 0:01:58 128kbps 81.00 1024x768 15 frames/second 10.Query Optimization
07.Dynamic SQL 4.74 MB 0:02:45 128kbps 407.00 1024x768 15 frames/second 10.Query Optimization
01.Modifying Data 3.88 MB 0:02:39 128kbps 132.00 1024x768 15 frames/second 11.Modifying Data
02.INSERT Statements 9.68 MB 0:05:07 128kbps 732.00 1024x768 15 frames/second 11.Modifying Data
03.UPDATE Statements 9.58 MB 0:05:52 128kbps 403.00 1024x768 15 frames/second 11.Modifying Data
04.DELETE Statements 5.30 MB 0:03:00 128kbps 500.00 1024x768 15 frames/second 11.Modifying Data
01.Introduction 845 KB 0:00:32 128kbps 87.00 1024x768 15 frames/second 12.Advanced Data Modification
02.OUTPUT Statements 7.22 MB 0:04:40 128kbps 435.00 1024x768 15 frames/second 12.Advanced Data Modification
03.MERGE Statements 4.69 MB 0:03:18 128kbps 87.00 1024x768 15 frames/second 12.Advanced Data Modification
04.MERGE Demo 9.63 MB 0:05:49 128kbps 485.00 1024x768 15 frames/second 12.Advanced Data Modification
Download File Size:398.54 MB
|
