MCTS: SQL Server 2008 - Installation and Maintenance Certification
MCTS: SQL Server 2008 - Installation and Maintenance Certification
 |
 |
Microsoft Certified Technology Specialists in SQL Server 2008 - Installation and Maintenance (MCTS: SQL Server 2008) Implement and maintain databases using specific instructions and specifications. They have thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and know how to navigate the user interface. Technology Specialists are typically pursuing careers as a database administrator, database developer, or business intelligence developer. They may also be individuals such as developers and systems administrators who do not work with SQL Server on a daily basis but wish to show their breadth of technology experience.
Our MCTS: SQL Server 2008, Implementation and Maintenance training course is the perfect solution for companies trying to figure out how to get the most out of their investments in SQL Server 2008. Rather than outsourcing your database development projects, equip your team with the skills required. This course is a cost-effective way to train groups of MCTS candidates with the least amount of disruption to operations possible.
Certification Objectives
After completing this Certification, students will be able to install and configure SQL Server 2008; manage database files; backup and restore databases; manage security; monitor SQL Server; transfer data into and out of SQL Server; automate administrative tasks; replicate data between SQL Server instances; maintain high availability. Students will also be able to create databases and database files; create data types and tables; use XML–related features in Microsoft SQL Server 2008; plan, create, and optimize indexes; implement data integrity in Microsoft SQL Server 2008 databases by using constraints; implement data integrity in Microsoft SQL Server 2008 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.
Intended Audience
- IT Professionals, IT generalists, and help desk professionals who want to learn about SQL Server 2008 are the audience for this course
- This Certification provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2008 database. It is intended for IT Professionals wanting to become skilled on SQL Server 2008 product features and technologies for maintaining a database
- It also provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. It is intended for IT Professionals who want to become skilled on SQL Server 2008 product features and technologies for implementing a database
The CTCLC Difference
Current Technologies Computer Learning Center uses our own Microsoft Certified Trainers that will help guide you to a sucessful completion of your Microsoft training and certification. Our Instructors are simply the best instructors you will find and have been certified and teaching Windows since Windows NT. Let our great instructors help you get started in understanding and using your Microsoft Technologies. CTCLC has convenient day or night schedules to fit your needs. We can also do onsite classes with our top notch portable labs.
Our instructors are the very best and give 110% to their Students. We care about every student that we train and we have a Free Resit Policy for all of our courses for the same revision. You will not find a better training experience anywhere. Come Experience the Current Technologies Computer Learning Center Way of training. We take great care of all of our students.
Current Technologies Computer Learning Center is Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Learning Alliance Member, EC-Council Accredited Training Center, and many others. We offer the highest quality, authorized training that you will find anywhere.
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
CTCLC SQL Server 2008 MCTS Training Path
 |
 |
MS-2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
MS-6231: Maintaining a Microsoft
SQL Server 2008 Database
This course teaches students how to install and configure SQL Server 2008; manage database files; backup and restore databases; manage security; monitor SQL Server; transfer data into and out of SQL Server; automate administrative tasks; replicate data between SQL Server instances; maintain high availability
MS-6232: Implementing a Microsoft
SQL Server 2008 Database
This course teaches students how to create databases and database files; create data types and tables; use XML–related features in Microsoft SQL Server 2008; plan, create, and optimize indexes; implement data integrity in Microsoft SQL Server 2008 databases by using constraints; implement data integrity in Microsoft SQL Server 2008 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.
Redeem Your Microsoft Software Assurance Training Vouchers
|
As a Microsoft Gold Learning Solutions Partner, Current Technologies CLC proudly accepts Microsoft Software Assurance Training Vouchers (SATV). You can attend Microsoft training at Current Technologies CLC for free, by redeeming your Microsoft vouchers. Call (219) 764-3800 for more information. |
CTCLC Special Discounts
| MS-6231 | Maintaining a Microsoft SQL Server 2008 Database | $2,400.00 |
| MS-6232 | Implementing a Microsoft SQL Server 2008 Database | $2,400.00 |
| List Price | $4,990.00 | |
| Special package price | $4,200.00 | |
| Special package price (2 or More from Same Company) | $3,895.00 | |
| Call (219) 764-3800 for Current Specials | ||
Above pricing is for Portage, Indiana location
Special prices available for on-site Training
CTCLC SQL Server Certification Path
|
|
| Required Exam(s) | Recommended Training |
|---|---|
| Exam 70-432 | MS-2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL |
| MS-6231: Maintaining a Microsoft SQL Server 2008 Database | |
| MS-6232: Implementing a Microsoft SQL Server 2008 Databas |
| SQL Server Certification Paths | ||||
Based on Microsoft Technology  |
 |
 |
 |
|
Version 2008 |
||||
 |
MCTS: SQL Server 2008 Installation & Maintenance | |
MCITP: Database Administrator 2008 | |
|
MCTS: SQL Server 2008 Database Development | |
MCITP: Database Developer 2008 | |
|
MCTS: SQL Server 2008 Business Intelligence Development and Maintenance | |
MCITP: Business Intelligence Developer 2008 |
|
Version 2005 |
||||
 |
MCTS: SQL Server 2005 |
|
MCITP: Database Administrator 2005 |
|
|
MCITP: Database Developer 2005 |
|||
For more Information About Microsoft Training or to Register for Courses
EMail: Sales@ctclc.com
Phone: (219) 764-3800