Advanced Databases

View Resource

Read the Fine Print

Subject:

Science and Technology

Institution Name:

The Saylor Foundation

Collection:

Saylor Foundation

Grade Level:

Post-secondary

Abstract:

This course will expand upon SQL as well as other advanced topics, including query optimization, concurrency, data warehouses, object-oriented extensions, and XML. Additional topics covered in this course will help you become more proficient in writing queries and will expand your knowledge base so that you have a better understanding of the field. Upon successful completion of this course, the student will be able to: write complex queries, including full outer joins, self-joins, sub queries, and set theoretic queries; write stored procedures and triggers; apply the principles of query optimization to a database schema; explain the various types of locking mechanisms utilized within database management systems; explain the different types of database failures as well as the methods used to recover from these failures; design queries against a distributed database management system; perform queries against database designed with object-relational extensions; develop and query XML files. (Computer Science 410)

Languages:

English

Material Type:

Assessments, Audio Lectures, Full Course, Lecture Notes, Readings, Syllabi, Video Lectures

Media Format:

Audio, Graphics/Photos, Text/HTML, Downloadable docs, Video

Conditions of Use:

Creative Commons Attribution-Noncommercial 3.0
You are welcome to share, remix, and adapt this course under the terms of the Creative Commons Attribution 3.0 Unported License; however, many linked materials within this course are copyright of their respective authors/owners and may not be openly-licensed. Please respect the copyright and terms of use associated with each resource.

Copyright Holder:

The Saylor Foundation