Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

Curriculum

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

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

Tables
3.1 Tables
3.2 Creating Tables

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

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

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

Improving Performance with NonClustered Indexes
7.1 Improving Performance With NonClustered Indexes Part 1
7.2 Improving Performance With NonClustered Indexes Part 2
7.3 Improving Performance With NonClustered Indexes Part 3

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

Working with Views
9.1 Working With Views Part 1
9.2 Working With Views Part 2

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

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

Designing and Implementing User Functions
12.1 Designing And Implementing User Functions

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

Handling Errors in TSQL
14.1 Handling Error In TSQL Part 1
14.2 Handling Error In TSQL Part 2

Triggers
15.1 Triggers

Implementing Managed Code
16.1 Implementing Managed Code Part 1
16.2 Implementing Managed Code Part 2
16.3 Implementing Managed Code Part 3

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

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

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

Working With FullText 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