Developing Microsoft SQL Server 2012 Database (formerly code named "Denali") - Courses

Developing Microsoft SQL Server 2012 Database (formerly code named "Denali")

Choose your own date

5-Day (COURSE-DB-10776A_DEV_2012) DescriptionThis 5 day course covers implementing a Microsoft SQL Server 2012 Database. It covers core database development and implementation skills required for SQL Server. While based on SQL Server 2012, this course is equally useful for attendees working with either SQL Server 2008 R2, 2008 or SQL Server 2005.Written by SolidQ Australia, this course is targeted at practical skills and features a large number of hands-on labs.Attendees will work through an extensive set of detailed and practical hands-on labs that reinforce the material presented.

For details on booking courses, please send an e-mail.
AudienceThe presentations and labs have been designed specifically to give professional Developers and DBAs—those who work for an ISV, SI, or enterprise customer—the information they need to deliver SQL Server solutions on the Microsoft data platform.
This course is also relevant and useful for those interested to understand and evaluate Microsoft’s SQL Server offerings. NOTE: This course is also very useful for those currently working with the SQL Server 2005 series of technologies. Differences between the releases are identified.

Prerequisites

Attendees should have a basic understanding of SQL Server and relational database technology.

Working knowledge of Transact-SQL.
Working knowledge of Relational databases.
Core Windows Server skills.
Database design skills.
Basic knowledge of XML and XML schemas.
SQL Server skills – ability to write Transact-SQL queries or completed Course

Course ObjectivesThis five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to implementing a database.

TechnologiesThe workshop will empower developers to exploit the BI functionality in the following technologies:

SQL Server 2012 Database Services

While based on SQL Server 2012 version of SQL Server, this course is highly relevant for those working on SQL Server 2008 R2, 2008, and 2005 versions as well.

Day 1

Course IntroductionModule 1 - Introduction to SQL Server and its ToolsetIntroduction to the SQL Server Platform Working with SQL Server Components Configuring SQL Server Services LAB: Introduction to SQL Server and its Toolset

Module 2 – Working with Data TypesUsing Data Types Working with Character Data Converting Data Types Specialized Data Types LAB: Working with Data Types

Module 3 – Designing and Implementing TablesDesigning Tables Working with Schemas Creating and Altering Tables LAB: Designing and Implementing Tables

Module 4 – Ensuring Data Integrity through ConstraintsEnforcing Data Integrity Implementing Domain Integrity Implementing Entity and Referential Integrity LAB: Ensuring Data Integrity through Constraints

Day 2

Module 5 – Planning for SQL Server IndexingCore Indexing Concepts Data Types and Indexes Single Column and Composite Indexes LAB: Planning for SQL Server Indexing

Module 6 – Implementing Table Structures in SQL Server CodeSQL Server Table Structures Working with Clustered Indexes Designing Effective Clustered Indexes LAB:Implementing Table Structures in SQL Server

Module 7 – Reading SQL Server Execution PlansExecution Plan Core Concepts Common Execution Plan Elements Working with Execution Plans LAB: Reading SQL Server Execution Plans

Module 8 – Improving Performance through Nonclustered IndexesDesigning Effective Nonclustered Indexes Implementing Nonclustered Indexes Using the Database Engine Tuning Advisor LAB: Improving Performance through Nonclustered Indexes

Day 3

Module 9 – Designing and Implementing ViewsIntroduction to Views Creating and Managing Views Performance Considerations for Views LAB: Designing and Implementing Views

Module 10 – Designing and Implementing Stored ProceduresIntroduction to Stored Procedures Working With Stored Procedures Implementing Parameterized Stored Procedures Controlling Execution Context LAB: Designing and Implementing Stored Procedures

Module 11 – Merging Data and Passing TablesWorking with the MERGE Statement Implementing Table Types Using TABLE Types As Parameters LAB: Passing Tables and Merging Data

Module 12 – Designing and Implementing User-Defined FunctionsOverview of Functions Designing and Implementing Scalar Functions Designing and Implementing Table-Valued Functions Implementation Considerations for Functions Alternatives To Functions LAB: Designing and Implementing User-Defined Functions

Day 4

Module 13 – Creating Highly Concurrent SQL Server ApplicationsIntroduction to Transactions Introduction to Locks Management of Locking Transaction Isolation Levels LAB:Creating Highly Concurrent SQL Server Applications

Module 14 – Handling Errors in T-SQL CodeUnderstanding T-SQL Error Handling Implementing T-SQL Error Handling Implementing Structured Exception Handling LAB: Handling Errors in T-SQL Code

Module 15 – Responding to Data Manipulation via TriggersDesigning DML Triggers Implementing DML Triggers Advanced Trigger Concepts LAB: Responding to Data Manipulation via Triggers

Module 16 –Implementing Managed Code in SQL ServerIntroduction to SQL CLR Integration Importing and Configuring Assemblies Implementing SQL CLR Integration LAB: Implementing Managed Code in SQL Server

Day 5

Module 17 – Storing XML Data in SQL ServerIntroduction to XML and XML SchemasStoring XML Data and Schemas in SQL Server Implementing the XML Data Type LAB: Storing XML Data in SQL Server

Module 18 – Querying XML Data in SQL ServerUsing the T-SQL FOR XML Statement Getting Started with XQuery Shredding XML LAB: Querying XML Data in SQL Server

Module 19 – Working with SQL Server Spatial DataIntroduction to Spatial Data Working with SQL Server Spatial Data Types Using Spatial Data in Applications LAB: Working with SQL Server Spatial Data

Module 20 – Working with Full-Text Indexes and QueriesIntroduction to Full-Text Indexing Implementing Full-Text Indexes in SQL Server Working with Full-Text Queries LAB: Working with Full -Text Indexes and Queries