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 205)

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

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

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. We will have 9 required assignments, chapter 1-6 will each have a corresponding premiere database assignment, and three intro assignments. End of chapter assignments and quizzes for chapters 7 and 8 will be extra credit. 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 CIM205A in the subject line. Course Grading will be calculated from...

92-100	A		8 Quizzes (Class Intro + MySQL Intro + chapter 1-6)	50%
84-91.9	B		10 Assignments Chapters 1-6 + questionnaire + tutorial + fruitcmds + phpMyAdmin Adv + select Extra Credit: Chapter 7 & 8, May also add extra credit fo: tripsmart, blooms, Henry's books and/or Alexamara Marina Group	50%
65-83.9	C
55-64.9	D
0-54.9	F
For C Grade, you need to complete, the first 4 assignments and first 2 quizzes - with an average grade above 90%. For B Grade, you need to complete all assignments and quizzes up to and including chapter 4, with an average grade above 90%. For A grade, you need to complete all ten assignments (i.e.,B grae plus chapters 5 & 6) and eight quizzes, with an average grade above 92%.

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 9/23/2009. (Two Days Before Drop without W Date)
2. Students who have not completed at least first three assignments and two quizzes  by two days before the drop with W grade 11/3/2009..

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 permanen

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.

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

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.