Skip to Content Text Only

SITEMAP

• Current Class Schedules
• Customized Contractual Education
• 4 Ways to Register
• Rent a Computer Lab
• Upcoming Events
• Directions & Parking
• General Information About CTU
• MCE&CE Home Page

• Welcome Message
• Request Information

• Sitemap
• Search
• Adverse Weather
• Contact Us

MCTS Implementing and Maintaining SQL Server 2008
(70-432)

This course will help you to specialize your technological knowledge for Microsoft SQL Server 2008. It will prepare you to take the Microsoft Certified Technology Specialist certification exam that will demonstrate an IT professional's in-depth, current skills in SQL Server 2008. The course will cover implementing and maintaining databases using specific instructions and specifications. You will gain thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and how to explore the user interface.

Suggested Prerequisites:

• Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
  course outline
• MCTS Implementing SQL 2008 Server or experience equivalent

Duration: 48 contact hours
Tuition: $3499

Implementing a SQL Server 2008 Database

This course will help you to specialize your technological knowledge for Microsoft SQL Server 2008. It will prepare you to take the Microsoft Certified Technology Specialist certification exam that will demonstrate an IT professional's in-depth, current skills in SQL Server 2008. The course will cover implementing databases using specific instructions and specifications. You will gain thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and how to explore the user interface.

Suggested Prerequisites:

• Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
  course outline

Duration: 24 contact hours
Tuition: $1999

Attend and You Will Learn

• Introduction to SQL Server 2008
• Installing and Configuring SQL Server 2008
• SQL Server Tools Introduction
• Managing Databases and Filegroups
• Working with Transact SQL
• Creating Tables, Constraints and User-Defined Types
• Creating Indexes
• Implementing Views
• Creating Functions, Stored Procedures, and Triggers
• Creating Partitions
• Using Transact SQL to Manage Databases
• Managing XML Data
• Working with HTTP Endpoints
• Using Managed Code in SQL Server 2008(not in text)
• Working with Service Broker

Maintaining a SQL Server 2008 Database

This course will help you to specialize your technological knowledge for Microsoft SQL Server 2008. It will prepare you to take the Microsoft Certified Technology Specialist certification exam that will demonstrate an IT professional's in-depth, current skills in SQL Server 2008. The course will cover maintaining databases using specific instructions and specifications. You will gain thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and how to explore the user interface.

Suggested Prerequisites:

• MCTS Implementing SQL 2008 Server or experience equivalent
• Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
  course outline

Duration: 24 contact hours
Tuition: $1999

Attend and You Will Learn

• Review Managing Databases
• Backing Up, Restoring, and Moving a Database
• Managing Database Snapshots
• Automating Administrative Tasks
• Managing SQL Server Security
• SQL Server High Availability Technologies: Clustering
• SQL Server High Availability Technologies: Database Mirroring
• SQL Server High Availability Technologies: Log Shipping
• SQL Server High Availability Technologies: Replication
• Monitoring SQL Server
• Transferring Data
• Creating Full-Text catalogs

---

Supplemental Course

Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

This course provides you with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008. This course is a suggested prerequisite for the MCTS Implementing and Maintaining SQL Server 2008 program.

Suggested Prerequisites:

• Relational database design skills
• Programming skills
• Knowledge of data integrity concepts
• Core Windows Server skills

Duration: 16 contact hours
Tuition: $999

Attend and You Will Learn

• Describe the uses of and ways to execute the Transact-SQL language
• Use querying tool
• Write SELECT queries to retrieve data
• Group and summarize data by using Transact-SQL
• Join data from multiple tables
• Write queries that retrieve and modify data by using subqueries
• Modify data in tables
• Query text fields with full-text search
• Describe how to create programming objects
• Use various techniques when working with complex queries

or Phone/Fax/Mail
or call 919.515.8163