- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
Microsoft 70-464: Developing Microsoft SQL Server Databases
Take an extra 30% off this course! No coupon needed; auto applies in cart.
$49.00
Sale Ends Soon
- 00Days
- 00Hours
- 00Minutes
- 00Seconds
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.
9 Training Hours
59 Videos
20 Topics
59 Practice Questions
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, click here.
Course Outline
Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases Course Outline
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
Microsoft 70-464: Developing Microsoft SQL Server Databases
$49.00
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.
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
$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
$39.00
In this Microsoft 70-480 course you will learn how to implement and manipulate document structures and objects, implement program flow, access and secure data, and use CSS3 in applications. This course will teach you HTML5, CSS3, Javascript and jQuery.
$20.00
In this course you will learn how to plan and implement enterprise database infrastructure solutions by using SQL Server 2012 and other Microsoft technologies. This course will teach you how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions. You will learn how to create plans and designs for database structure, storage, objects, and servers.
$49.00
If you’re ready to dive into Java Programming, this JavaScript Fundamentals online training course is for you! You’ll start with the basics and work your way up to advanced levels. Not only will you get a comprehensive introduction to object-oriented programming, but also learn many other core Java features in detail. Don’t miss out on this opportunity – sign up now and make strides in mastering Java today!
$49.00
You should Learn Java as it is a must-have technology for a range of applications and websites, including business solutions, data centers, game consoles, utilities, desktop computers (as well as laptops and smartphones). That’s why this online training course explores the whole spectrum of Java Programming from beginner to advanced. With it you can confidently tackle any challenge that comes your way!