Title - Understanding Structured Query Language (SQL)
By - Sherry L. Guyer
Primary Subject - Computers / Internet
Secondary Subjects -
Grade Level - 12+
Subject Area: Structured Query Language
Lesson Purpose: This lesson is designed to develop students' understanding of relational databases and structured query language.
Lesson Objectives:
1. Identify the main components of a relational database.
2. Identify and demonstrate the proper use of basic SQL statements.
3. Identify and demonstrate the proper use of wildcards and SQL operators.
4. Identify and demonstrate the proper use of the SQL Clauses.
Lesson Activity #1 (Introduction):
Have a volunteer demonstrate problem that requires the use of SQL to correct. Introduce the objectives of the course and the expectations of each student. Have each student download "Introduction to Structured Query Language" guide from the following website. This guide will serve as the reference guide for the course. http://www.highcroft.com/highcroft/sql_intro.pdf
Lesson Activity #2:
Have students break into groups of 3. Instruct each group to utilize the web sites listed below to develop a 15-minute presentation related to the main components of a relational database. Have each group present their finding to the other groups.
Have each student complete Tasks 1-9 of the SQL Interpreter and Tutorial from the website listed below. Discuss what the students learned about the basic SQL statements. Explain/Demonstrate how the SQL statements learned on the tutorial are applied to the your organizations database.
Have each student complete Task 10 of the SQL Interpreter and Tutorial. Discuss what the students learned about using additional clauses, aggregate functions and wildcards. Explain/Demonstrate how the SQL statements learned on the tutorial are applied to your organizations database.
Lesson Activity #6 (wrap-up):
Review the objectives covered. Have each student complete an exam testing their knowledge of the basic SQL statements, clauses, etc. Have each student subscribe to the SQL discussion group listed below, which they can utilize on the job when they have SQL related questions and to further their understanding of SQL. This activity also contains elements of the INFORM strategy.
Math
Language Arts
Science
Social Studies
Art
Computers & Internet
Music
P.E. & Health
Other
Multi-Disciplinary
Printable Version
