This module provides an introduction to relational databases, the most common type of database and what you are most likely to find available at your own IT department.
Type of Material:
Virtual Workshop
Recommended Uses:
This workshop can be used in class and recommended as a further learning resource
Technical Requirements:
Web browser
Limited Access: Guests
Guest visitors are welcome to view the Virtual Workshop materials, but will not be able to use certain features, including consulting support, page notes, page bookmarks, user notebook, quizzes, or exercises
Identify Major Learning Goals:
Understand basic database concepts
Design and implement relational databases
Use Relational Database Management System (RDBMS) software to manage a relational database
Learn Structured Query Language (SQL), the abstracted language used to access relational databases
Target Student Population:
College General Ed.
Disciplines include MIS, IS, IT and computer science
Prerequisite Knowledge or Skills:
Basic understanding of information systems
Content Quality
Rating:
Strengths:
it presents the concepts clearly with screen shots of the tables and SQL commands .
It also allows to look at code using an OR mapper that shows the creation, querying, and retrieval of data from a database without writing any SQL!
Concerns:
it is a short tutorial with one exercise and quiz, can be expanded.
Potential Effectiveness as a Teaching Tool
Rating:
Strengths:
Easy to learn in a short period of time
Supported by both exercises and quizzes
Links to external resources
Concerns:
Need to create an account to use all the features
Guest visitors can access the Virtual Workshop materials, but cannot use certain features, including consulting support, page notes, page bookmarks, user notebook, quizzes, or exercises.
Limited teaching materials and practical exercises
Ease of Use for Both Students and Faculty
Rating:
Strengths:
Easy to navigate
Consulting support, page notes, page bookmarks, user notebook, quizzes, and exercises.
Information is clear with clear screen shots and examples
Concerns:
Lack of interactivity
Need to log in to access all additional features.
Downtime for regular Web server maintenance will occur the Wednesday following the second Tuesday of every month. The outage will usually be less than 30 minutes. Different level of access: Full Access, Medium Access and Limited Access: Guests.
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.
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.