Tutorial that provides introductory information on features of Structured Query Language (SQL), and an online database with which to practice using these features
Type of Material:
Tutorial
Recommended Uses:
It can be as some additional exercises for studies in classes or tutorials in the first few lessons on database operation.
Technical Requirements:
Web browser
Identify Major Learning Goals:
Upon the completion of the tutorial, learners should be able to:
describe the use of SQL
apply SQL to manipulate a relational database
Target Student Population:
College General Ed
Prerequisite Knowledge or Skills:
Basic computing and programming knowledge
Content Quality
Rating:
Strengths:
The flow is easy to follow.
The examples introduced is simple and directly addressing the learning topics.
The immediate response of the SQL in exercises also help the users to see the sql results.
It is most appropriate for the introduction on the SQL or the first few lessons on the database, not for the advanced usage.
in summary, the content of the tutoiral is accurate and complete. It contains the basic knowledge about SQL. Learners should be able to learn how to write and interpret SQL.
Potential Effectiveness as a Teaching Tool
Rating:
Strengths:
While the objectives are not explicitly stated, the concept to be learned in each page is clear to the learners.
This SQL tutorial provides some useful and simple SQL instructions to the learned the basic concepts of SQL statements.
It also gives examples to viewers to practice with what is learned using the on-line SQL interpreter and the immediate results are feedback.
In summary, the learning goals of the tutorial are very clear and easy to identify. It includes the explanation of different SQL statements and help learners to re-inforce their concept in working with relational database. There are some exercises which provide ways for students to attempt to apply the knowledge and assess their learning.
Ease of Use for Both Students and Faculty
Rating:
Strengths:
It uses one simple example throughout the course, so that viewers do not need to learn the background of each case when learning a new concept.
Users can try the exercise and get the feedback immediately. For better understanding, it would better the expected SQL results can also be given for some challenging questions.
In summary, the tutorial itself is easy to follow. The site is clear and consistent. Examples with tables are provided for helping learnings to realize the concepts. The exercise at the end of each unit allows learners to have self-assessment.
Concerns:
There is a bit delay when loading the page, probably due to the advertisements in the Website. This reduces the usability of the tutorial. It may need some update as the "Database Links" are not reachable.
Creative Commons:
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.
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.