CONTACT CSU

No offerings have been identified for this subject in 2015

ITI516 Administering a SQL server (8)

Abstract

This subject is for information systems professionals and database administrators who need to install, administer and support Microsoft SQL server. The subject covers relational as well as security architecture. It also covers installation and upgrading of databases, creating and maintaining databases, integrating databases with other services, using cluster servers and maintaining and fine tuning SQL server. The subject is designed to enable students to appreciate the level of control that database administrators can have over SQL server.

+ Subject Availability Modes and Location

Continuing students should consult the SAL for current offering details prior to contacting their course coordinator: ITI516
Where differences exist between the handbook and the SAL, the SAL should be taken as containing the correct subject offering details.

Subject information

Duration Grading System School:
One sessionSY/USSchool of Computing and Mathematics

Assumed Knowledge

ITI500

Enrolment restrictions

Only available to students enrolled in:
Master of Networking and Systems Administration
Master of Management (IT) - MMgtInfoTech
Graduate Certificate in Management (IT) - GradCertMgtInfoTech

Learning Outcomes

Upon successful completion of this subject, students should:
- be able to describe the SQL server architecture;
- be able to plan for a SQL server installation and install an instance of SQL server;
- be able to manage files and databases, including determining resource requirements;
- be able to choose a login security method, configure login security, plan and implement database permissions, and describe how to help protect SQL server in an enterprise network;
- be able to perform and automate administrative tasks and create custom administrative tools;
- be able to back up databases and implement a backup strategy;
- be able to restore databases;
- be able to monitor and optimize SQL server performance;
- be able to transfer and migrate data into databases;
- be able to modify database schema;
- be able to maintain the high availability of SQL server;
- be able to manage linked server;
- be able to enforce and manage security by using stored procedures, triggers, views and user-defined functions; and
- be able to describe how to replicate data from one SQL server to another.

Syllabus

The subject will cover the following topics:
Based on MSN - 037

Back

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