Index

Assignments

Syllabus

Schedule

Details 1st 8

Details 2nd 8

Office Hours

Saddleback College - Business Science Division

Course Syllabus

CIMW 105 WEB DATABASE: 

INTRO SQL AND MYSQL

1/21/2014 - 3/23/2014 and

3/31/2014 - 5/22/2014

Instructor: Professor T. DeDonno   Semester Fall 2013
Office Hours E-Mail: tdedonno@juno.com Ticket # #21100 and #21105
Class Site : http://cim.saddleback.edu/cimw105 Room # Optional BGS248 - Blackboard - Help
Central Web-Site http://cim.saddleback.edu Time & Day Online Class
Course Description
Covers server-side web development using Structured Query Language (SQL) and MySQL, to create, manipulate, and query databases. Covers the fundamentals of a relational database, single table queries, multiple table queries, updating data, MySQL database administration, querying data, joins, and indexes. (Formerly CIM 205A)
Course Objectives

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

  1. Summarize the fundamentals of good relational database design.
  2. Create databases.
  3. Code complex SQL queries on a database.
  4. Use SQL to create reports.
  5. Explain database administration issues
Required Textbook

A Guide to MySQL, by Philip J. Pratt, Mary Z. Last ISBN: 1-4188-3635-4 © 2006 ISBN-13: 978-1-4188-3635-1 Publish date: December 9, 2005 - Valore Books - Nota bene, Since author has never updated this specific version of the book it is a little old. However, a key reason for SQL's significant market penetration is they all adhere to a 1992 standard. In addition blackboard has a full set of state of the art videos, covering PHPMyAdmin and all new features for MySQL.

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-6) 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. Academic Integrity is critical to passing this course. Failure to abide by academic integrity can result in a failing grade. For information on academic integrity consult UCSD Professor Elkan's detailed description. and CIM site policy. All students are required to have their Saddleback E-mail forwarded to an account that they frequently use. When sending me e-mails, make sure you include MySQL or CIMW 105 in the subject line. Course Grading will be calculated from...
Grade

Minimum Blackboard
Quiz Points*

Minimum Assignment
Points**
 
A 138 Points/150 Possible 176 Up to and including Chapter 6 at 92%. Chapter 4-6 assignment list: p125.sql (21points), p157.sql (20), p177.sql (15), (176/191=92%)
B 82 Points
/90Possible
121 Up to and including Chapter 3, at 92% Average. Chapter 1..3 assignments: p21.sql (10), p58.sql (7) and p87.sql (10). (81+27 additional homework points =108)
C 18/20Possible 82 You can obtain a C grade by completing pre-book assignments and quizzes. The pre-book assignments cover the entire SQL language.
D 15

45

* On blackboard click the left tab quiz grades, to view your quiz grades, each quiz has bonus points.
F 10 10 **Assignments grades (except phpMyAdmin report) are displayed on each submit

Dropping Class
It is the student's responsibility to officially withdraw (drop) from the class. However, the Instructor may drop students under the following conditions:
  1. Students who have not completed at least questionnaire and intro quiz by two days before the drop without W Date (Click the Class Details)
  2. Students who have not completed at least first three assignments and two quizzes  by 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

Special Needs

Students with disabilities are entitled to appropriate accommodations.  This course meets the requirements set forth in the accessibility checklist and universal design grid provided by Special Services. The Web pages, video presentations, textbooks and class materials used in this course are accessible to students with disabilities. 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..

Student Services - General student service information is available at the Saddleback College Website. General, academic and service information can be obtained by accessing the Counseling Division and Financial Web sites. Individual and small group counseling information such as academic planning and review of transcripts is available by appointment. All other student services are available on campus during normal business hours.

Distance Education Requirements

This is an on on-line - distance educational course.

The first blackboard announcement will concisely summarize the three key steps in completing the class. The assignment page provides a detailed course guide. At the start of the course both the assignment page and three step summary will be e-mail to your Saddleback e-mail address. Complete all assignments in the order they are listed.

The first blackboard announcement will concisely summarize the three key steps in completing the class. The assignment page provides a detailed course guide. At the start of the course the three step summary will be sent to your Saddleback e-mail address. Complete all assignments in the order they are listed.

Regular effective contact between the Professor and student is required for success. This class we will have weekly videos, web-casts, threaded blackboard discussion boards, and frequent emails (several per week). When required actual phone calls will be made. Note instructor does have office hours and blackboard provides 24/7 access to illuminate web-casting software.

For additional help: blackboard, login and/or general. - Tentative Schedule

For specific additional help: blackboard, login and/or general.

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 Class Schedule