Print this page

Sql Server 2008 Certification

Designing and Optimising Database Solutions with Microsoft SQL Server 2008

A Five-Day Training Course

Course Content

Authorised Microsoft Training Course

This is an authorised Microsoft training course, delivered by certified Microsoft trainers at fully equipped centres using the latest equipment, software and course materials. There is no better way to undertake your training, to maximise your learning and ensure the highest marks possible in your certification exams.

Course Aims

This five-day instructor-led course provides the knowledge and skills that IT Professionals need to design, optimize, and maintain SQL Server 2008 database.

Who Should Attend

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.
Delegates 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

In addition, it is recommended, but not required, that students have completed:

  • Course 2779, Implementing a Microsoft SQL Server 2005 Database
  • Course 2780, Maintaining a Microsoft SQL Server 2005 Database

Course Outline

Module 1: Designing a Conceptual Database Model
• Overview of Database Design  • Gathering Database Requirements  • Creating a Conceptual Database Design  • Overview of Entity Framework 
Lab : Designing a Conceptual Database Model
• Formulating a Conceptual Database Design  • Creating a Conceptual Database Design 
Module 2: Designing a Logical Database Model
• Guidelines for Building a Logical Database Model  • Planning for OLTP Activity  • Evaluating Logical Models 
Lab : Designing a Logical Database Model
• Creating a Logical Database Model  • Normalizing the Logical Database Model 
Module 3: Designing a Physical Database Model
• Selecting Data Types  • Designing Database Tables  • Designing Data Integrity 
Lab : Designing a Physical Database Model
• Specifying Database Object Naming Standards  • Converting a Logical Database Model into a Physical Database Model 
Module 4: Designing Databases for Optimal Performance
• Guidelines for Designing Indexes  • Designing a Partitioning Strategy  • Designing a Plan Guide  • Designing Scalable Databases 
Lab : Designing Databases for Optimal Performance
• Applying Optimization Techniques  • Creating Plan Guides  • Designing a Partitioning Strategy 
Module 5: Designing Security for SQL Server 2008
• Exploring Security in SQL Server 2008  • Implementing Identity and Access Control  • Guidelines for Secure Development in SQL Server 2008  • Guidelines for Secure Deployment of SQL Server 2008  • Guidelines for Secure Operations 
Lab : Designing Security for SQL Server 2008
• Designing Secure Development  • Implementing Secure Operations  • Copying an Unencrypted Database  • Implementing Transparent Data Encryption  • Attempting to Copy an Encrypted Database 
Module 6: Designing a Strategy for Database Access
• Guidelines for Designing Secure Data Access  • Designing Views  • Designing Stored Procedures  • Designing User-Defined Functions 
Lab : Designing a Strategy for Database Access
• Designing Security for Data Retrieval Objects  • Designing Data Retrieval Objects 
Module 7: Designing Queries for Optimal Performance
• Considerations for Optimizing Queries for Performance  • Refactoring Cursors into Queries  • Extending Set-Based Operations 
Lab : Designing Queries for Optimal Performance
• Optimizing Query Performance  • Refactoring Cursors into Queries 
Module 8: Designing a Transaction and Concurrency Strategy
• Guidelines for Defining Transactions  • Defining Isolation Levels  • Guidelines for Designing a Resilient Transaction Strategy 
Lab : Designing a Transaction and Concurrency Strategy
• Determining the Database Isolation Level  • Determining the Order of Object Access  • Designing Transactions 
Module 9: Designing an XML Strategy
• Designing XML Storage  • Designing an XML Query Strategy  • Designing a Data Conversion Strategy 
Lab : Designing an XML Strategy
• Designing an XML Data Storage Model  • Converting Data Between XML and Relational Forms 
Module 10: Designing SQL Server 2008 Components
• Overview of SQL Server 2008 Components  • Designing a Service Broker Architecture  • Designing the Service Broker Data Flow  • Designing the Service Broker Availability  • Exploring Full-Text Search  • Designing a Full-Text Search Strategy 
Lab : Designing SQL Server 2008 Components
• Analyzing the Organizational Needs  • Designing a Service Broker Solution Model  • Designing a Detailed Service Broker Solution  • Implementing the Service Broker Solution 

Course Objectives

After completing this course, delegates 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

Certification

Microsoft Course 50401A

Print this page
Activia Training :   Training courses for business at seventeen locations UK wide