Overview 

Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

This course is in preparation for the 70-464 Developing Microsoft SQL Server 2012 Databases exam.

This course covers logical table design, indexing and query plans, and focuses on the creation of database objects including views and stored procedures, along with parameters and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course.

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

This package is designed for any individual wishing to pursue or enhance their career as a Microsoft Engineer.

Our Online Courses is a cost-effective and successful approach for many individuals. It provides a flexible learning method, allowing candidates to schedule learning at a time that suits them and fits in with other commitments; ideal for those who find it difficult to take time away from their workplace. It also allows candidates to work at their own pace, and revisit sections of the course as often as needed, leading to a fuller understanding of all the topics covered.

In addition, there are none of the high costs of travel and accommodation associated with courses at an external venue.

Exam Information

You'll sit an exam at a local test centre. We provide interactive quizzes after each module and a mock exam at the end of your course to ensure you're fully prepared for the real thing. Once you've passed with at least 80%, you'll be able to book your exam as a private candidate.

Please NOTE: Exams are not included.

How To Schedule Your Microsoft Exam

• Go to the Microsoft exam page
• Select the exam you are looking to take from the list
• Click the orange button that says 'Schedule with Pearson VUE', you will then be asked to sign in
• If you already have a Microsoft profile, please sign in here, or if it is the first time you have used this site, please click 'Sign up now'
• Fill out your details on the registration form and click 'Save and continue'
• Confirm your details and click 'Submit'
• You will then be transferred to the 'Pearson VUE' website to select your exam date and complete your booking
• Then check out using your personal payment details

Got a question about exams? Contact our course advisors by email or by phone on 0203 633 4671. We're happy to help!

Good Luck in your exams!