MS SQL Server 2005 database: implement

This five-day instructor-led SQL Server course provides students with the knowledge and skills 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.

This course is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for implementing a database.

Prior to undertaking this SQL Server course, students need to have:

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

During this Microsoft-certified SQL Server course, delegates will learn 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.
• Implement data integrity in Microsoft SQL Server 2005 by using triggers.
• Implement views.
• Implement stored procedures.
• Implement functions.
• Implement managed code in the database.
• Manage transactions and locks.
• Use Service Broker to build a messaging-based solution.
• Use Notification Services to generate and send notifications.

Deverill is a Microsoft Gold Certified Partner. This Microsoft-certified SQL Server course has a MS Topic Code of 2779.

Deverill offers this SQL Server 2005 and database course as both open courses that anyone can attend or as company specific training that can be delivered at your premises.

Send a » Request for Information to Deverill to find out more.

Deverill – high quality and great value

For customers both old and new, Deverill provides application and technical IT training of the highest quality and of the best value. Deverill offers a wide range of courses and associated services, including training for technical IT, desktop applications, business and soft skills. Deverill specialise in Microsoft applications (Gold Certified Partner), VMware, ITIL and IMS training.

Deverill’s instructor-led IT courses have such a renowned and established reputation due to the knowledgeable and friendly trainers treating our delegates with professionalism and care. Deverill’s trainers have business and/or support backgrounds, giving an understanding and enhanced confidence relating to delegates needs.

Deverill's technical IT courses can be delivered to suit your needs, from classroom training of IT applications (such as Microsoft or VMware) to the development of specific company training programmes, delivered on-site at our customers' offices covering all manner of technical IT subjects. With Deverill, your training needs (bespoke or otherwise) are just a phone call away.

Deverill's open technical IT courses are delivered at custom built, fully equipped IT training facilities in Dorset and Southampton. Post-course IT support is also provided for your peace of mind.

Deverill - does IT training
Contact Devrill to see how they can help your organisation.