Microsoft 70-464: Developing Microsoft SQL Server 2012

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 TSQL Part 1
• 14.2 Handling Error in TSQL 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