This lesson is designed to develop students’ understanding of relational databases

and structured query language.

Identify the main components of a relational database.

Identify and demonstrate the proper use of basic SQL statements.

Identify and demonstrate the proper use of wildcards and SQL operators.

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 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://databases.about.com/

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/

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.

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.Identify the main components of a relational database.

Identify and demonstrate the proper use of basic SQL statements.

Identify and demonstrate the proper use of wildcards and SQL operators.

Identify and demonstrate the proper use of the SQL Clauses.

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

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.