Object and Data Labs
  Certificates   Free Newsletter   What's New   Contact
              Sitemap
Main Areas
Onsite Training
Courses
Class Schedule
Registration
Tuition Discounts
Technology Library
Our Instructors
Our Customers
Why Object & Data Labs?

Hot New Courses:
XML: A Comprehensive Introduction
Disaster Recovery Planning

How students rate us

Free Newsletter
Visit our technology library and sign up to receive the latest word in technology from industry specialist.

Certification Available
Visit our certification page to see how you can be on the fast track to certification in advanced technologies.
  Home > Courses > Course Descriptions Print Page
Course Description

Implementing a Microsoft SQL Server 2005 Database

Course Objective


In-House Training for as few as 3 Attendees >>

Or Call Toll Free
1-888-230-9052

SQL Server 2005 is a landmark release of Microsoft’s powerful relational database management system for the Windows platform. It will change the way you architect your data systems and develop your data driven applications

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

What you will learn

  • 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

Who should attend

  • IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for implementing a database.

Prerequisites

  • 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

 

Onsite Training  Class Schedule  Registration

 

  Home | Courses | Class Schedule | Registration | About Us | Contact Call us TOLL FREE at 1-888-230-9052
Copyright 2003-2013, Object & Data Labs All Object & Data Labs Courses are certified courses with UC Berkeley & UCSC extension 

Website by Howard Pugh Web Design
Website maintained by Ann T. Comey