Implementing a Microsoft SQL Server 2005 Database

Unitek Information Systems
Atlanta, Austin, Boston, Chicago, Dallas, Fremont, Portland, Sacramento, San Diego, Seattle, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' After completing the 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





Prerequisites

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.
In addition, it is recommended, but not required, that students have completed:

Course 2778, Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.
...''

Phone:888 - 825 - 6273

School Address:

4670 Auto Mall Parkway
Fremont, California 94538 USA


Jobs & Resumes: Atlanta, Austin, Boston, Chicago, Dallas, Fremont, Portland, Sacramento, San Diego, Seattle
Houses & Roommates: Atlanta, Austin, Boston, Chicago, Dallas, Fremont, Portland, Sacramento, San Diego, Seattle
Travel Agencies: Atlanta, Austin, Boston, Chicago, Dallas, Portland, San Diego, Seattle

Search other schools for Implementing a Microsoft SQL Server 2005 Database training resources.

MCITP: Database Administrator Boot Camp
MCITP: Database Developer Boot Camp
MCITP: SQL Server 2005 Business Intelligence Developer Boot Camp
MCTS: SQL Server 2005 - Implementation and Maintenance Boot Camp
MCTS: SQL Server 2005 Business Intelligence Boot Camp
Core Technologies in Microsoft SQL Server 2005
Administering and Automating Microsoft SQL Server 2005 Databases and Servers
Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005
Tuning and Optimizing Queries using Microsoft SQL Server 2005
Maintaining a Microsoft SQL Server 2005 Database
SQL Server 2005 Analysis Services
SQL Server 2005 Integration Services
SQL Server 2005 Reporting Services
Microsoft SQL Server 2008
MCTS: Microsoft System Center Configuration Manager 2007, Configuring
MCTS: Microsoft System Center Operations Manager 2007
Managing System Center Operations Manager 2007
Implementing System Center Data Protection Manager 2007

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.