MOC 10776 A Developing Microsoft SQL Server 2012 Databases

    

Summary:
This 5-day instructor-led course 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 transactions, concurrency, error handling, triggers, and SQL CLR are also covered in this course. Also this course helps you prepare for the Exam 70-464

Duration:
5 Days/Lecture & Lab

Audience:
The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2012 product features and technologies for implementing a database.

Topics:

• Introduction to SQL Server 2012 and its Toolset
• Working with Data Types
• Designing and Implementing Tables
• Ensuring Data Integrity through Constraints
• Planning for SQL Server 2012 Indexing
• Implementing Table Structures in SQL Server 2012
• Reading SQL Server 2012 Execution Plans
• Improving Performance through Nonclustered
• Indexes
• Designing and Implementing Views
• Designing and Implementing Stored Procedures
• Merging Data and Passing Tables
• Designing and Implementing User-Defined
• Functions
• Creating Highly Concurrent SQL Server 2012
• Applications
• Handling Errors in T-SQL Code
• Responding to Data Manipulation via Triggers
• Implementing Managed Code in SQL Server 2012
• Storing XML Data in SQL Server 2012
• Querying XML Data in SQL Server

Prerequisites:
Before taking this course students should have knowledge of writing T-SQL queries and a basic relational database concepts. Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills: 10774A: Writing T-SQL Queries for Microsoft SQL Server 2012.

Last Update: June 18, 2013