InformIT Home About InformIT Oracle Workforce Development Program Cisco Networking Academy Program Microsoft IT Training & Certification Other Intensive Training International IT Certifications
  Windows Essentials  
  SQL Server Administrator  
  Windows Server 2003  
  Office Power User  
  Office Specialist  





















































Implementing a Microsoft SQL Server 2005 Database
Course 2779: 4 days; Instructor-led

This course provides students with knowledge and skills needed to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 features and tools related to implementing a database

To top of page

Course Objectives

After completing this course, students will be able to:

  • Create databases and database files
  • Create data types and tables
  • Use XML-related features in Microsoft SQL Server 2005
  • Plan, create, and optimize indexes
  • Implement data integrity in Microsoft SQL Server 2005 databases by using constraints, triggers, and XML schemas
  • Implement views
  • Implement stored procedures and functions
  • Implement managed code in the database
  • Use Service Broker to build a messaging-based solution
  • To top of page

    Microsoft Certified Technology Specialist Exams

    This course will help the student prepare for the following Microsoft Certified Technology Specialist exam:

    • Exam 70-431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance

    To top of page


    Before attending this course, students must have:

    • Basic knowledge of the Microsoft Windows operating system and its core functionality
    • Working knowledge of Transact-SQL
    • Working knowledge of relational databases
    • Some experience with database design

    To top of page

    Course Outline

    Creating Databases and Database Files
    • Creating Databases
    • Creating Filegroups
    • Creating Schemas Creating Database Snapshots

    Writing Queries Using Microsoft SQL Server 2005 Transact-SQL

    • Get started with databases and Transact-SQL
    • Perform basic queries
    • Group and summarize data
    • Join data from multiple tables
    • Work with subqueries
    • Modify data
    • Query metadata, XML, and full-text indexes
    • Use programming objects for data retrieval
    • Use advanced querying techniques

    Creating Data Types and Tables

    • Creating Data Types
    • Creating Tables
    • Creating Partitioned Tables

    Using XML

    • Retrieving XML by Using FOR XML
    • Shredding XML by Using OPENXML
    • Using the xml Data Type

    Creating and Tuning Indexes

    • Planning Indexes
    • Creating Indexes
    • Optimizing Indexes
    • Creating XML Indexes

    Implementing Data Integrity

    • Data Integrity Overview
    • Implementing Constraints
    • Implementing Triggers
    • Implementing XML Schemas

    Implementing Views

    • Introduction to Views
    • Creating and Managing Views
    • Optimizing Performance by Using Views

    Implementing Stored Procedures and Functions

    • Implementing Stored Procedures
    • Creating Parameterized Stored Procedures
    • Creating Functions
    • Handling Errors
    • Controlling Execution Context

    Implementing Managed Code in the Database

    • Introduction to the SQL Server Common Language Runtime
    • Importing and Configuring Assemblies
    • Creating Managed Database Objects

    Using Service Broker

    • Service Broker Overview
    • Creating Service Broker Objects
    • Sending and Receiving Messages


    INFORMIT - Skill Development Center
    Jl. Purnawarman 9c, Bandung 40117- Phone (022) 4224 168 / 4223 168
    Fax. (022) 4231 168 - E-mail:

      Home | About Us | Oracle | Cisco | Microsoft | Other Training | Certification | Training Calendar  
    © 2006, InformIT Ganesa Pratama. All Right Reserved