Microsoft® SQL Server® 2012: Database Querying (Exam 70-461) 
Course Specifications
Course Number: 
093107
Course Length: 
5 days
Course Description
Overview: 
Course Description 
Managing required information by storing and retrieving data is part of Database Administrators day-to-day activities. One of the most effective ways to manage required information is by using databases. You may need to manipulate and modify your table data based on changing business requirements. The course, Microsoft SQL Server 2012: Database Querying will help you use SQL Server 2012 as a tool to manage organizational data. 
In today's competitive environment, information plays a vital role in determining the success of an organization. If you are able to effectively manage information, you can provide a competitive edge to your organization. Familiarizing yourself with database querying concepts will enable you to effectively manage your organizational data. 
In this course, you will create queries to retrieve, add, update, and maintain your database data. You will also work with data sorting, built-in functions, stored procedures, subqueries, table operators, set operators, conditional operators, views, indexes, and error handling features of SQL Server 2012. 
Course Objectives:
Target Student: 
This course is designed for Database Administrators, Database Developers and Business Intelligence professionals. This course will be attended by report writers, business analysts, and client application developers who wish to upgrade their skills and knowledge in SQL Server 2012. 
This course is also for students seeking the Microsoft Certified Solutions Associate: SQL Server certification and who want to prepare for Exam 70-461, Querying Microsoft SQL Server 2012. 
Prerequisites: 
To ensure your success in this course you should have some working knowledge of relational databases. You should also be comfortable working with the Microsoft Windows 7 Operating System, and be able to use the core functionalities of Windows 7. 
You can obtain this level of skills and knowledge by taking the following Logical Operations course: 
•	Introduction to Personal Computers Using Microsoft® Windows® 8. 
•	Any database course.
•	Any rational database design course.
Course-specific Technical Requirements
Hardware
For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware configurations: 
•	1 GHz or faster 32-bit (x86) or 64-bit (x64)
•	1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
•	16 GB available hard disk space (32-bit) or 20 GB (64-bit)
•	CD-ROM or DVD-ROM drive
•	1024 x 768 resolution monitor recommended
•	Internet access (optional)
•	Printer (optional) or an installed printer driver
•	Projection system to display the instructor's computer screen
Software
•	Microsoft® Windows®  XP with Service Pack 2 (Service Pack 3 recommended) or Windows 7 or Windows 8 
•	Microsoft® SQL Server® 2012 Express Edition
•	Microsoft® Silverlight® 
Course Content
Lesson 1: Getting Started with SQL Server 2012 
Topic A: Overview of SQL Server 2012 
Topic B: Work with SSMS 
Lesson 2: Working with T-SQL 
Topic A: Overview of T-SQL 
Topic B: Work with T-SQL Statements 
Topic C: Manage SQL Server Constraints 
Lesson 3: Writing SELECT Queries 
Topic A: Write SELECT Statements 
Topic B: Assign Aliases Using Queries 
Topic C: Write CASE Expressions 
Lesson 4: Working with SQL Data Types 
Topic A: Work with String and Numeric Data Types 
Topic B: Work with Date and Time Data Types 
Topic C: Work with Binary Data Types 
Topic D: Work with the XML Data Type 
Lesson 5: Sorting and Filtering Data 
Topic A: Sort the Queried Data 
Topic B: Filter the Queried Results 
Topic C: Work with Predicates 
Topic D: Perform Advanced Filtering 
Lesson 6: Querying Data from Multiple Tables 
Topic A: Combine Data Using Simple Joins 
Topic B: Create Queries Using Join Algorithms 
Lesson 7: Modifying Data 
Topic A: Insert Data 
Topic B: Update Data 
Topic C: Delete Data 
Topic D: Merge Data 
Lesson 8: Working with SQL Server Built-in Functions 
Topic A: Create Queries Using Built-in Functions 
Topic B: Create Queries to Test Nullability 
Topic C: Group and Aggregate Data 
Lesson 9: Programming in T-SQL 
Topic A: Work with Variables and Batches 
Topic B: Control Program Flow 
Topic C: Manage Triggers 
Topic D: Work with Data Access Technologies 
Lesson 10: Implementing Stored Procedures 
Topic A: Manage Stored Procedures 
Topic B: Work with Dynamic SQL 
Lesson 11: Working with Subqueries and Table Expressions 
Topic A: Work with Subqueries 
Topic B: Work with Table Expressions 
Lesson 12: Working with Set Operators, Conditional Operators, and Window Functions 
Topic A: Work with Set Operators 
Topic B: Work with Window Functions 
Topic C: Configure User-Defined Functions (UDF) 
Topic D: Work with Advanced Functions 
Lesson 13: Working with PIVOT, UNPIVOT, and Grouping Sets 
Topic A: Work with PIVOT and UNPIVOT 
Topic B: Work with Grouping Sets 
Lesson 14: Managing Error Handling and Transactions 
Topic A: Implement Error Handling 
Topic B: Manage Transactions 
Lesson 15: Querying SQL Server System Metadata 
Topic A: Work with System Databases 
Topic B: Work with SSPs and SMOs 
Topic C: Work with System Catalog Views 
Lesson 16: Optimizing Query Performance 
Topic A: Manage Query Plans 
Topic B: Configure Indexes 
Topic C: Manage Views 
Topic D: Analyze Data from Query Plans 
Lesson 17: Working with Windows Azure SQL Database 
Topic A: Overview of WASD 
Topic B: Work with WASD 
Lesson 18: 
Appendix A: Exam 70-461: Querying Microsoft SQL Server 2012