Lifetime
An ITU Online Training exclusive. The only Buy Once, Never Pay for IT training again program available. Plus, get all new and updated content for life.
- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
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
9 Hrs 47 Min
59 On-demand Videos
Closed Captions
20 Topics
59 Prep Questions
Certificate of Completion
Course Description
Course Description: SQL Server 2012 Database Development Mastery
This course is a utility for training despite the retirement of the associated exam. It details the coverage of logical table design, indexing, query plans, database object creation, and procedure coding. The course also includes real-world applications of design concepts and tools essential for SQL Server database development​​.
Exam Objectives: Microsoft SQL Server Databases Certification Goals
This section outlines the objectives of the Microsoft 70-464 Developing SQL Server Databases (MCSE) exam. It targets database professionals involved in building and implementing databases, focusing on tasks like creating database files, data types, tables, indexes, data integrity, views, stored procedures, and managing transactions and locks. The exam objectives include implementing database objects, programming objects, designing database objects, and optimizing/troubleshooting queries​​.
Course Topics: SQL Server 2012 Database Development Modules
The course is structured into 20 detailed modules covering various aspects of SQL Server 2012, ranging from introductions to SQL Server 2012, data types, tables, data constraints, indexing, table structures, performance improvement, execution plans, views, stored procedures, user functions, concurrency, error handling, triggers, managed code, XML, spatial data, to full-text indexes and queries​​.
Who Will Benefit From This Course
- Database professionals implementing databases
- Individuals ensuring data availability
- Professionals in database file creation
- Specialists in indexing and data integrity
- Those interested in SQL Server database development
Course Highlights: Key Features of SQL Server Database Development
- In-depth coverage of logical table design and indexing
- Focus on database objects like views and stored procedures
- Emphasis on optimizing indexes and data integrity
- Real-world applications of SQL Server design concepts
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 DisplayYour Achievement
Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
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
Subscribe To All-Access
Lock In $14.99 / Month Forever
Start this course for free with our 10-day trial of the all-access subscription providing access to over 2,600 hours of training.
$49.00 $14.99 Monthly
OR
$49.00
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
Enhance your career as a SQL Server administrator with our Microsoft SQL Server Administration training series. Enroll today and become an expert!
This sql server administration course offers students a comprehensive understanding of how to maintain and optimize a Microsoft SQL Server database. It is specifically tailored towards individuals who want to gain knowledge features in numerous versions of SQL server as well as learn about essential capabilities throughout the entire data platform. Students will emerge from this training with an extensive set of skills for managing their own MS SQL Server environment along with its databases!
$49.00
Become a Microsoft Certified Database Designer! Learn Microsoft 70-465: Designing Database Solutions for SQL Server with ITU’s comprehensive online course.
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
Boost your web development skills with ITU’s HTML5 CSS3 online course and stay ahead of the curve
Elevate your web development programming skills in this HTML5 and CSS3 training course. HTML5 and CSS3 are key web technologies that allow you to build up content for the internet. This training program showcases how to use innovative HTML5 multimedia features such as video, audio, and animation. With this course, you can unlock more creative possibilities with your digital media!
Mary Beth helped me. She was wonderful.