SW 505 - Advanced Database Concepts

Institution:

Eastern Connecticut State University

Subject:

Description:

This course covers topics in database implementation designed to provide software engineers with a wide variety of server-side problem solving techniques.Topics include cursors, query and index optimization, implementations of common data structures and algorithms in SQL, distributed databases, object-oriented databases, XML metadata, and direct Web publishing.While Oracle and Microsoft SQL Server are both used for demonstration, the topics covered are applicable to any database platform.Format consists of lecture and lab.The syllabus of this advanced course assumes the student is well versed in relational databases, SQL, client-server or multi-tiered applications, data structures, and algorithms.Topic List: Advanced Query Performance (indexing techniques, use of statistics, use of optimizer hints) Using Temporary Tables, Use of Server Side Cursors Subset Queries (TOP n, every nth item) Table-valued functions Representing Data Structures in a Relational Database (arrays, graphs, trees) Publishing data to HTML Publishing data to XML, using XPath/XDR Using ERWin Distribution, Publisher/Subscriber Replication, Snapshot and Merge Replication. Database Trust Relationships and Cross-Server Queries Online Analytical Processing (OLAP) Object-oriented databases (Prerequisites: SW 402 plus SW 403 or SW 408, or instructor approval) Three credits.

Credits:

3.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.easternct.edu/

Phone Number:

(860) 465-5000

Regional Accreditation:

New England Association of Schools and Colleges

Calendar System:

Semester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.