CONTACT CSU

No offerings have been identified for this subject in 2015

ITI517 SQL 2000 Database Designing (8)

Abstract

This subject is for information systems professionals and database designers and implementers. The subject steps through the planning and implementing of a database along with creating and maintaining database objects and database integrity. The subject also introduces students to Transact-SQL and how to use Transact-SQL to query a SQL server database and manage and manipulate data stored in that database.

+ Subject Availability Modes and Location

Continuing students should consult the SAL for current offering details prior to contacting their course coordinator: ITI517
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 for students enrolled in the following courses:

Master of Networking and System Administration
Master of Systems Development

Learning Outcomes

Upon successful completion of this subject, students should:
- describe the basic elements of SQL server 2000;
- design a SQL server enterprise application architecture;
- describe the conceptual basis of programming in Transact-SQL;
- create and manage databases and their related components;
- implement data integrity;
- plan for the use of indexes;
- implement user-defined functions;
- using stored procedures; and
- create and implement triggers.

Syllabus

The subject will cover the following topics:
Developing a Logical Data Model
- Defining entities
- Designing entity keys

Implementing the Physical Database

Creating and altering the database objects
- Space management
- Transaction logging

Retrieving and Modifying Data
- Importing and exporting data

Programming Business Logic
- Managing data manipulation
- Error handling
- Validating data

Tuning and Optimizing Data Access
- Creating and Implementing Indexing
- Monitoring and troubleshooting

Designing a Database Security Plan

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.