Updating Your Database Administration Skills to Microsoft SQL Server 2005 (Yukon)

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 required to update their skills to install, configure, administer, and troubleshoot the client-server database management system to Microsoft® SQL Server™ 2005.

Skills Gained:
After completing this course, students will be able to:

Describe the components of SQL Server 2005.
Describe new and enhanced features for administrators in SQL Server 2005.
Plan a SQL Server 2005 installation.
Install SQL Server 2005.
Maintain a SQL Server 2005 installation.
Choose the appropriate tool or utility to perform an administrative task.
Use SQL Server Management Studio to manage databases.
Use SQL Server Computer Manager to manage a server.
Use the sqlcmd utility to execute Transact-SQL from the command prompt.
Use SQL Management Objects to script common administrative tasks.
Use SQL Profiler to monitor SQL Server 2005.
Use DDL triggers to respond to DDL events.
Use event notifications to respond to database events.
Query SQL Server metadata.
Maintain indexes in a SQL Server 2005 database.
Use the Database Tuning Advisor to assist with database design.
Maintain SQL Server 2005 databases.
Describe the security architecture of SQL Server 2005.
Manage securables and principals.
Manage permissions.
Use certificates in SQL Server 2005.
Describe common disaster recovery enhancements in SQL Server 2005.
Use database snapshots.
Perform backup and restore operations.
Describe the data availability technologies included in SQL Server 2005.
Describe the concepts of database mirroring.
Configure database mirroring.
Describe the enhancements to replication functionality in SQL Server 2005.
Describe the new types of replication available in SQL Server 2005.
Configure replication using SQL Server 2005.

Key Topics:
Overview of SQL Server 2005 Architecture
Installing SQL Server 2005
SQL Server 2005 Administrative Tools
Monitoring SQL Server 2005
Maintaining Databases and Indexes
Securing SQL Server 2005
Disaster Recovery
Data Availability in SQL Server 2005
SQL Server 2005 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

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
Administering a Microsoft SQL Server 2000 Database
Programming a Microsoft SQL Server 2000 Database
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
Fundamentals of Network Security
Implementing and Administering Security in a Microsoft Windows Server 2003 Network

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.