Duration
3 days
Module 1: Introduction to Microsoft SQL Server 2012
Lessons
- Introducing Microsoft SQL Server 2012
- Getting Started with SQL Server Management Studio
Module 2: Getting Started with SQL Azure
Lessons
- Overview of SQL Azure
- Working with SQL Azure
Module 14: Pivoting and Grouping Sets
Lessons
- Writing Queries with PIVOT and UNPIVOT
- Working with Grouping Sets
Module 15: Querying SQL Server Metadata
Lessons
- Querying System Catalog Views and Functions
- Executing System Stored Procedures
- Querying Dynamic Management Objects
Module 16: Executing Stored Procedures
Lessons
- Querying Data with Stored Procedures
- Passing Parameters to Stored Procedures
- Creating Simple Stored Procedures
- Working with Dynamic SQL
Module 17: Programming with T-SQL
Lessons
- T-SQL Programming Elements
- Controlling Program Flow
Module 18: Implementing Error Handling
Lessons
- Using TRY / CATCH Blocks
- Working with Error Information
Module 19: Implementing Transactions
Lessons
- Transactions and the Database Engine
- Controlling Transactions
Module 20: Improving Query Performance
Lessons
- Factors in Query Performance
- Displaying Query Performance Data
Additional Topics
Module 22: Responding to Data Manipulation via Triggers
Lessons
- Designing DML Trigger
- Implementing DML Trigger
- After Trigger for Insert
- After Trigger for Update
- After Trigger for Delete
- Instead of Trigger
- Advanced Trigger Concepts
Module 23: Advanced Programming
Lessons
- Set Base Query Vs Cursor Base Query
- XML Data type support in SQL Server
Programme scope, delivery arrangements and suitability are confirmed during enquiry.