SQL Interpreter and Tutorial
Peer Review for material titled "SQL Interpreter and Tutorial"
User Rating for material titled "SQL Interpreter and Tutorial"
Member Comments for material titled "SQL Interpreter and Tutorial"
Personal Collections for material titled "SQL Interpreter and Tutorial"
Learning Exercises for material titled "SQL Interpreter and Tutorial"
Accessibility Info for material titled "SQL Interpreter and Tutorial"
Search all MERLOT
Click here to go to your profile
Select to go to your workspace
Click here to go to your Dashboard Report
Click here to go to your Content Builder
Click here to log out
Search Terms
Enter username
Enter password
Please give at least one keyword of at least three characters for the search to work with. The more keywords you give, the better the search will work for you.
select OK to launch help window
cancel help

MERLOT II




        

Search > Material Results >

SQL Interpreter and Tutorial

        

SQL Interpreter and Tutorial

Logo for SQL Interpreter and Tutorial
Tutorial that provides introductory information on features of Structured Query Language (SQL), and an online database with which to practice using these features
Material Type: Tutorial
Technical Format: HTML/Text
Date Added to MERLOT: July 14, 2000
Date Modified in MERLOT: November 07, 2007
Author:
Send email to comments@sqlcourse.com
Submitter: Ralph Westfall

Quality


About

Primary Audience: College General Ed
Mobile Compatibility: Not specified at this time
Technical Requirements: web browser
Language: English
Cost Involved: yes
Source Code Available: no
Accessiblity Information Available: no
Creative Commons: unsure

Connections





QR Code for this Page

Browse in Categories

Discussion

Discussion for SQL Interpreter and Tutorial

Log in to participate in the discussions or Register if you are not already a MERLOT member.

Return to Top of Page
Avatar for Ralph Westfall
14 years ago

Ralph Westfall (Faculty)

This website explains individual SQL commands, and also provides an online SQL interpreter so that users can practice these commands. If the student enters a valid SQL query, the database generates output. If the query is faulty, the interpreter returns an error message.

Students can use data in the permanent tables in the database, and/or can create temporary tables which will remain on the site for a few days.

The tutorial is divided into eight lessons. The site also provides Exercises with some of the lessons, and solutions to the exercises. (The solutions are all together for each lesson, so it is possible for students to see the solution for some of the later exercises when checking their answer for an earlier one.)
This tutorial is followed by another one that covers more advanced features of SQL.

Technical Remarks:

Some of the material quite condensed, so this site is not a substitute for a textbook. For example, the tutorial mentions and discusses constraints on input values, but doesn't provide an code example (although this is available in the second tutorial). Even though it mentions the char and varchar data types, it doesn't really explain the distinction between them. The concept of updating by adding a constant to a value is demonstrated, and assigned as an exercise, without any discussion.