ITI593 Developing 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 clustering, log shipping, replication, setting up integrated security, logins, roles, groups, permissions, task automation, monitoring, troubleshooting, and maintenance.

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:

describe SQL Server 2005 and its supported operating system platforms;

describe SQL Server databases;

describe SQL Server security;

describe SQL Server administration and implementation activities, as well as SQL Server application design options;

describe the concepts of enterprise-level application architecture;

describe the primary SQL Server programming tools;

describe the use of local variables, operators, functions, control of flow statements, and comments;

create and drop user tables;

set locking options and display locking information;

describe how SQL Server index architecture facilitates the retrieval of data;

describe the importance of selectivity, density, and distribution of data when deciding which columns to index;

identify resource items that can be locked and the types of locks;

analyse the performance gain of writing efficient queries and creating useful indexes for queries that contain the AND logical operator.

Syllabus

This subject will cover the following topics:

Designing Enterprise Application Architecture.

SQL Server Programming Tools.

The Transact-SQL Programming Language.

Elements of Transact-SQL.

Additional Language Elements.

Types of Data Integrity.

Enforcing Data Integrity.

Defining Constraints.

Types of Constraints.

Describe the methods to enforce data integrity.

Index Architecture.

Creating Indexes.

Maintaining Indexes.

Querying the sysindexes Table.

Setting Up Indexes Using the Index Tuning Wizard.

Creating and Maintaining Indexes.

Viewing Index Statistics.

Describe how the query optimizer creates, stores, maintains, and uses statistics to optimize queries.

Advantages of Views.

Modifying Data Through Views.

Optimizing Performance by Using Views.

Creating, Executing, Modifying, and Dropping Stored Procedures.

Executing Extended Stored Procedures.

Defining Triggers.

Evaluate the performance considerations that affect using triggers.

Setting Up a Linked Server Environment.

Set up a linked server environment to access data that is stored in a remote SQL Server 2005 or in an OLE DB data source.

Indexing Strategies.

Identify locking concurrency issues.

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