Exam 70-461 Querying Microsoft SQL Server 2012

This book is for students preparing to become certified for the recent Microsoft release, 70-461 Querying Microsoft SQL Server 2012 exam.  This exam is the first of a series of three exams required for Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 certification. The Microsoft Official Academic Course (MOAC) lessons correlate and are mapped to The Microsoft Certified Solutions Associate (MCSA) 70-461 certification exam.  Your students master programming Database Object Queries, creating Database Objects and managing system efficiencies. The MOAC IT Professional series is the Official from Microsoft, turn-key Workforce training program that leads to professional certification and was authored for college instructors and college students.  This textbook focuses on real skills for real jobs and prepares students to prove mastery of core services in careers such as SQL Server database administrators, implementers, system engineers, and developers seeking to prove their skills and knowledge in writing queries.

The MOAC IT Professional series is the Official from Microsoft, turn-key Workforce training program that leads to professional certification and was authored for college instructors and college students.  MOAC gets instructors ready to teach and students ready for work by delivering essential resources in 5 key areas:  Instructor readiness, student software, student assessment, instruction resources, and learning validation.   With the Microsoft Official Academic course program, you are getting instructional support from Microsoft; materials that are accurate and make course delivery easy.  Request your sample materials today.

Part 1: Preparing for the Course

Lesson 1: Working with SQL Server 2012 Tools

Lesson 2: Understanding Processing Sequences

Lesson 3: Introducing T-SQL Query Syntax

Lesson 4: Understanding the Role of the Query Optimizer

Lesson 5: Creating Scripts

Lesson 6: Understanding Data Types

Part 2: Programming Database Object Queries

Lesson 7: Writing Simple SELECT Statements

Lesson 8: Querying Multiple Tables

Lesson 9: Sorting and Filtering Data

Lesson 10: Using Functions

Lesson 11: Grouping and Aggregating Data

Lesson 12: Using Subqueries

Lesson 13: Using Derived Data Structures

Lesson 14: Using Set Operators

Lesson 15: Controlling with Windows

Lesson 16: Pivoting and Grouping SETS

Lesson 17 Creating and Working with Full-Text Data

Lesson 18: Querying XML Data

Part 3: Creating Database Objects

Lesson 19: Generating Databases

Lesson 20: Generating Tables

Lesson 21: Creating Views

Lesson 22: Generating Stored Procedures

Lesson 23: Generating Functions

Lesson 24: Generating Triggers

Lesson 25: Programming Access to Database Objects

Part 4: Managing System Efficiencies

Lesson 26: Using Management Functions

Lesson 27: Controlling Transactions and Locks