Course: (Introduction to Relational) Databases"/>
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 > Learning Exercise Results > Study SQL Tutorial and Practice Writing SQL Code

Learning Exercise: Study SQL Tutorial and Practice Writing SQL Code

Title:
Study SQL Tutorial and Practice Writing SQL Code
Material:
Description:
Students read the tutorial and then test their understanding by typing SQL code for the exercises. When they submit their query the code runs and produces output, or an error message if there is a problem with the code.
Course: (Introduction to Relational) Databases

Info

Submitted by:
Ralph Westfall
Date Last Modified:
July 14, 2000

Exercise


  1. Go to the SQL Interpreter and Tutorial website.
  2. Skim the material on this page
  3. Click on the 1-What is SQL? link on the right side of the screen and skim the material on the page that comes up
  4. Click on the 2-Table Basics link and skim the material on this page
  5. Click on the 3-Selecting Data link and read the material on this page
  6. Write your answer for the first item in the Select Statement Exercises in the input area under the SQL Interpreter heading, and click the Submit Query button
  7. (You may find it useful to copy each of your answers into a word processor file, so that you can check them against the answers after you complete the Exercises)
  8. If you receive an error message, click the Back button on your browser, modify the code and submit it again
  9. Repeat the previous steps (6 - 8) for Exercises 2 through 6
  10. After you have tried all the exercises, you can check your answers by clicking on the Answers to These Exercises link
  11. Repeat these steps for the links for 4-Creating Tables through 8-Drop a Table on the right side of the screen

Categories

Audience

  • College Lower Div Major

Topics

1-Fundamentals of relational databases,
2-SQL Programming

Requirements

Web browsing skills

Learning Objectives

Student will be able to write SQL statements to select data from a table, create a table, insert data, update records, delete records, and delete a table.

Type of Task

  • Core activity
  • Individual
  • Student-centered
  • Supplemental activity
  • Unsupervised

Technical Notes

Computer with Internet connection and web browser