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"
Bookmark Collections for material titled "SQL Interpreter and Tutorial"
Course ePortfolios 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"
Please enter a Bookmark title
Please limit Bookmark title to 65 characters
Please enter a description
Please limit Bookmark title to 4000 characters
A Bookmark with this title already existed.
Please limit a note about this material to 2048 characters
Search all MERLOT
Select to go to your profile
Select to go to your workspace
Select to go to your Dashboard Report
Select to go to your Content Builder
Select 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: May 13, 2015
Author:
Send email to comments@sqlcourse.com
Submitter: Ralph Westfall

Quality


  • Rate this material
  • Create a learning exercise
  • Add accessibility information
  • Pick a Bookmark Collection or Course ePortfolio to put this material in or scroll to the bottom to create a new Bookmark Collection
    Name the Bookmark Collection to represent the materials you will add
    Describe the Bookmark Collection so other MERLOT users will know what it contains and if it has value for their work or teaching. Other users can copy your Bookmark Collection to their own profile and modify it to save time
    Edit the information about the material in this {0}
    Submitting Bookmarks...

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

Users who viewed this material also viewed...

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
15 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.