No offerings have been identified for this subject in 2016
ITI594 Designing Database Programming Solutions Using SQL Server (8)
AbstractThis is an industry based subject based on Microsoft Certified Database Administrator (MCDBA). This subject is designed to provide students with experience in Transact-SQL, data integrity, implementing stored procedure and triggers and topics on security and Server fine tunning. |
|
|
+ Subject Availability Modes and Location
Continuing students should consult the SAL for current offering details prior to contacting their course coordinator: ITI594
Where differences exist between the handbook and the SAL, the SAL should be taken as containing the correct subject offering details.
|
|
Subject informationDuration | Grading System | School: |
---|
One session | SY/US | School of Computing and Mathematics |
|
|
Enrolment restrictionsOnly for students enrolled in the following courses:
Master of Database Design and Management
Master of Networking and System Administration
Master of Systems Development
Master of Information Systems Security
Master of Management (IT) - MMgtInfoTech
Graduate Certificate in Management (IT) - GradCertMgtInfoTech |
|
|
Learning OutcomesUpon successful completion of this subject, students should:
- be able to describe the basic elements of SQL Server 200; - be able to design a SQL Server enterprise application architecture; - be able to describe the conceptual basis of programming in Transact-SQL; - be able to create and manage databases and their related components; - be able to implement data integrity; - be able to plan for the use of indexes; - be able to implement user defined functions; - be able to use stored procedures; - be able to create and implement triggers. |
|
|
SyllabusThe subject will cover the following topics: Introduction to Microsoft SQL Server 2005.
Using Transact-SQL.
Designing a database.
Implementing databases and tables.
Implementing Data Integrity.
Assessing and modifying data.
Managing and manipulating data.
Implementing Stored procedures.
Implementing Triggers.
Implementing views and indexes.
SQL Server Transactions and locks.
Designing and Administering SQL Server 2005 Security.
SQL Server Monitoring and Tuning. |
|
|
Back
The information contained in the 2016 CSU Handbook was accurate at the date of publication: 06 September 2016. The University reserves the right to vary the information at any time without notice.