Awarding body
Generic award - no awarding body (NONE)
Attendance
Part time (day)
As the definition of full time and part time can vary from course to course, please check with the tutor as to the exact number of hours study each week this course will entail.
What's the Implementing a Microsoft SQL Server 2005 Database course about?
This instructor-led course provides students with the 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.
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
- 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
What will I be able to do after I've completed this course?
The course would help students to prepare for the Exam 70-431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance.
How do I apply?
For further information or to apply for a course, contact our Course Enquiry Team on FREECALL 0800 068 8585 or email enquiries@themanchestercollege.ac.uk.
You can also apply on line for this course
How much will the course cost me?
You can call our Course Enquiry Team on FREECALL 0800 068 8585 for details of the fees for this course.
What qualifications or experience do I need to do this course?
Applicants 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
Which qualification will I be awarded if I successfully complete the Implementing a Microsoft SQL Server 2005 Database course?
No formal qualifications are awarded.
Hours per week
30
As the definition of full time and part time can vary from course to course, please check with the tutor as to the exact number of hours study each week this course will entail.
Printer-friendly version
Email to a friend