My Account |  My Basket | Checkout   
     
 
Nexgenn Logo
Home | About Us | Services | Offers | News | Contact Us
 
  
 

Maintaining a Microsoft SQL Server 2005 Database

Product Code: MS2780

Maintaining a Microsoft SQL Server 2005 Database Overview This five-day, instructor-led course provides students with the knowledge and skills necessary 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. What’s Included? All our public scheduled training courses offer delegates the following facilities which are all included at no extra cost: -
  • Mini Continental Breakfast, with a choice of Croissants, Pastries, Cereals, Juices, and of course Tea and Coffee
  • Buffet Lunch
  • A Selection of Soft Beverages are available throughout the Training Day
  • Full Course Manual (Official Curriculum Courseware for Technical Courses)
  • Course Exercise Files on CD or Floppy Disk
  • Course Stationery Pack (Pen, Pencil and Paper)
  • Framed Course Certificate (Vendor Accredited where required)
Objectives At the end of the course, students will be able to:
  • Install and Configure SQL Server 2005
  • Manage Databases and Files
  • Describe Disaster Recovery
  • Manage Security
  • Monitor SQL Server
  • Transfer Data
  • Automate Administrative Tasks
  • Maintain High Availability
  • Implement Replication
      Audience This course is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for maintaining a Database. 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
      • In addition, it is recommended, but not required, that students have completed Course MS2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL and Course MS 2779: Implementing a Microsoft SQL Server 2005 Database
          Code You may also know this course as:
          • MS2780
          • MS 2780
          • MOC2780
          • MOC 2780
          • M2780
          • 2780

More Products in SQL Server 2005

Administering and Automating Microsoft SQL Server 2005 Databases and Servers
Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005
Designing a Microsoft SQL Server 2005 Infrastructure
Designing a Reporting Solution Architecture using Microsoft SQL Server 2005 Reporting Services
Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services
Designing an ETL Solution Architecture using Microsoft SQL Server 2005 Integration Services
Designing High Availability Database Solutions Using Microsoft SQL Server 2005
Designing Microsoft SQL Server 2005 Databases
Designing Microsoft SQL Server 2005 Server-Side Solutions
Designing Security for Microsoft SQL Server 2005
Designing the Data Tier for Microsoft SQL Server 2005
Implementing a Microsoft SQL Server 2005 Database
Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services
Implementing and Maintaining Microsoft SQL Server 2005 Integration Services
Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
Maintaining a Microsoft SQL Server 2005 Database
Microsoft SQL Server 2005 for the Experienced Oracle Database Administrator
Troubleshooting and Optimising Database Servers Using Microsoft SQL Server 2005
Tuning and Optimising Queries Using Microsoft SQL Server 2005
Updating Your Database Administration Skills to Microsoft SQL Server 2005
Updating your Database Development Skills to Microsoft SQL Server 2005
Upgrading to Microsoft SQL Server 2005

More Categories In Learning & Development

MCSE From Scratch, Business Strategies, MCSD From Scratch, HR Development, Sales & Marketing Training, Management Training, Essential Communication Skills, Microsoft .NET, Office 2007, Microsoft Security, SharePoint Server, Small Business Server 2003, SQL Server 2005, SQL Server 2008, Windows NT4 Server, Windows Server 2003, View More Learning & Development...

 
     
Site By Paraspar