ITI592 Designing Database Administration Solutions Using SQL Server (8)

This is an industry based subject based on Microsoft Certified Database Administrator (MCDBA). This subject is designed to provide students with experience in planing, designing, implementing and maintaining a complex Database using SQL Server 2005 including designing the security architecture.

Subject Outlines
Current CSU students can view Subject Outlines for recent sessions. Please note that Subject Outlines and assessment tasks are updated each session.

No offerings have been identified for this subject in 2018.

Where differences exist between the Handbook and the SAL, the SAL should be taken as containing the correct subject offering details.

Subject Information

Grading System

SY/US

Duration

One session

School

School of Computing and Mathematics

Enrolment Restrictions

For students enrolled in only the following courses:

Master of Database Design and Management
Master of Networking and System Administration
Master of Systems Development
Master of Information Systems Security

Prerequisites

ITI500

Learning Outcomes

Upon successful completion of this subject, students should:

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;

maintain indexes in a SQL Server 2005 database;

describe the security architecture of SQL Server 2005;

describe the data availability technologies included in SQL Server 2005;

describe the concepts of database mirroring.

Syllabus

This subject will cover the following topics:

Preparing to Install SQL Server 2005.

Performing a SQL Server 2005 Installation.

Maintaining a SQL Server 2005 Installation.

Using SQL Server Management Studio.

Using SQL Server Computer Manager.

Using the SQL Management Objects.

Creating a Personnel database.

Using Event Notifications.

Using Metadata Views.

Use SQL Profiler to monitor SQL Server 2005.

Managing Indexes.

Using the Database Tuning Advisor.

Defining Indexes.

Tuning a Database.

Managing SQL Server 2005 Security.

Managing Permissions.

Managing Certificates.

Managing securables.

Managing principals.

Managing Permissions.

Dropping a User that Created Objects.

Disaster Recovery in SQL Server 2005.

Using Database Snapshots.

Backup and Restore Operations.

Configuring Database Mirroring.

Contact

Current Students

For any enquiries about subject selection or course structure please contact Student Central or ask@csu.edu.au or phone on 1800 275 278.

Prospective Students

For further information about Charles Sturt University, or this course offering, please contact info.csu on 1800 275 278 (free call within Australia) or enquire online.

The information contained in the 2018 CSU Handbook was accurate at the date of publication: August 2018. The University reserves the right to vary the information at any time without notice.

Back