Designing Microsoft SQL Server 2005 Server-Side Solutions
Short course
In London
Description
-
Type
Short course
-
Location
London
This three-day instructor-led course provides students with the knowledge and skills to design server-side solutions for Microsoft SQL Server 2005. The course focuses on teaching database developers who work in enterprise environments to identify and place database technologies during design to achieve a suitable solution that meets the needs of an organization. Students will also learn to consider the solution from a system-wide view instead of from a single database or server perspective.
Facilities
Location
Start date
Start date
Reviews
Course programme
Lessons
- Overview of the Built-inSQLServer Services
- Evaluating When to Use the NewSQLServer Services
- Evaluating the Use of Database Engine Enhancements
- Translating Business Requirements intoSQLServer Services
- Analyzing the Needs of Real Organizations
- Evaluate the use of the built-inSQLServer services
- Evaluate the use of the newSQLServer services
- Evaluate the use of database engine enhancements
Lessons
- Overview of Authentication Modes and Authorization Strategies
- Designing a Security Strategy for Components of aSQLServer 2005 Solution
- Designing Objects to Manage Application Access
- Creating an Auditing Strategy
- Managing Multiple Development Teams Using theSQLServer 2005 Security Features
- Evaluating the Security Tradeoffs ofSQLServer Services
- Designing a Database to Enable Auditing
- Designing Objects to Manage Application Access
- Justifying Security Decisions
- Select the authentication mode and authorization strategy for aSQLServer 2005 solution
- Design a security strategy for components of aSQLServer 2005 solution
- Design objects to manage application access
- Create an auditing strategy
- Manage multiple development teams by using theSQLServer 2005 security features
Lessons
- Defining Standards for StoringXMLData in a Solution
- Designing a Database Solution Schema
- Designing a Scale-Out Strategy
- Designing a Database Solution Schema
- Designing Integration of Multiple Data Stores
- Define standards for storingXMLdata in a solution
- Design a database solution schema
- Design a scale-out strategy for a solution
Lessons
- Defining Data Behavior Requirements
- Defining Isolation Levels
- Designing a Resilient Transaction Strategy
- Determining the Database Isolation Level
- Determining the Order of Object Access
- Designing Transactions
- Justifying a Transaction Strategy
- Define data behavior requirements
- Define isolation levels for a data store
- Design a resilient transaction strategy
Lessons
- Defining Event Data
- Designing a Subscription Strategy
- Designing a Notification Strategy
- Designing a Notification Delivery Strategy
- Defining Event Data
- Designing a Subscription Strategy
- Designing a Notification Strategy
- Executing a Notification Services Solution
- Define and store event data
- Design a subscription strategy for a Notification Services solution
- Design a notification strategy
- Design a notification delivery strategy
Lessons
- Designing a Service Broker Solution Architecture
- Designing Service Broker Data Flow
- Designing Service Broker Solution Availability
- Designing a Service Broker Solution Architecture
- Designing a Subscription Strategy
- Executing a Service Broker Solution
- Design a Service Broker solution architecture.
- Design the Service Broker data flow.
- Design the Service Broker solution availability.
Lessons
- Designing a Source Control Strategy
- Designing a Unit Test Plan
- Creating a Performance Baseline and Benchmarking Strategy
- Designing a Deployment Strategy
- Designing a Source Control Strategy
- Designing a Unit Testing Plan
- Designing a Deployment Strategy
- Justifying Source Control, Unit Test, and Deployment Strategies
- Design a source control strategy
- Design a unit test plan
- Create a performance baseline and benchmarking strategy
- Design a deployment strategy
Lessons
- Evaluating Common Table Expressions
- Evaluating Pivot Queries
- Evaluating Ranking Queries
- Overview of XQuery
- Overview of Strategies for Converting Data BetweenXMLand Relational Formats
- Evaluating Common Table Expressions
- Evaluating Pivot Queries
- Evaluating Ranking Queries
- Evaluating Techniques for ConvertingXMLinto Relational Data
- Evaluate the use of Common Table Expressions
- Evaluate the use of pivot queries
- Evaluate the use of ranking queries
- Evaluate the use of XQuery
- Evaluate strategies for converting data betweenXMLand relational formats
Designing Microsoft SQL Server 2005 Server-Side Solutions