Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

Manhattan Studies Institute

Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

$ 0.00

Course Description

This course is preparation for the 70-464 exam and introduces SQL Server 2012 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, 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.

Course Outline

Mod 1 SQL 2012 And The 464 Test
Mod 2 Working With Data Types
Mod 3 Tables
Mod 4 Data Constraints
Mod 5 Planning In Indexing
Mod 6 Table Structures
Mod 7 Improving Performance with Non-Clustered Indexes
Mod 8 Using Indexes And Execution Plans
Mod 9 Working with Views
Mod 10 Designing and Implementing Stored Procedures
Mod 11 Merging Data and Passing Tables
Mod 12 Designing and Implementing User Functions
Mod 13 Creating Highly Concurrent SQL Server Applications
Mod 14 Handling Errors in T-SQL
Mod 15 Triggers
Mod 16 Implementing Managed Code
Mod 17 Storing XML in SQL
Mod 18 Storing XML in SQL
Mod 19 Working with the Spatial Data
Mod 20 Working With Full-Text Indexes and Queries