JULY SITEWIDE DEALS | UP TO 50% Off
40% OFF SITEWIDE LABOR DAY SALE

Shop our Labor Day sale and take 40% off all regularly priced courses and bundles sitewide.  Just add to cart to see your discounts.

Lock In At Our Lowest Price Ever: $14.99/month for 2,500+ hours of IT training.
Limited time only. Enroll now, cancel anytime!

Microsoft 70-464: Developing Microsoft SQL Server Databases

In this course you will learn logical table design, indexing and query plans. This course focuses on the creation of database objects including views, stored procedures, parameters and functions. Common aspects of procedure coding such as indexes, concurrency, error handling, and triggers are also covered in this course. This course will also teach you how to optimize indexes, ensure data integrity, implement views, stored procedures and functions as well as manage transactions and locks.

Included In This Course

Included In This Course

Total Hours
9  Training Hours
Microsoft 70-464: Developing Microsoft SQL Server Databases
59 On-demand Videos
Closed Caption

Closed Captions

Course Topics
20  Topics
Prep Questions
59 Prep Questions
Microsoft 70-464: Developing Microsoft SQL Server Databases

Certificate of Completion

Course Description

Note: Although the associated examination for this Microsoft 70-464: Developing Microsoft SQL Server Databases course has been retired, it is a good resource for training.

This course is in preparation for the Microsoft 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. It will guide you through real world application of design concepts and tolls needed for successful SQL Server database development.

Candidates for the Microsoft 70-464 Developing SQL Server Databases (MCSE) exam are primarily database professionals who build and implement databases across organizations and who ensure high levels of data availability. They have experience performing tasks in creating database files, data types, and tables; planning, creating, and optimizing indexes; ensuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.

This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. This exam is intended for database professionals who build and implement databases across organizations and who ensure high levels of data availability.

  • Implement database objects (30-35%)
  • Implement programming objects (15-20%)
  • Design database objects (25-30%)
  • Optimize and troubleshoot queries (25-30%)

For complete information on this certification course, please visit the Microsoft website for details and exam pricing.

To see more Microsoft related training, Visit the Microsoft Website.

Frequently Asked Questions About Microsoft 70-464: Developing Microsoft SQL Server Databases

What will I learn in the Microsoft 70-464: Developing Microsoft SQL Server Databases online course?

This IT training course will cover logical table design, indexing, and query plans. It focuses on the creation of database objects including views, stored procedures, parameters, and functions. You’ll also learn aspects of procedure coding such as indexes, concurrency, error handling, and triggers. Additionally, the course will teach you how to optimize indexes, ensure data integrity, implement views, stored procedures, and functions, as well as manage transactions and locks​.

Who is this online course designed for?

The Microsoft 70-464: Developing Microsoft SQL Server Databases online course is primarily designed for database professionals who build and implement databases across organizations and who ensure high levels of data availability. Candidates typically have experience performing tasks in creating database files, data types, and tables; planning, creating, and optimizing indexes; ensuring data integrity; and implementing views and stored procedures.

How is the content of this online course delivered?

The online course is structured into 20 topics, and it’s delivered through 59 videos. In total, the course content should take around 9 hours to complete. To test your understanding, there are also 59 questions related to the course topics​.

Is there a subscription option available for this IT training course?

Yes, there is an All Access Monthly Subscription available. By subscribing, you can get access to this training and over 2,500 hours of on-demand content. There is a 7-day free trial period with no obligation, and you can cancel your subscription anytime.

Is this online course still relevant if the associated examination has been retired?

Absolutely! Although the associated examination for this course has been retired, it remains a valuable resource for training. The course provides practical knowledge and teaches real-world application of design concepts and tools needed for successful SQL Server database development.

Does this online course prepare me for any specific certification exam?

This training course was initially designed in preparation for the Microsoft 70-464 Developing Microsoft SQL Server 2012 Databases exam. However, please note that the associated examination for this course has been retired. Nonetheless, the knowledge and skills gained from this course are still incredibly valuable for database professionals and those interested in SQL Server database development.

Proudly Display
Your Achievement

Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Example Certificate

Course Outline

Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases Course Content

Module 1: SQL 2012 And The 464 Test

  •    Introduction

  •    Intro To SQL Server 2012-Part1

  •    Intro To SQL Server 2012-Part2

  •    Management Studio Demo-Part1

  •    Management Studio Demo-Part2

  •    Management Studio Demo-Part3

  •    Other SQL Server Tools

Module 2: Working With Data Types

  •    Working With Data Types-Part1

  •    Working With Data Types-Part2

  •    Working With Data Types-Part3

  •    Other Data Types

Module 3: Tables

  •    Tables

  •    Creating Tables

Module 4: Data Constraints

  •    Data Constraints-Part1

  •    Data Constraints-Part2

Module 5: Planning In Indexing

  •    Planning In Indexing-Part1

  •    Planning In Indexing-Part2

  •    Planning In Indexing-Part3

  •    Planning In Indexing-Part4

Module 6: Table Structures

  •    Table Structures

  •    Working With Clustered Indexes

  •    Clustered Indexes

  •    Designing Effective Clustered Indexes

Module 7: Improving Performance with Non-Clustered Indexes

  •    Improving Performance With Non-Clustered Indexes-Part1

  •    Improving Performance With Non-Clustered Indexes-Part2

  •    Improving Performance With Non-Clustered Indexes-Part3

