Peer Review

Advanced Databases

Material Detail page

Reviewed:: Nov 22, 2016 by Information Technology

Bookmark

Ratings

Overall Rating:

Content Quality:

Effectiveness:

Ease of Use:

Overview:: This is an advanced class in Databases. It will present SQL as well as other advanced topics, including query optimization, concurrency, data warehouses, object-oriented extensions, and XML.
Type of Material:: Online Course
Recommended Uses:: This online course suits the needs of individuals who want to learn at their own pace. 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. The course is organized according to 8 units and include a final exam
Technical Requirements:: Audio, Text/HTML, Video, any browser would work
Identify Major Learning Goals:: Upon successful completion of this course, the learner will be able to: 1) write complex queries, including full outer joins, self-joins, sub queries, and set theoretic queries; 2) write stored procedures and triggers; 3) apply the principles of query optimization to a database schema; 4) explain the various types of locking mechanisms utilized within database management systems; 5) explain the different types of database failures as well as the methods used to recover from these failures; 6) design queries against a distributed database management system; 7) perform queries against database designed with object-relational extensions; 8) develop and query XML files.
Target Student Population:: this is a full course Community College / Lower Division
Prerequisite Knowledge or Skills:: This course requires a thorough knowledge of the core concepts behind database management systems.

Content Quality

Rating:
Strengths:: 1)This course provides a complete demonstration of the concept 2) It includes an adequate amount of material 3) It is self-contained (can be used without requiring an assignment or context)
Concerns:: The course is text-based. The integration of multimedia interactive objects like animations and video might make the course more attractive. There are no activities, exercises to apply the concepts, only a final exam

Potential Effectiveness as a Teaching Tool

Rating:
Strengths:: the course uses a variety of media formats: Audio, Downloadable docs, Graphics/Photos, Text/HTML, Video. You can also share, remix, and adapt this course under the terms of the Creative Commons Attribution 3.0 Unported Licences This online course: 1) identifies learning objectives 2) identifies prerequisite knowledge 3) reinforces concepts progressively 4) builds on prior concepts
Concerns:: great reading content but minimal to no application exercises and assignments

Ease of Use for Both Students and Faculty

Rating:
Strengths:: 1) It is easy to use 2) It has very clear instructions 3) It is of high design quality you have options to save the content in a variety of formats such as word and PDF
Concerns:: The course relies too much on text. It lacks of interactivity.

Other Issues and Comments:: Some resources are copyrighted, and may not be reproduced without the explicit permission from the copyright holder.
Creative Commons: