St. Charles Community College
CPT 240 SQL Basics
Mrs. Heckel
Tech 105 A
sheckel@stchas.edu
636.922.8568
www.stchas.edu/faculty/sheckel

General Course Information

CATALOG DESCRIPTION:   Extensive hands-on activities using in-class SQL-based relational database to transform request into SQL query. How to create and test increasingly complex queries, how to build tables using data definition capabilities of SQL, how to create views for querying and manipulating data, and how to index in SQL database. (formerly CPB 240)

Credit Hours:      3

 

TEXT (required): Randaolph and Griffin
  SQL Essentials
  Franklin, Beedle & Associates, Wilsonville, OR, 2005

Time of Class:         Sec. 40 Spring 2005 Tuesday 7:00-9:50 pm

Course Objectives:

---Create and run SQL commands to create, update and query tables
---Identify the database administration features of SQL
---Utilize integrity constraints to control data entry
---Create basic and complex reports based on data in a table or view
---Embed SQL into other programming languages

What the teacher expects from each student

Attendance Policy

Each student is expected to attend all classes.  The fact that some of the course is group activity makes attendance at class even more important.  If absence is unavoidable, the student is expected to have the textbook material read and any class assignments completed before returning to the next schedule class.  Failure to do this will cause the inability to keep up with the class material being discussed.
DO NOT call or e-mail the teacher to find out what we covered in a class that you missed.  This information should be obtained from the course timetable and/or a classmate.

Course Requirements

Students with special needs:

We all have various channels through which we learn best. SCC has an Office of Accessibility Services that guides, counsels, and assists students with disabilities. It is located in Room 1206 of the Administration Building. It is your responsibility (as the student) to discuss with the instructor during the first week of class anything needed to help you succeed. If you have special needs, please call Pam Bova (636.922.8247) in the Office of Accessibility Services so that your eligibility for services can be determined.

What the student can expect from the teacher

Office Hours:    

Monday 8:00-10:00 am
 Tuesday/Thursday 10:00-11:30 am & 4:00-5:30 pm
Also available by appointment

 

Returning assignments/tests to the student

Every effort will be made for all assignments to be returned to all students within one week of the test date or assignment’s due date.  

Grading Scale:
A
 93-100 Chapter Review Questions
20%
B
 85-92
 Chapter Exams*
 30%
C
 75-84
 Hands-on Assignments*
 30%
D
 65-74
 Articles/Summaries
 10%
F
 below 65%
 Final Exam
 10%

                                     *the lowest grade will not be calculated

 

All written work

Chapter Questions / Group Assignments / Article Summaries

All written work for this class must be done using proper grammar and punctuation.  Writing skills are crucial to your future success, and these types of assignments are one way to practice those skills.  Regardless of your personal knowledge of any subject, if you cannot write about it using good writing skills, then no one else can know how much you know about it.

Up to 15% of your assignment grade could be lost if proper writing skills are not demonstrated. If you need writing skills helps, SCC provides an excellent resource for you.  Contact the ACE Center or me if you require assistance in this area.

Chapter Questions:

Write out complete answers to each review question in the text.  Be sure your answer includes enough of the question posed so that I don't have to look at the question in the book to know which one you're answering. This homework is due the week we take the test on the chapter

Article Summaries

Find four (4) articles about Database trends and/or SQL. Write a 1/2-1 page summary of each article (double spaced).


 Chapter Exams:

 The beginning of many class sessions will be a test. The test is computerized, true/false, multiple choice, and short answer. For each test, you can use your homework (the Chapter Review questions) as a "cheat sheet." Tests cannot be made up, but missing one will not affect your grade, because the lowest grade is thrown out.

Hands-on Assignments:

 Hands-on assignments will be assigned most classes. These cannot be made up, but missing one will not affect your grade, because the lowest grade is thrown out.

Final Exam

Your final exam will be hands-on, to add/change/delete records/tables from a database. This will be an open-notes test.

Withdrawal dates and related policies

 
Last day to change from credit to audit or audit to credit Feb 11
Last day to apply for Aug 2005 Graduation Jun 3
Last day to drop and receive a "W" Apr 1

Tentative Time Table--rev 3/15/05

Tues
Chapter
 Topic
Test
18-Jan
Introduction to the Course
25-Jan
1
 Introduction to Relational Databases and SQL
1-Feb
2
 Basic Single-Table Select Statements
ch.1
8-Feb
3
 Aggregate Calculations and Subqueries
ch.2
15-Feb
4
 Joining Tables
22-Feb
4
 Joining Tables
1-Mar
5
 Database-Specific Statements and Functions
8-Mar
6
 Advanced Queries
ch.3&4
15-Mar
   Query Review
22-Mar
No Classes--Spring Break
29-Mar
7
 Data Manipulation
ch.6
5-Apr
8
 Data Definition Language
12-Apr
8
 Data Definition Language
ch.7
19-Apr
9
 Database Security
ch.8
26-Apr
9
 Database Security
3-May
Special Topics
ch.9
10-May
Final Exams