Training Course:SQL Server 2005 (Certificate)School/Trainer:New Horizons Singapore
Singapore, Singapore
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' This course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers.
Who Should Attend:
This course is intended for experienced database administrators and database developers who are responsible for the supporting, configuring, and maintaining enterprise SQL Server 2005 databases and servers.
At Course Completion:
After completing this course, students will be able to: - Describe the architecture of SQL Server 2005. - Install SQL Server 2005. - Use SQL Server 2005 administrative tools and utilities. - Maintain SQL Server 2005 servers and databases. - Secure a SQL Server 2005 server and database. - Monitor SQL Server 2005. - Implement a Backup and Restore solution for SQL Server 2005. - Implement a data availability solution with database mirroring or clustering. - Use enhanced SQL Server 2005 replication features.
Prerequisite(s) or equivalent knowledge:
2072 Administering a Microsoft SQL Server 2000 Database
Prerequisite Comments:
MCDBA certification or equivalent knowledge
Administration experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0
Outline: Top
Lesson 1: Overview of SQL Server 2005 Architecture
Overview of SQL Server 2005
System Enhancements for Administrators
Top
Lesson 2: Installing SQL Server 2005
Preparing to Install SQL Server 2005
Performing a SQL Server 2005 Installation
Maintaining a SQL Server 2005 Installation
Lesson 3: SQL Server 2005 Administrative Tools
Using SQL Server Management Studio
Using SQL Server Computer Manager
Using the sqlcmd Utility
Using the SQL Management Objects
Lesson 4: Monitoring SQL Server 2005
Using SQL Profiler
Using DDL Triggers
Using Event Notifications
Using Metadata Views
Lesson 5: Maintaining Databases and Indexes
Managing Indexes
Using the Database Tuning Advisor
Top
Lesson 6: Securing SQL Server 2005
SQL Server 2005 Security Overview
Managing SQL Server 2005 Security
Managing Permissions
Managing Certificates
Lesson 7: Disaster Recovery
Disaster Recovery in SQL Server 2005
Using Database Snapshots
Backup and Restore Operations
Lesson 8: Data Availability in SQL Server 2005
Introduction to Data Availability
Introduction to Database Mirroring
Configuring Database Mirroring
Lesson 9: SQL Server 2005 Replication
Overview of Replication Enhancements
New Types of Replication
Configuring Replication
...''
Elements of this syllabus are subject to change.
Please go to the school's official website for training price and schedule:
http://www.newhorizons.com/
Phone:+65 6822 8282
School Address:
298 Tiong Bahru Road
Level 18 Central Plaza
Singapore 168730
Jobs & Resumes: Singapore
Houses & Roommates: Singapore
Travel Agencies: Singapore
Search other schools for SQL Server 2005 training resources.
Other training courses offered by New Horizons Singapore:
Programming with XML in the Microsoft .NET Framework
Analyzing Requirements and Defining Microsoft .NET Solution Architectures
Microsoft .NET Development
Foundations of Microsoft .NET 2.0 Development
Advanced Foundations of Microsoft .NET 2.0 Development
Developing Microsoft ASP.NET 2.0 Web Applications
Programming Microsoft .NET Applications with Microsoft Visual Studio 2005
Programming with the Microsoft .NET Framework using Microsoft Visual Studio 2005
Complete .NET Security
C# 3.0 Programming in the .NET Framework
Updating Your Database Development Skills to Microsoft SQL Server 2005
writing queries using microsoft sql server 2008 transact-sql
Maintaining a Microsoft SQL Server 2005 Database
Implementing a Microsoft SQL Server 2005 Database
Designing Microsoft SQL Server 2005 Server-Side Solutions
Designing Microsoft SQL Server 2005 Databases
designing the data tier for microsoft sql server 2005
tuning and optimizing queries using microsoft sql server 2005
Designing Microsoft SQL Server 2005 Infrastructure and Services
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges. |
|
| 
