Implementing a Microsoft SQL Server 2008 R2 Database هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

This course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best practices on how to use SQL Server 2008 R2 product features.

Course Outline

1 - Introduction to SQL Server and its Toolset

• Introduction to SQL Server Platform
• Working with SQL Server Tools
• Configuring SQL Server Services
• Lab : Introduction to SQL Server and its Toolset

2 - Working with Data Types

• Using Data Types
• Working with Character Data
• Converting Data Types
• Working with Specialized Data Types
• Lab : Working with Data Types

3 - Designing and Implementing Tables

• Designing Tables
• Working with Schemas
• Creating and Altering Tables
• Lab : Designing and Implementing Tables

4 - Designing and Implementing Views

• Introduction to Views
• Creating and Managing Views
• Performance Considerations for Views
• Lab : Designing and Implementing Views

5 - Planning for SQL Server Indexing

• Core Indexing Concepts
• Data Types and Indexes
• Single Column and Composite Indexes
• Lab : Planning for SQL Server Indexing

6 - Implementing Table Structures in SQL Server

• SQL Server Table Structures
• Working with Clustered Indexes
• Designing Effective Clustered Indexes
• Lab : Implementing Table Structures in SQL Server

7 - Reading SQL Server Execution Plans

• Execution Plan Core Concepts
• Common Execution Plan Elements
• Working with Execution Plans
• Lab : Reading SQL Server Execution Plans

8 - Improving Performance through Nonclustered Indexes

• Designing Effective Nonclustered Indexes
• Implementing Nonclustered Indexes
• Using the Database Engine Tuning Advisor
• Lab : Improving Performance through Nonclustered Indexes

9 - Designing and Implementing Stored Procedures

• Introduction to Stored Procedures
• Working With Stored Procedures
• Implementing Parameterized Stored Procedures
• Controlling Execution Context
• Lab : Designing and Implementing Stored Procedures

10 - Merging Data and Passing Tables

• Using the MERGE Statement
• Implementing Table Types
• Using Table Types as Parameters
• Lab : Merging Data and Passing Tables

11 - Creating Highly Concurrent SQL Server Applications

• Introduction to Transactions
• Introduction to Locks
• Management of Locking
• Transaction Isolation Levels
• Lab : Creating Highly Concurrent SQL Server Applications

12 - Handling Errors in T-SQL Code

• Designing T-SQL Error Handling
• Implementing T-SQL Error Handling
• Implementing Structured Exception Handling
• Lab : Handling Errors in T-SQL Code

13 - Designing and Implementing User-Defined 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

14 - Ensuring Data Integrity through Constraints

• Enforcing Data Integrity
• Implementing Domain Integrity
• Implementing Entity and Referential Integrity
• Lab : Ensuring Data Integrity through Constraints

15 - Responding to Data Manipulation via Triggers

• Designing DML Triggers
• Implementing DML Triggers
• Advanced Trigger Concepts
• Lab : Responding to Data Manipulation via Triggers

16 - Implementing Managed Code in SQL Server

• Introduction to SQL CLR Integration
• Importing and Configuring Assemblies
• Implementing SQL CLR Integration
• Lab : Implementing Managed Code in SQL Server

17 - Storing XML Data in SQL Server

• Introduction to XML and XML Schemas
• Storing XML Data and Schemas in SQL Server
• Implementing the XML Data Type
• Lab : Storing XML Data in SQL Server

18 - Querying XML Data in SQL Server

• Using the T-SQL FOR XML Statement
• Getting Started with XQuery
• Shredding XML
• Lab : Querying XML Data in SQL Server

19 - Working with SQL Server Spatial Data

• Introduction to Spatial Data
• Working with SQL Server Spatial Data Types
• Using Spatial Data in Applications
• Lab : Working with SQL Server Spatial Data

20 - Working with Full-Text Indexes and Queries

• Introduction to Full-Text Indexing
• Implementing Full-Text Indexes in SQL Server
• Working with Full-Text Queries
• Lab : Working with Full-Text Indexes and Queries

Target Audience: This course is intended for IT Professionals who want to become skilled on SQL Server 2008 R2 product features and technologies for implementing a database. To be successful in this course, the student should have knowledge of basic relational database concepts and writing T-SQL queries.

Related Certifications:

• Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development