No offerings have been identified for this subject in 2017
ITI595 Developing Database Programming Solutions Using SQL Server (8)
AbstractThis is an industry based subject based on Microsoft Certified Database Administrator (MCDBA). This subject is designed for experienced database developers and database administrators, who are responsible for designing, building, querying, and developing enterprise SQL Server 2005 databases and servers. |
|
|
+ Subject Availability Modes and Location
Continuing students should consult the SAL for current offering details prior to contacting their course coordinator: ITI595
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 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
Master of Management (IT) - MMgtInfoTech
Graduate Certificate in Management (IT) - GradCertMgtInfoTech |
|
|
Learning OutcomesUpon successful completion of this subject, students should:
- be able to use the Development Tools provided with SQL Server 2005; - be able to use Transact-SQL enhancements to perform database development tasks; - be able to develop XML-based Solutions using SQL Server 2005; - be able to build Message-Based Services with the Service Broker; - be able to implement Web Services using Native HTTP Endpoints; - be able to build Notification Services Applications; - be able to implement Database Functionality with Managed (.NET) Code; - be able to build Client Applications with the .NET Framework; - be able to build Administrative Applications with SQL Management Objects (SMO). |
|
|
SyllabusThe subject will cover the following topics: SQL Server 2005 Components and Architecture.
SQL Server Developer Tools.
Developing Client Applications with ADO.NET.
Data Binding in the .NET Framework 2.0
SQL Server 2005 Security Implementation.
Using SQL Server Management Studio.
Using Schemas.
Data Definition Language Enhancements.
Structured Exception Handling.
XML Enhancements in SQL Server 2005.
Service Broker Architecture.
Native HTTP Support in SQL Server 2005.
Configuring Native HTTP Support.
Notification Services Architecture.
Building Notification Services Solutions.
SQL Server and the .NET CLR.
Implementing Managed Code in SQL Server 2005.
Replication Management Objects.
Use RMO to manage replication. |
|
|
Back
The information contained in the 2017 CSU Handbook was accurate at the date of publication: 25 August 2017. The University reserves the right to vary the information at any time without notice.