SQL Server Training

SQL Server Training

Designing and Optimizing Database Solutions with Microsoft SQL Server 2008

Microsoft 50401

Microsoft Certification

Length: 5 Days
Published: June 01, 2010
Language(s): English
Audience(s): Developers
Level: 300
Technology: Microsoft SQL Server 2008
Type: Course
Delivery Method: Instructor-led (classroom)
About this Course
This five-day instructor-led course provides the knowledge and skills that IT Professionals need to design, optimize, and maintain SQL Server 2008 database.
Audience Profile
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
At Course Completion
After completing this course, students will be able 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
Microsoft Training Discount Price Match Guarantee Microsoft Training Locations Redeem your Microsoft Training Vouchers here!