Microsoft Training (Exam 70-461) * 2012

Microsoft Training Kit ***Each chapter is 6.66%*** 1%

11/19/2018: Delay. Lack knowledge. Looking at other learning material and will return to this once up to par.

**Using this training for Exam 70-761**
Micorosoft Training Kit (Exam 70-461)
Chapter Title Date Started Date Completed
1 Chapter 1 Foundations of Querying 11/06/2018
2 Chapter 2 Getting Started with the SELECT Statement
3 Chapter 3 Filtering and Sorting Data
4 Chapter 4 Combining Sets
5 Chapter 5 Grouping and Windowing
6 Chapter 6 Querying Full-Text Data
7 Chapter 7 Querying and Managing XML Data
8 Chapter 8 Creating Tables and Enforcing Data Integrity
9 Chapter 9 Designing and Creating Views, Inline Functions,
and Synonyms
10 Chapter 10 Inserting, Updating, and Deleting Data
11 Chapter 11 Other Data Modification Aspects
12 Chapter 12 Implementing Transactions, Error Handling, and
Dynamic SQL
13 Chapter 13 Designing and Implementing T-SQL Routines
14 Chapter 14 Using Tools to Analyze Query Performance
15 Chapter 15 Implementing Indexes and Statistics
15 Chapter 16 Understanding Cursors, Sets, and Temporary Tables
15 Chapter 17 Understanding Further Optimization Aspects