SADDLEBACK COLLEGE

                                                          BUSINESS SCIENCE DIVISION

                                                                  COURSE SYLLABUS

                                                     CIM 205 Introduction to SQL/MySQL

1/9/06-5/18/06

Instructor:          Tom Dedonno                                                             Semester:           Spring 2006

E-mail:                tdedonno@juno.com                                                    Ticket No:         21140

Web-site:   http://saddleback.edu/faculty/tdedonno    Office Hours             Time & Day:     Internet

Class Web-site: http://saddleback.edu/faculty/tdedonno/sql                        Room:              

 

COURSE DESCRIPTION:

Course in using Structured Query Language (SQL), using Oracle, to create, manipulate, and query databases. Covers the fundamentals of database design with a relational database, entity-relationship diagrams, normalization guidelines, concurrency issues. Includes creating databases and tables using SQL, the basics of table indexing, and how to do simple and complex table queries using SQL. Triggers and stored procedures will also be covered. May be offered by mediated mode of instruction.

COURSE OBJECTIVES:

Upon completion of this course, the student will be able to:

 

1. Summarize the fundamentals of good relational database design.
2. Optimize database performance.
3. Create databases.
4. Code complex SQL queries on a database.
5. Use SQL to create reports.
6. Explain database administration issues.
7. Code and test Oracle triggers and stored procedures.

STUDENT RESOURCES:

Philip J. Pratt  ISBN: 0-619-21674-3 © 2005
Publish date: November 22, 2004 294 page

 

Course Grading:

 

Course grades is taken equally from assignments and blackboard quizzes. On all graded material, you may repeat the work until you are happy with your grade. Each chapter (1-7) will have a blackboard quiz worth 20 points, each quiz will have 1 bonus point and you may repeat the quiz till you are happy with the grade. We will have 10 homework assignments, All students are required to have their  Saddleback E-mail forwarded to an account that they frequently use,  preferably forward blackboard/saddleback  e-mail’s to your main e-mail. When sending me e-mails, make sure you include SQL  in the subject line.

 

The course grade will be calculated from:

Percentage

Grade

Grade Evaluation

 

92-100

A

50%

7 Quizzes

84-91.9

B

50%

10 Assignments

65-83.9

C

 

 

55-64.9

D

 

 

0-54.9

F

 

 

 

Drop with  Refund

1/20/06

 

Drop without W

2/14/06

Last Day to  Elect CR/NC

2/14/06

 

Drop with W

4/5/06

 DROPPING THE CLASS/ATTENDANCE:

 

It is the student's responsibility to officially withdraw (drop) from the class. Note individual assignments, tests and quizzes are all by due 5/16/05 at 11:59PM. However, the Instructor may drop students under the following conditions:

1.     Students who have not completed at least 2 assignments and 2 quizzes by 2/12/06 11:59PM, two days before the drop without W grade.

2.     Students who have not completed at least 50% of the work (i.e., 50% of the tests/Quizzes and Assignment) by (@ 4/3/06 11:59PM, two days before the drop with W grade.

 


REGRADING POLICY:

Sometimes you get a grade that you don't like, usually for one of the following reasons:

 

1.  There was a clerical error (i.e., the points were added up wrong).

2.  You think you did something right, and I think you did it wrong.

 

If you discover a clerical error, tell me immediately. The following Statute of Limitations will apply: You have one week from the day any graded assignment or test is returned to you to appeal the grade you received. After one week, I will assume that you believe the grade you got is the correct one. After one week, grades are unchangeable, fixed, and permanent.

 

Students with disabilities are entitled to appropriate accommodations.  If you have specific disabilities requiring accommodations, let your instructor know the first 10 days of the semester so that your learning needs may be met and for referral to the Special Services office where documentation of your disability will be provided to receive services and accommodations.  The Special Services Office is in Student Services Center, Room 113.

 

Any exceptions to the above statements will be considered individually & only if you approach me about the proposed exception at least a week in advance.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 Tentative Syllabus Schedule
Class Web-site Schedule is Updated during Semester

   

Tentative SCHEDULE - University Calendar
Last Updated Tuesday, December 28, 2005 15:54:34

Task

Description

0

Lunch Time On-Line Introduction to MySQL (3 1.5 Hour Lectures)
On line lectures will make reading the book a lot easier.
Includes advice on logging on to the System and submitting homework.

1

Chapter 1: Introduction to Premiere Products, Henry Books, and Alexamara Marina Group

2

Chapter 2: An Introduction to SQL

3

Chapter 3: Single-Table Queries

4

Chapter 4: Multiple-Table Queries

5

Chapter 5: Updating Data

6

Chapter 6: Database Administration

7

Chapter 7: Reports

8

No Quiz for Chapter 8; You have a MySQL worksheet instead of Chapter 8: Embedded SQL