Module 8: Using Indexes And Execution Plans

  •    Using Indexes

  •    Execution Plans-Part1

  •    Execution Plans Demo

  •    Execution Plans-Part2

Module 9: Working with Views

  •    Working With Views-Part1

  •    Working With Views-Part2

Module 10: Designing and Implementing Stored Procedures

  •    Designing And Implementing Stored Procedures-Part1

  •    Designing And Implementing Stored Procedures-Part2

  •    Designing And Implementing Stored Procedures-Part3

Module 11: Merging Data and Passing Tables

  •    Merging Data And Passing Tables-Part1

  •    Merging Data And Passing Tables-Part2

  •    Merging Data And Passing Tables-Part3

Module 12: Designing and Implementing User Functions

  •    Designing And Implementing User Functions

Module 13: Creating Highly Concurrent SQL Server Applications

  •    Creating Highly Concurrent SQL Server Applications-Part1

  •    Creating Highly Concurrent SQL Server Applications-Part2

  •    Creating Highly Concurrent SQL Server Applications-Part3

Module 14: Handling Errors in T-SQL

  •    Handling Error InT-SQL-Part1

  •    Handling Error InT-SQL-Part2

Module 15: Triggers

  •    Triggers

Module 16: Implementing Managed Code

  •    Implementing Managed Code-Part1

  •    Implementing Managed Code-Part2

  •    Implementing Managed Code-Part3

  •    Implementing Managed Code-Part4

Module 17: Storing XML in SQL

  •    Storing XML In SQL-Part1

  •    Storing XML In SQL-Part2

Module 18: Querying XML

  •    Querying XML-Part1

  •    Querying XML-Part2

Module 19: Working with the Spatial Data

  •    Working With Spatial Data-Part1

  •    Working With Spatial Data-Part2

  •    Working With Spatial Data-Part3

Module 20: Working With Full-Text Indexes and Queries

  •    Working With Full-Text Indexes And Queries-Part1

  •    Working With Full-Text Indexes And Queries-Part2

  •    Working With Full-Text Indexes And Queries-Part3

Add a review
Microsoft 70-464: Developing Microsoft SQL Server Databases Microsoft 70-464: Developing Microsoft SQL Server Databases
Rating*
0/5
* Rating is required
Your review
* Review is required
Name
* Name is required
4.8
Based on 50 reviews
5 star
78
78%
4 star
22
22%
3 star
0%
2 star
0%
1 star
0%
1-5 of 50 reviews
  1. I was looking for an online course for Six Sigma as my new boss is a true believer and I wanted to have a better handle of what is Six Sigma. I started looking around and found ITU, and bought the course, and could not be happier. I have no intention of getting certified, but at least now I can speak the jargon and understand what my boss is talking about.

  2. The educators at ituonline.com are highly skilled but could improve their methods of instruction. In the CCNA 200-301 course, there’s a heavy emphasis on oral lectures, and it would be beneficial to include more in-depth visual aids. Annotating labs and graphics could also make the educational journey more effective. On the other hand, the N10-008 course instructor consistently offers top-notch material.

  3. The CompTIA PenTest was an excellent course and the instructor, Chrys, explained the material in a clear and easy way for me to understand and comprehend essential techniques. Highly recommend!

Microsoft 70-464: Developing Microsoft SQL Server Databases
 

$49.00

OR

Subscribe To All-Access

Gain access to this training and all our other courses, offering over 2,500 hours of content, with our cost-effective monthly subscription. No obligations. Cancel anytime.

$49.00 $14.99 Monthly

Microsoft 70-464: Developing Microsoft SQL Server Databases

Microsoft 70-464: Developing Microsoft SQL Server Databases
Microsoft 70-464: Developing Microsoft SQL Server Databases
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.

Monthly All-Access Subscription
7 Days Free - $39.00 / month

A great option at an affordable monthly price.

Annual All-Access Subscription
$229 / year

A discounted price when paying for your All Access library on an annual basis.

Lifetime All-Access Library
$379 One time payment

Exceptional Value. Pay once, never have to buy IT training again.

Related Courses

$49.00

Become a Certified Kubernetes Application Developer (CKAD). Enroll now and learn how to build, deploy, and manage Kubernetes applications.

If you’re looking to ace the Certified Kubernetes Application Developer (CKAD) exam, this is the  video IT  course for you! Through its comprehensive instruction materials, and lectures, it will teach you all that there is to know about Kubernetes – an open-source system designed by Google but now maintained by The Cloud Native Computing Foundation and pass the certification program. 

$49.00

Take your SQL Server skills to the next level with ITU Online’s Microsoft 70-466 course on implementing data models and reports. Enroll now!

In this course you will learn how to create managed enterprise BI solutions. You will learn how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining. This course will also teach you how to create BI solutions that require implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making.

$49.00

Learn how to develop cutting-edge web applications with Microsoft .NET 4.5 Programming and HTML5. Enroll now and get certified!

In this online IT learning course you will learn the .NET open source developer platform. This platform provides a comprehensive and consistent programming model for building web applications that have visually stunning user experiences and seamless and secure communication. HTML 5, Javascript and CSS3 can integrate with this platform.