Core-Skills: Practical SQL Server 2005
SQL Server 2005 Training Course for Sheffield, Leeds, Manchester & Yorkshire
- Home
- Training Services
- Course Schedules
- Microsoft Certifications
- Special Offers
- Room Hire
- Locations
- About Us
- Contact
The training we received was amongst the best I've experienced. The pace was just right, allowing for varying abilities in our group. Nothing was too much trouble during the course and the pleasant training environment just added to the experience I have no hesitation in recommending Rezound training services and will definitely use them again.
- Andy Wilton Profitmaster Systems Ltd
Course Information
| Course Code | PSS2005 |
| Fee | £1245 (Exclusive of VAT) |
| Duration | Five Days |
| Delivery Format | Instructor-Led |
| Alternative Delivery | MCTS CertSaver |
| Scheduled Dates: | Please Contact Us for Information |
Introduction
This five-day instructor-led course provides students with core product knowledge and the skills needed to implement a Microsoft SQL Server 2005 database. The course focuses on how to use the most common SQL Server 2005 product features and tools related to implementing databases.
Some of the features of this very practical course:
- Highly experienced Microsoft Certifield Trainer (MCT) with commercial development experience
- Microsoft Official Learning Product (MOLP) with units from courses 2779 and 2780
- Includes FREE eLearning course 2778E worth £161.10
- Includes FREE MeasureUp Practice Test Software for exam 70-431 worth £46.81
Audience
This course is intended for IT Professionals wanting to achieve core skills and practical experience with SQL Server 2005.
Completion
- Create databases and database files
- Create data types and tables
- Create and tune Indexes
- Implement Data Integrity by using Constraints
- Implement Data Integrity by using Triggers and XML Schemas
- Implement Views
- Implement Stored Procedures
- Implement Functions
- Install and configure SQL Server 2005
- Manage databases and files
- Understand disaster recovery
- Manage security
- Monitor SQL Server
- Transfer data
- Automate administrative tasks
Prerequisites
- Basic knowledge of the Microsoft Windows operating system and its core functionality
- Working knowledge of Transact-SQL (see below)
The learner will also ideally have the following skills though these are not essential:
- 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
NB we provide this course in eLearning form in advance of your attending the event.
Examinations
The course is designed to allow the learner to achieve practical core skills with SQL Server 2005. Many of the elements presented will help the learner meet some of the objectives of the following examination:
- Exam 70-431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance
If success in the above examination is a key initial goal we suggest that you review our MCTS Certsaver.
Materials
The student kit includes a comprehensive workbook and other necessary materials for this class.