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