M50401 Designing and Optimizing Database Solutions with Microsoft SQL Server 2008

Level
Logo Focus on Training

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Focus on Training offers this product as a default in the following regions: N/A

Description

This five-day instructor-led course provides the knowledge and skills that IT Professionals need to design, optimize, and maintain SQL Server 2008 database.
The audience of this course is developers who implement database solutions or perform development utilizing the programming features and functionality of SQL Server. Students taking this course are expected to have three or more years of experience working on databases for two or more of the following phases in the product lifecycle – design, development, deployment, optimization, maintenance, or support. They should possess a four-year college degree, BS or BA, in the computer field. The students should have experience in the following a…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

This five-day instructor-led course provides the knowledge and skills that IT Professionals need to design, optimize, and maintain SQL Server 2008 database.
The audience of this course is developers who implement database solutions or perform development utilizing the programming features and functionality of SQL Server. Students taking this course are expected to have three or more years of experience working on databases for two or more of the following phases in the product lifecycle – design, development, deployment, optimization, maintenance, or support. They should possess a four-year college degree, BS or BA, in the computer field. The students should have experience in the following areas:

* Developing databases
* Writing Transact-SQL queries
* Designing, implementing and troubleshooting programming objects
* Doing database performance tuning and optimization
* Designing databases at both the conceptual and logical levels
* Implementing databases at the physical level
* Designing and troubleshooting the data access layer of an application
* Gathering business requirements

Delegates will learn how to:

* Design a database design strategy
* Design a database for optimal performance
* Design security for a database
* Design programming objects
* Design queries for performance
* Design a transaction and concurrency strategy
* Design an XML strategy

Module 1: Designing a Conceptual Database Model
Module 2: Designing a Logical Database Model
Module 3: Designing a Physical Database Model
Module 4: Designing Databases for Optimal Performance
Module 5: Designing Security for SQL Server 2008
Module 6: Designing a Strategy for Database Access
Module 7: Designing Queries for Optimal Performance
Module 8: Designing a Transaction and Concurrency Strategy
Module 9: Designing an XML Strategy
Module 10: Designing SQL Server 2008 Components

After completing this module, students will be able to:

* Examine the SQL Server 2008 architecture.
* Design a Service Broker architecture.
* Design the Service Broker data flow.
* Explore full-text search.
* Design a full-text search strategy.

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.