Course
Skills
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
8mins
Introduction to Relational Databases
38mins
Introduction to SELECT Statements
34mins
Filtering Results with WHERE Statements
19mins
Utilizing Joins
31mins
Executing Subqueries and UNION Statements
23mins
Aggregating Data
37mins
Advanced Data Aggregations
34mins
Built-In Functions
26mins
Query Optimization
27mins
Modifying Data
16mins
Advanced Data Modification
14mins