Training Course:Maintaining a Microsoft SQL Server 2005 Database (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 product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.
Who Should Attend:
This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database.
At Course Completion:
After completing this course, students will be able to: - Install and configure SQL Server 2005 - Manage database files. - Manage security. - Perform administrative tasks. - Backup databases. - Restore databases. - Monitor SQL Server. - Troubleshoot SQL Server. - Transfer data. - Maintain high availability.
Prerequisite(s) or equivalent knowledge:
2779 Implementing a Microsoft SQL Server 2005 Database
50027 Querying and Processing SQL Server Data with SQL Statements
Prerequisite Comments:
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
Outline: Top
Lesson 1: Installing and Configuring SQL Server 2005
Preparing to install SQL Server.
Installing SQL Server.
Managing a SQL Server 2005 Installation.
Top
Lesson 2: Managing Databases and Files
Planning databases.
Creating databases.
Managing databases.
Lesson 3: Disaster Recovery
Planning a Backup Strategy.
Backing Up User Databases.
Restoring User Databases.
Recovering Data from Database Snapshots.
System Database and Disaster Recovery.
Lesson 4: Managing Security
Overview of SQL Server Security
Protecting the Server Scope
Protecting the Database Scope
Managing Keys and Certificates in SQL Server
Lesson 5: Monitoring SQL Server
Viewing Current Activity.
Using System Monitor.
Using SQL Server Profiler.
Using DDL Triggers.
Using Event Notifications.
Top
Lesson 6: Transferring Data
Overview of Data Transfer.
Introduction to SQL Server Integration Services (SSIS).
Using SQL Server Integration Services.
Features of SQL Server Integration Services
Lesson 7: Automating Administrative Tasks
Automating Administrative Tasks in SQL Server 2005.
Configuring the SQL Server Agent.
Creating Jobs and Operators.
Create Alerts.
Managing Multiple Servers.
Managing SQL Server Agent Security
Lesson 8: Implementing Replication
Overview of Replication.
Implementing Replication
Configuring Replication in Some Common Scenarios
Lesson 9: Maintaining High Availability
Introduction to High Availability.
Implementing Server Clustering.
Implementing Database Mirroring.
Implementing Log Shipping.
Implementing Peer-to-Peer 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 Maintaining a Microsoft SQL Server 2005 Database training resources.
Other training courses offered by New Horizons Singapore:
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
SQL Server 2005
Updating Your Database Development Skills to Microsoft SQL Server 2005
writing queries using microsoft sql server 2008 transact-sql
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
Designing Security for Microsoft SQL Server 2005
Designing a High Availability Database Solutions Using Microsoft SQL Server 2005
Administering and Automating Microsoft SQL Server 2005 Databases and Servers
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:
If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later. |
|
| 
