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:
This online course suits the needs of individuals who want to learn at their own pace.
The course is organized according to 8 units and include a final exam
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.
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)
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
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
great reading content but minimal to no application exercises and assignments
Ease of Use for Both Students and Faculty
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
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.
Search by ISBN?
It looks like you have entered an ISBN number. Would you like to search using what you have
entered as an ISBN number?
Searching for Members?
You entered an email address. Would you like to search for members? Click Yes to continue. If no, materials will be displayed first. You can refine your search with the options on the left of the results page.