Developing Microsoft SQL Server 2012 Databases Central

Course details

This 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 CLRare also covered in this course.

Course Outline

• Lesson 1: Introduction to SQL Server 2012 and its Toolset
• Lesson 2: Working with Data Types
• Lesson 3: Designing and Implementing Tables
• Lesson 4: Ensuring Data Integrity through Constraints
• Lesson 5: Planning for SQL Server 2012 Indexing
• Lesson 6: Implementing Table Structures in SQL Server 2012
• Lesson 7: Reading SQL Server 2012 Execution Plans
• Lesson 8: Improving Performance through Nonclustered Indexes
• Lesson 9: Designing and Implementing Views
• Lesson 10: Designing and Implementing Stored Procedures
• Lesson 11: Merging Data and Passing Tables
• Lesson 12: Designing and Implementing UserDefined Functions
• Lesson 13: Creating Highly Concurrent SQL Server 2012 Applications
• Lesson 14: Handling Errors in T-SQL Code
• Lesson 15:Responding to Data Manipulation via Triggers
• Lesson 16: Implementing Managed Code in SQL Server 2012
• Lesson 17: Storing XML Data in SQL Server 2012
• Lesson 18: Querying XML Data in SQL Server
• Lesson 19: Working with SQL Server 2012 Spatial Data
• Lesson 20: Working with Full-Text Indexes and Queries

Prerequisites

• Knowledge of writing T-SQL queries.
• Knowledge of basic relational database concepts.