Training Course:Maintaining a Microsoft SQL Server 2005 Database (Certificate)School/Trainer:Techno-ed
Islamabad, Karachi, Lahore, Pakistan
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' This three-day instructor-led 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. This three-day instructor-led 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 will the course benefit?
This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database.
Course Objectives
To provide basic SQL Server 2005 skills for the Database Administrators.
Skills Gained
This course will enable delegates to:
Install and configure SQL Server 2005.
Manage database files.
Manage security.
Perform administrative tasks.
Back up databases.
Restore databases.
Monitor SQL Server.
Troubleshoot SQL Server.
Transfer data.
Maintain high availability.
Prerequisites
Before attending this course, students must have: �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. �Working knowledge of Transact-SQL. It is recommended, but not required, that students have completed Parity course Introduction to SQL ( SQL ) or have equivalent skills. It is helpful, but not essential to have also completed course Implementing a Microsoft SQL Server 2005 Database.
Follow-on Courses
� Implementing a Microsoft SQL Server 2005 Database
Course Content
Installing and Configuring SQL Server 2005
Preparing to install SQL Server.
Installing SQL Server.
Managing a SQL Server 2005 Installation.
Managing Databases and Files
Planning databases.
Creating databases.
Managing databases.
Disaster Recovery
Planning a Backup Strategy.
Backing Up User Databases.
Restoring User Databases.
Recovering Data from Database Snapshots.
System Database and Disaster Recovery.
Managing Security
Overview of SQL Server Security.
Securing the Server Scope.
Securing the Database Scope.
Managing Keys and Certificates in SQL Server.
Monitoring SQL Server
Viewing Current Activity.
Using System Monitor.
Using SQL Server Profiler.
Using DDL Triggers.
Using Event Notifications.
Transferring Data
Overview of Data Transfer.
Introduction to SQL Server Integration Services.
Using SQL Server Integration Services.
Automating Administrative Tasks
Automating Administrative Tasks in SQL Server 2005.
Configuring the SQL Server Agent.
Creating Jobs and Operators.
Creating Alerts.
Managing Multiple Servers.
Managing SQL Server Agent Security.
Maintaining High Availability
Introduction to High Availability.
Implementing Server Clustering.
Implementing Database Mirroring.
Implementing Log Shipping.
Introduction to Replication
Overview of Replication.
Replication Scenarios.
Examinations
The combination of this course and MS2779A lead to Exam 70-431 : Microsoft SQL Server 2005—Implementation and Maintenance, which is at the Technology Specialist level. ...''
Please go to the school's official website for training price and schedule:
http://www.techno-ed.com/
Phone:+92-42- 585 4881-5
School Address:
Lahore
33-L, Gulberg III, Near Askari Flats, Kalma Chowk, Lahore
Ph: +92-42- 585 4881-5
Islamabad
Address: 13-P, Empire Center, 2 nd Floor, F-7 Markaz, Jinnah Super, Islamabad.
Ph: +92-51- 2654108
Karachi
190-A, Block -AS.M.C.H, Shahrah-e-Faisal, Karachi.
Ph: +92-21- 4381833-4
Jobs & Resumes: Islamabad, Karachi, Lahore
Houses & Roommates: Islamabad, Karachi, Lahore
Travel Agencies: Islamabad, Karachi, Lahore
Search other schools for Maintaining a Microsoft SQL Server 2005 Database training resources.
Other training courses offered by Techno-ed:
Oracle Database 10g: Programming with PL/SQL
Oracle9i Forms Developer: Build Internet Applications
Oracle9i Reports Developer
Oracle Database 10g Admin- (OCA)
Oracle Database 10g Admin (OCP)
Oracle 11i E-biz Solutions
Oracle 11i Financials General Ledger
Oracle Jdeveloper
Implementing a Microsoft SQL Server 2005 Database
Implementing and Maintaining a Microsoft SQL 2005 Database
Updating Your Database Administration Skills to Microsoft SQL Server 2005
Updating Your Database Development Skills to Microsoft SQL Server 2005
RH 033 Red Hat Linux Essentials
RH 133 Red hat Linux System Administration
RH 253 Red hat Linux Network & Security
IT Essentials
Network Operating Systems
Building Cisco Multilayer Switched Networks
Building Scalable Cisco Internetworks
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. |
|
|
