ITI517 SQL 2000 Database Designing (8)
CSU Discipline Area: Unallocated to a CSU Discipline code (OTHER)
Duration: One session
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 Locations
No offerings have been identified for this subject in 2013.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.
Assumed Knowledge:
Enrolment restrictions:
Only for students enrolled in the following courses: Master of Networking and System Administration Master of Systems Development
Objectives:
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
The information contained in the 2013 CSU Handbook was accurate at the date of publication: 24 April 2013. The University reserves the right to vary the information at any time without notice.