Administering a Microsoft SQL Server 2000 Database

Dimension Data Learning Solutions
Syndey,Brisbane,Canberra,South Melbourne,Adelaide,Perth, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft® SQL Server™ 2000. Course 2072 is a revision of course 832: System Administration for Microsoft SQL Server 7.0. The course content is being revised to reflect changes in the product.

Skills Gained:
* Describe SQL Server architecture.
* Plan for a SQL Server installation, & then install an instance of SQL Server.
* Manage files and databases, including determining resource requirements.
* Choose a login security method, configure login security, plan & implement database permissions, & describe how to secure SQL Server in an enterprise network.
* Perform & automate administrative tasks and create custom administrative tools.
* Back up databases & implement a backup strategy.
* Restore databases.
* Monitor and optimize SQL Server performance.
* Transfer and migrate data into databases.
* Maintain the high availability of SQL Server.
* Describe how to replicate data from one SQL Server to another.

Key Topics:
Module 1: SQL Server Overview
Module 2: Planning to Install SQL Server
Module 3: Managing Database Files
Module 4: Managing Security
Module 5: Performing Administrative Tasks
Module 6: Backing Up Databases
Module 7: Restoring Databases
Module 8: Monitoring SQL Server for Performance
Module 9: Transferring Data
Module 10: Maintaining High Availability
Module 11: Introducing Replication
...''

Phone:61 2 9299 3333

School Address:

Level 10
301 George St
Sydney, NSW
Australia - 2000
Phone : 61 2 9299 3333
Fax : 61 2 9299 7585
Email : training@didata.com.au

10th Floor, Thakral House
301 George St
Syndey , NSW
Australia - 2000
Phone : 61 131 201 or 61 2 9299 3333
Fax : 61 2 9299 3154

12th Floor,
307 Queen St
Brisbane , QLD
Australia - 4000
Phone : 61 131 201 or 61 7 3221 2444
Fax : 61 7 3221 2744


1st Floor,
32 London Circuit
Canberra , ACT
Australia - 2601
Phone : 131204 or 2 62637900
Fax : 61 2 6248 6436


3rd Floor,
11-17 Dorcas St
South Melbourne , VIC
Australia - 3205
Phone : 61 131 201 or 61 3 9626 0770
Fax : 61 3 9696 0786


4th Floor,
139 Frome St.
Adelaide , SA
Australia - 5000
Phone : 61 131 201 or 61 8 8236 8200


Jobs & Resumes: Syndey, Brisbane, Canberra, South Melbourne, Adelaide, Perth
Houses & Roommates: Syndey, Brisbane, Canberra, South Melbourne, Adelaide, Perth

Implementing and Supporting Microsoft Windows XP Professional
Installing, Configuring, and Administering Microsoft Windows XP Professional
Designing a Microsoft Exchange Server 2003 Organ
Upgrading Your Skills from Microsoft Exchange Server 5.5 to Microsoft Exchange Server 2003
Troubleshooting Microsoft Exchange Server 2003
Implementing and Managing Microsoft?Exchange Server 2003
Customizing Microsoft?SharePoint?Products and Technologies 2003
Designing IT Platform Collaborative Applications with Microsoft SharePoint 2003 Workshop
Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services
Querying Microsoft SQL Server 2000 with Transact-SQL
Programming a Microsoft SQL Server 2000 Database
Updating Your Database Administration Skills to Microsoft SQL Server 2005 (Yukon)
Updating Web Server Skills to Internet Information Services 6.0
Developing E-Business Solutions using Microsoft BizTalk Server 2004
Deploying and Managing E-Business Solutions Using Microsoft BizTalk Server 2004
Designing, Deploying, and Managing a Network Solution for the Small and Medium-sized Business
Building Microsoft Commerce Server 2002 Solutions
Building Microsoft Content Management Server 2002 Solutions
Designing E-Business Solutions using Microsoft BizTalk Server 2004

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.