|
|
| A SPECIAL INVITATION FOR TEACHERS... |
 |
 |
LessonPlansPage.com would like to take a moment to let you
know about Concordia University's new Master’s Degrees in Education that you can complete online in just one year!
Available Master's Degrees in Education include:
- Curriculum & Instruction: Reading
- Curriculum & Instruction: Methods & Curriculum
- Curriculum & Instruction: English to Speakers
of Other Languages
- Educational Leadership
These programs can help you:
- Open the door to a variety of school leadership career opportunities like higher education teaching, department chair, ELL consultant, literacy coach, or curriculum coordinator
- Complete your degree in one year, on your schedule,
from the comfort of your home
- A Master's Degree could mean an automatic salary increase in your school district!
A national university system with 10 campuses throughout the United States, Concordia was founded more than 100 years ago and is accredited by the Northwest Commission on Colleges and Universities.
 Printable Version for your convenience!
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.
http://www.cs.sfu.ca/CC/354/zaiane/material/notes/Chapter3/node2.html
http://www.csuohio.edu/accounts/ACT688/Data4/
http://databases.about.com/compute/databases/gi/dynamic/offsite.htm?site=http%3A0.0000000.000000www.aisintl.com0.000000case0.000000relational_keys.html
http://www.citilink.com/~jgarrick/vbasic/database/rdbms.html
http://www.islandnet.com/~tmc/html/articles/orareln.htm
Lesson Activity #3:
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.
http://www.sqlcourse.com/
Activity #4:
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.
http://clubs.yahoo.com/clubs/structuredquerylanguage
E-Mail Sherry L. Guyer!
|
|
|
Math
Language Arts
Science
Social Studies
Art
Computers & Internet
Music
P.E. & Health
Other
Multi-Disciplinary
