Microsoft 70-464: Developing Microsoft SQL Server 2012

Please note that Microsoft have retired this exam. Although the exam(s) associated with this course has been retired by Microsoft, this course still retains value as a training resource & learners will receive a certificate of completion after completing the course.

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.

• 12 months unlimited access
• Certificate of completion awarded upon completing the course to show to employers or prospective employers your new skills
• Free upgrade on to our premium platform
• Free career advice available upon request after completing the course

Today’s IT Industry demands that professionals cover the latest technology on the marketplace. Many IT professionals separate themselves from their competitors by achieving certifications in the most current technologies and giving themselves skill-sets that are unmatched by many of their peers.

This course has been designed to prepare you for the Microsoft 70-464 exam. The exam covers the following topics:

• Implement database objects.
• Implement programming objects.
• Design database objects.
• Optimise and troubleshoot queries.

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 Breakdown

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

Why My Training Academy? My Training Academy’s training courses are light-years ahead of our competitors. We provide expert instructor-led training modules with customised presentations, practice exam simulators and learning supplements that provide the full benefits of live classroom training – you can study when and where you want, at your own pace.

Benefit? Our online courses are delivered by the industry’s finest instructors, with a minimum of 15 years real world experience and experts in their fields. You will learn all the relevant skills to support you in attaining your dream job. Gain the skills in demand by employers and the confidence that you’re one step closer to your dream job, promotion or new career.

Why not try the training for free? Request a free demo today at no extra cost.

Invest in yourself: Acquiring these vital business skills – will repay the cost in improved employment opportunities and job satisfaction. What better investment than in your own future? The sooner you start, the sooner you will benefit.

When can I start? Enquire today, simply enrol and you can start studying today if you wish.

What are our students saying about us? I have just bought the Networking Bundle from My Training Academy and can't wait to get started! The service received from John was first class, He gave me a fantastic price on the bundle which I really appreciated having recently been made redundant. Really helpful to have a free demo to see the course before buying. Really like this style of training it will suit me down to the ground, can’t thank you enough.

Certificate of completion

Digital certificate - Included