Saddleback College - Syllabus
CIMW 105 WEB DATABASE:
INTRO SQL AND MYSQL
Fall 2nd 8 Weeks 10/14/2020 - 12/16/2020
|Instructor:||Professor T. DeDonno||Semester||Fall 2020|
|Office Hours||E-Mail: email||Ticket #||#19530|
|Class Site :||https://cim.saddleback.edu/cimw105||Room #||Optional Help in Library LRC - Canvas - Help|
|Central Web-Site||https://cim.saddleback.edu||Time & Day||
Orientation Webcast 10/20
Full set of videos, webcasts, and orientation details on Canvas
Upon completion of this course, the student will be able to:
- Summarize the fundamentals of good relational database design.
- Create databases.
- Code complex SQL queries on a database.
- Use SQL to create reports.
- Explain database administration issues
- Create/Query: Students who complete this course will be able to create, manipulate, and query databases.
- Implement SQL fundamentals consisting of single table queries, sorting and updating data.
- Analyze Database: Students who complete the course will be able to analyze database indexes, triggers and constraints.
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 - engage $23.49 e-book | Valore Books $17 or Amazon $18 prices subject to change, used are not that expensive. Don't spend more that $25 for the book. 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 Canvas has a full set of state of the art videos, covering phpMyAdmin and all new features for MySQL.
Minimum Canvas Quiz Points*
|Minimum Total Points***|
|A||257 Points||189 Points||Up to and including Chapter 6 at 90%. Chapter 4-6 assignment list: p125.sql (21points), p157.sql (20), p177.sql (15), (188/209=90%)|
|B||202||134||Up to and including Chapter 3, Average. Chapter 1..3 assignments: p21.sql (10), p58.sql (7) and p87.sql (10). All chapter quizzes are 20 points; Chapter 1 has two 20 point quizzes.|
In order to obtain C level points you need to complete with 92% average or better both pre-book assignments/quizzes, and chapter 1 assignment 1 quiz and p21.sql. The pre-book assignments cover the entire SQL language. For additional, points you can always complete another quiz or assignment.
|* To view your quiz grades, click the Canvas left quiz grades tab.|
**Assignments grades and due dates(except phpMyAdmin report) are displayed on submit. Last day of class is last day of class. You may not submit anything 9 hours after the last day of class. However, you may submit prior last day assignments, 7 days late at 25% penalty, after 7 days penalty is 50%.
***Total Points, you should try to hit the minimum points for both assignments and quizzes. However, in cases where a students exceeds one but misses the other one, total points achieved will be considered. For example, if you end up with 250 quiz points and 195 assignments points, you will most likely still end up with an A. Nota Bene, including bonus (10pts) and PMA report (15points) you have 215 possible assignment points.
- Students who have not completed at least 1 assignments two days before the drop without W grade.
- By the last date to add with APC code, you must login to canvas, complete the orientation quiz and any corresponding assignment.
- Students who have been emailed a drop warning and don't attempt the stated work.
- Students who have not completed at least 50% of the work by two days before the drop with W grade.
- When in-class sessions are present, students who miss 2 or more class sessions
Consult current schedule for exact dates.
- There was a clerical error (i.e., the points were added up wrong).
- 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. 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.
This is an on on-line - distance educational course.
The weekly Canvas announcement will concisely summarize what you need to complete each week. The assignment page provides a detailed course guide. Work on all assignments one at a time, in the order they are listed. At the start of the course both an assignment page link and the weekly welcome announcement will be sent to your Saddleback e-mail address. For a due date summary of the entire course consult the schedule.
Regular effective contact between the Professor and student is required for success. This class we will have weekly videos, web-casts and frequent emails (several per week), will post threaded discussion on important e-mails. In the past students seem to prefer the email communication over discussion board. The assignment page is very detailed on purpose it specifically address many of the questions raised in the past. When required actual phone calls will be made. Note both the IMC lab bgs248 and instructor offer in-person help. In addition to in-person help we have 24/7 access to web-casting software. With web-casting software instructor/student can share screen and provides VOIP (Voice over IP - Internet) interactive connections.
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.