SQL Server 2012 Querying (70-461) Part 1

Course

Libraries: If you want this course, consider one of these libraries.
Data

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.

Get started

Preview course

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.

Intended Audience | 3m 1s
Using This Course | 3m 59s
Syntax Notes | 1m 42s

Introduction | 1m 8s
Database Concepts | 3m 12s
Table Concepts | 13m 45s
Table Design | 3m 42s
Design Scenario | 8m 56s
Orders and Products Notes | 4m 8s
Working with Data | 3m 10s

SQL Server 2012 Querying (70-461) Part 1

What you'll learn

Table of contents

Get started with Pluralsight

SQL Server 2012 Querying (70-461) Part 1

What you'll learn

Table of contents

Introduction to SQL Server 2012 8m

Introduction to Relational Databases 38m

Introduction to SELECT Statements 34m

Filtering Results with WHERE Statements 19m

Utilizing Joins 31m

Executing Subqueries and UNION Statements 23m

Aggregating Data 37m

Advanced Data Aggregations 34m

Built-In Functions 26m

Query Optimization 27m

Modifying Data 16m

Advanced Data Modification 14m

Get started with Pluralsight