Designing Microsoft SQL Server 2005 Infrastructure and Services

New Horizons Learning Centres of Australia
Sydney, Brisbane, Melbourne, Perth, Newcastle, Australia

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

Course Description:

'' This course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL ServerT 2005 database infrastructure.
Pre-requisite:
Have a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential or equivalent experience
Outline:
Lesson 1: Analyzing Capacity Needs
- Estimating Storage Requirements
- Estimating CPU Requirements
- Estimating Memory Requirements
- Estimating Network Requirements
-
Lesson 2: Designing a Strategy for Data Archiving
- Identifying Requirements that Affect Data Archiving
- Determining the Structure of Archival Data
- Creating a Data Archival Plan
-
Lesson 3: Designing a Strategy for Database Server Consolidation
- Overview of Database Server Consolidation
- Designing a Strategy for SQL Server Instances
- Designing a Database Server Consolidation Plan
-
Lesson 4: Designing a Strategy for Data Distribution
- Overview of Data Distribution
- Creating a Data Distribution Plan Using Replication
-
Lesson 5: Designing a Database Server Infrastructure
- Evaluating the Current Database Server Infrastructure
- Gathering Requirements for Changing a Database Server Infrastructure
- Designing Modifications to a Database Server Infrastructure
-
Lesson 6: Designing a Strategy for Data Recovery
- Creating a Backup and Restore Strategy
- Creating a Database Disaster Recovery Plan
-
Lesson 7: Establishing Database Conventions and Standards
- Creating Database Naming Conventions
- Defining Database Infrastructure Standards ...''

Phone:+61 2 8263 5900

School Address:

Level 6, St. Martins Tower
31 Market Street
Sydney NSW 2000 Australia
Level 4, 200 Creek Street,
Brisbane, QLD 4000
Level 2, 31 Queen Street,
Melbourne, VIC 3000

Jobs & Resumes: Sydney, Brisbane, Melbourne, Perth, Newcastle
Houses & Roommates: Sydney, Brisbane, Melbourne, Perth, Newcastle

Linux Fundamentals
Linux+ Certification
IBM Lotus Domino Designer 6
Exchanging and Transforming Data Using XML and XSLT
Introduction to C# Programming for the Microsoft .NET Platform
Developing Secure Web Applications
Developing Microsoft ASP.NET Web Applications Using Visual Studio .NET
Programming with the Microsoft.NET Framework (Visual C#.NET)
Upgrading Web Development Skills from ASP to Microsoft ASP.NET
Introduction to C Programming
Designing a High Availability Database Solutions Using Microsoft SQL Server 2005
Troubleshooting and Optimizing Database Servers using Microsoft SQL Server 2005

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: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.