Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

Course Information

Course Name: Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases Online Course
Exam Code: 70-464
Total Video Hours: 9 Hrs 46 Min
Total Videos: 59
Delivery Mode: Online, On-Demand
Skill Level: Intermediate to Advanced
Target Audience: SQL Server developers, database professionals, and IT specialists

This course is intended for professionals who build, implement, and maintain SQL Server databases across enterprise environments. Responsibilities supported by this training include database object creation, index planning, query optimization, data integrity enforcement, and concurrency management.

Included in This Course

• 9+ hours of in-depth SQL Server 2012 video training

• 59 lessons aligned with Microsoft 70-464 exam objectives

• Logical database design and table structure techniques

• SQL Server Management Studio demonstrations

• Data type selection and implementation strategies

• Index planning, clustered and nonclustered indexing

• Query execution plan analysis and performance tuning

• Stored procedures, functions, views, and triggers

• Concurrency, transactions, and error handling in T-SQL

• XML, spatial data, and full-text indexing concepts

Course Outline

• Working With Data Types

• Tables

• Data Constraints

• Planning In Indexing

• Table Structures

• Improving Performance with NonClustered Indexes

• Using Indexes And Execution Plans

• Working with Views

• Designing and Implementing Stored Procedures

• Merging Data and Passing Tables

• Designing and Implementing User Functions

• Creating Highly Concurrent SQL Server Applications

• Handling Errors in TSQL

• Triggers

• Implementing Managed Code

• Storing XML in SQL

• Querying XML

• Working with the Spatial Data

• Working With FullText Indexes and Queries

Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases Online Course addresses the critical skills required to design and implement reliable, high-performance database solutions using SQL Server 2012. Database developers play a central role in ensuring data availability, integrity, and performance across enterprise systems. This course provides structured instruction aligned with professional responsibilities and certification requirements for Exam 70-464.

SQL Server 2012 architecture and tooling form the foundation of effective database development. The course begins with an introduction to SQL Server 2012 features and the objectives of the 70-464 exam. SQL Server Management Studio demonstrations provide practical exposure to the development environment, allowing learners to understand how database objects are created, managed, and maintained within real-world workflows.

Data types represent a fundamental design decision in SQL Server development. The course explains how to select and implement appropriate data types to balance storage efficiency, performance, and data accuracy. Coverage includes numeric, character, date, and specialized data types, ensuring developers understand how design choices affect scalability and query execution.

Table design is central to logical database structure. This course addresses table creation principles, normalization concepts, and best practices for defining schemas that support efficient data retrieval. Proper table design reduces redundancy and supports long-term maintainability, which is critical in enterprise database environments.

Data constraints enforce business rules and data integrity at the database level. The course covers primary keys, foreign keys, unique constraints, and check constraints, explaining how each contributes to consistent and reliable data storage. These mechanisms ensure that databases enforce rules consistently, regardless of application-layer logic.

Indexing strategy significantly impacts query performance. This course dedicates extensive coverage to planning and implementing indexes within SQL Server 2012. Learners explore clustered and nonclustered indexes, index design principles, and scenarios where indexing improves or degrades performance. Understanding indexing trade-offs is essential for optimizing large datasets and transactional workloads.

Table structures and clustered indexes are examined in detail to highlight how physical data storage affects query execution. The course explains how clustered indexes determine data order and how effective design supports faster range queries and sorting operations. These concepts directly influence performance tuning decisions in production environments.

Nonclustered indexes are addressed as a key mechanism for improving query performance without altering table structure. The course explains index key selection, included columns, and maintenance considerations. Practical examples demonstrate how nonclustered indexes enhance read performance while balancing write overhead.

Execution plans provide visibility into SQL Server’s query optimization process. The course explains how to read and analyze execution plans, identify bottlenecks, and adjust queries or indexes accordingly. Understanding execution plans enables developers to diagnose performance issues and implement targeted improvements.

Views support abstraction, security, and simplified query logic. The course explains how views are designed and used within SQL Server, including considerations for performance and maintainability. Views play a critical role in presenting consistent data structures to applications and reporting tools.

Stored procedures are a core component of SQL Server application development. The course explains how to design and implement stored procedures using parameters and control-of-flow logic. Topics include performance considerations, reusability, and security benefits associated with encapsulating logic at the database level.

Data merging and table-valued parameters are covered to support advanced data manipulation scenarios. These techniques enable efficient batch operations and support scalable application design, particularly in data integration and synchronization workflows.

User-defined functions extend SQL Server’s computational capabilities. The course explains how scalar and table-valued functions are designed and implemented, along with performance considerations and appropriate usage scenarios.

Concurrency management is critical in multi-user database systems. The course explains transactions, locking behavior, and isolation levels to ensure data consistency under concurrent access. Understanding these concepts helps developers build applications that scale while maintaining reliability.

Error handling in T-SQL is addressed through structured techniques that improve robustness and maintainability. The course explains how to capture, handle, and log errors effectively, supporting stable database operations and simplified troubleshooting.

Triggers are examined as automated response mechanisms within SQL Server. The course explains when triggers are appropriate and how they enforce business rules or audit changes. Proper trigger design prevents unintended performance impacts while supporting data consistency.

Managed code integration introduces SQL Server CLR capabilities. The course explains how managed code can be implemented within SQL Server to extend functionality beyond traditional T-SQL, including considerations for security and performance.

XML storage and querying are addressed to support semi-structured data scenarios. The course explains XML data types, storage options, and querying techniques, enabling developers to manage complex data formats within SQL Server.

Spatial data support expands SQL Server’s capabilities for location-based applications. The course explains spatial data types and operations, enabling developers to store and query geographic information effectively.

Full-text indexing and querying are covered to support advanced search functionality. The course explains how full-text indexes enable efficient text-based searches across large datasets, supporting content-driven applications and reporting systems.

Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases Online Course provides structured, exam-focused instruction aligned with professional database development responsibilities. By combining theory, practical demonstrations, and performance-oriented design principles, this course supports both certification preparation and real-world SQL Server development expertise.

FAQs

Who is this Microsoft 70-464 SQL Server course designed for?
This course is intended for database developers and IT professionals responsible for building and maintaining SQL Server databases.

Does this course align with Exam 70-464 objectives?
Yes, the course content is structured to align directly with the Microsoft 70-464 certification exam requirements.

Are indexing and performance tuning covered in detail?
Yes, clustered indexes, nonclustered indexes, and execution plan analysis are covered extensively.

Does the course include stored procedures and functions?
Yes, the course provides in-depth coverage of stored procedures, user-defined functions, and triggers.

Is concurrency and transaction management included?
Yes, the course explains concurrency, locking, and transaction handling in SQL Server.

Does the course cover XML and full-text search features?
Yes, XML storage, XML querying, and full-text indexing are included in the curriculum.