SQL Server 2012 Querying (70-461) Part 1
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.
What you'll learn
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.
Table of contents
Introduction to SQL Server 2012
9mins
Introduction to Relational Databases
38mins
Introduction to SELECT Statements
35mins
Filtering Results with WHERE Statements
20mins
Utilizing Joins
33mins
Executing Subqueries and UNION Statements
24mins
Aggregating Data
37mins
Advanced Data Aggregations
34mins
Built-In Functions
26mins
Query Optimization
27mins
Modifying Data
17mins
Advanced Data Modification
15mins