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.
Overview
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.
Syllabus
- 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
Taught by
Christopher Harrison