SQL Server 2012 Querying (70-461) Part 1
Offered By: Pluralsight
Course Description
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.
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.
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
Related Courses
MongoDB for .NET DevelopersMongoDB University Implementing ETL with SQL Server Integration Services
Microsoft via edX Практики оперативной аналитики в MS Excel
Saint Petersburg State University via Coursera Analyzing Big Data with SQL
Cloudera via Coursera Data Analysis Using Python
University of Pennsylvania via Coursera