Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

Module 1: SQL 2012 And The 464 Test

1.1 Introduction
1.2 Intro To SQL Server 2012­ Part 1
1.3 Intro To SQL Server 2012­ Part 2
1.4 Management Studio Demo ­Part 1
1.5 Management Studio Demo­ Part 2
1.6 Management Studio Demo­ Part 3
1.7 Other SQL Server Tools

Module 2: Working With Data Types

2.1 Working With Data Types­ Part 1
2.2 Working With Data Types­ Part 2
2.3 Working With Data Types ­Part 3
2.4 Other Data Types

Module 3:Tables

3.1 Tables
3.2 Creating
Tables

Module 4: Data Constraints

4.1 Data Constraints­ Part 1
4.2 Data Constraints ­Part 2

Module 5: Planning In Indexing

5.1 Planning In Indexing ­Part 1
5.2 Planning In Indexing ­Part 2
5.3 Planning In Indexing ­Part 3
5.4 Planning In Indexing ­Part 4

Module 6: Table Structures

6.1 Table Structures
6.2 Working With Clustered Indexes
6.3 Clustered Indexes
6.4 Designing Effective Clustered Indexes

Module 7: Improving Performance with Non­Clustered Indexes

7.1 Improving Performance With Non­Clustered Indexes­ Part 1
7.2 Improving Performance With Non­Clustered Indexes­ Part 2
7.3 Improving Performance With Non­Clustered Indexes­ Part 3

Module 8: Using Indexes And Execution Plans

8.1 Using Indexes
8.2 Execution Plans ­Part 1
8.3 Execution Plans Demo
8.4 Execution Plans­ Part 2 Module 9: Working with Views
9.1 Working With Views ­Part 1
9.2 Working With Views­ Part 2

Module 10: Designing and Implementing Stored Procedures

10.1 Designing And Implementing Stored Procedures ­Part 1
10.2 Designing And Implementing Stored Procedures ­Part 2
10.3 Designing And Implementing Stored Procedures ­Part 3

Module 11: Merging Data and Passing Tables

11.1 Merging Data And Passing Tables ­Part 1
11.2 Merging Data And Passing Tables­ Part 2
11.3 Merging Data And Passing Tables­ Part 3

Module 12: Designing and Implementing User Functions

12.1 Designing And Implementing User Functions

Module 13: Creating Highly Concurrent SQL Server Applications

13.1 Creating Highly Concurrent SQL Server Applications ­Part 1
13.2 Creating Highly Concurrent SQL Server Applications­ Part 2
13.3 Creating Highly Concurrent SQL Server Applications­ Part 3

Module 14: Handling Errors in TSQL

14.1 Handling Error In T­SQL ­Part 1
14.2 Handling Error In T­SQL­ Part 2

Module 15: Triggers

15.1 Triggers Module
16: Implementing Managed Code
16.1 Implementing Managed Code­ Part 1
16.2 Implementing Managed Code­ Part 2
16.3 Implementing Managed Code ­

Part 3 Module 17: Storing XML in SQL

17.1 Storing XML In SQL­ Part 1
17.2 Storing XML In SQL­ Part 2
17.3 Storing XML In SQL ­Part 3

Module 18: Querying XML

18.1 Querying XML­ Part 1
18.2 Querying XML­ Part 2
18.3 Querying XML­ Part 3

Module 19: Working with the Spatial Data

19.1 Working With Spatial Data­ Part 1
19.2 Working With Spatial Data­ Part 2
19.3 Working With Spatial Data­ Part 3

Module 20: Working With Full­Text Indexes and Queries

20.1 Working With Full­ Text Indexes And Queries ­Part 1
20.2 Working With Full­ Text Indexes And Queries ­Part 2
20.3 Working With Full­ Text Indexes And Queries ­Part 3
20.4 Outro