SQL Server 2012 Querying (70-461) Part 1
Pluralsight
Course Summary
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.
-
+
Course Description
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.
-
+
Course Syllabus
Introduction to SQL Server 2012- 8m 42s
—Intended Audience 3m 1s
—Using This Course 3m 59s
—Syntax Notes 1m 42sIntroduction to Relational Databases- 38m 1s
—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 10sIntroduction to SELECT Statements- 34m 50sFiltering Results with WHERE Statements- 19m 52sUtilizing Joins- 31m 42sExecuting Subqueries and UNION Statements- 23m 41sAggregating Data- 37m 40sAdvanced Data Aggregations- 34m 4sBuilt-In Functions- 26m 24sQuery Optimization- 27m 1sModifying Data- 16m 38sAdvanced Data Modification- 14m 20s
This course is listed under
Development & Implementations
and Data & Information Management
Community
Related Posts: