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)

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

1. Create/Query: Students who complete this course will be able to create, manipulate, and query databases.
2. Implement SQL fundamentals consisting of single table queries, sorting and updating data.
3. 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 - DirectBooks Lots of Options, don't spend more that $30 for book, Google Books use to have it free online | Valore Books rental $15/$17 or Amazon $18 prices subject to change; used versions are often not that expensive. But, don't spend more than $25 on the book. Nota bene, Since the 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 the new features for MySQL. For C grade, you don't need to buy the book, we have webcasts that cover most of chapter 1 of the textbook. In addition, all assignments in the book are built into the textbook viewgraphs.

or A Guide to SQL 7th Edition - chegg $11.99 Rental - Amazon -

• ASIN :0619216743. Publisher : Course Technology; 7th edition (November 22, 2004), Language :English, Paperback 312 pages, ISBN-10:9780619216740, ISBN-13:978-0619216740

Course grades is taken equally from assignments and Canvas quizzes. Course has a full set of pre-book Canvas videos, which not only touches on the entire SQL/PLSQL language, but makes the book easier to read. The text-book has 6 chapters with corresponding quizzes and assignments. Academic Integrity is critical to passing this course. Failure to abide by academic integrity can result in a failing grade. Generative AI, such as chatGP is a form of cheating, you are using another identity to complete your work. For information on academic integrity consult UCSD Professor Elkan's detailed description. AI and CIM site policy. Academic work, especially criticism and research, involve using the work of other writers, researchers, and artists. Students need to know they are allowed to use this material, so long as they supply attribution. In addition, if you use the work of any other writer, researcher, or artist, even an image from the Internet, you need to provide attribution and ensure you are modeling fair use. Refer to the Creative Commons page for further information. 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	Canvas Points	Submit Points
A	267	176
B	214	137
C	151	111
D	50	53

 

Final Grade is Points Based Not Percentage Based
Grade	Minimum Canvas Points* (possible 316)	Minimum Submit Points** (possible 207)	Minimum Total Points***
A/P Credit	267 Points	176 Points	Up to and including Chapter 6 at 90%. Chapter 4-6 assignment list: p125.sql (21points), p157.sql (20), p177.sql (15), (177/197=90%)
B/P Credit	214	137	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.
C/P Credit	151	111	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.
D/NP No-credit	50	53
F/NP No-credit	10	10
* To view your quiz grades, click the Canvas left quiz grades tab.
**Assignments grades and due dates are displayed on submit. Last day of class is last day of class. You may not submit anything after the last day of class. However, you may submit up to last day of class with the following penalities: 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 198 assignments points, you , may likely still end up with an A. Nota Bene, you have multiple sources of extra credit. So in this class you can literally get an A for effort.

Tips for Taking Quizzes or Tests

• Before you take the quiz, notice the time limit and number of attempts allowed.
• Make sure you first watch the relevant webcasts, take notes on viewgraphs and review notes.
• Arrange your schedule so you will not be interrupted.
• You may want to post a "Do Not Disturb" sign outside your door or computer area.
• Make sure your Internet connection is reliable for a continued connection while taking the quiz.
• Use a desktop or laptop instead of a phone or tablet to take the quiz.
• Contact your instructor via the Canvas Inbox immediately if you experience any problems while taking a quiz

It is the student's responsibility to officially withdraw (drop) from the class through Admission and Records or MySite. However, Instructor may drop, "No-Show" students under any of the following conditions:

1. During the first week of this course, you are required to participate or you may be dropped from the course. You must at least login to canvas before the end of the first week. Reminders will be sent to school email accounts.
2. As part of the read me first canvas module you are required to introduce yourself as part of the welcome announcement discussion board.
   If you have any challenges with the two above tasks during the first week, please notify me as soon as possible so we can get you started!
   
3. Students who have not completed at least 1 assignments two days before the drop without W grade.
4. By the last date to add with APC code, you must login to canvas, complete the orientation quiz and any corresponding assignment.
5. Students who have been emailed a drop warning and don't attempt the stated work.
6. Students who have not completed at least 50% of the work  by two days before the drop with W grade.
7. When in-class sessions are present, students who miss 2 or more class sessions or the very first onsite in-person class session.
   
8. Throughout the semester, I will review your participation and assignments. If you have not participated or logged in within the previous 10 days, you can be dropped from the course. It’s your responsibility to notify me if you have any challenges as soon as possible. It is also your responsibility to drop the course if you feel you can no longer participate and complete the course.

Consult current schedule for exact dates.

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.  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 (DE) 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 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. and instructor does offer in-person help. In addition to in-person help we have 24/7 access to webcasting software. With webcasting software instructor/student can share screen and provides VOIP (Voice over IP - Internet) interactive connections.

Personal Help Coaching Counseling

Besides being available to help with this class, if you need help navigating classes, what technology to learn and/or completing a certificate, you can always send me an email. In addition, to myself we also have success coach Victor Valadez and team counselor Jennifer Rachman.

General Help

Saddleback college also offers more individualized DE help at Canvas, login, or general Technical Support
The canvas site has two important links for help: student guides, and browser support (I don't recommended working on this class from a smartphone),

Netiquette is Internet manners, online etiquette, and digital etiquette all rolled into one word. Basically, netiquette is a set of rules for behaving properly online. Students are to comply with the following rules of netiquette:

• Identify yourself:
  • Begin messages with a salutation and end them with your name.
  • Use a signature (a footer with your identifying information) at the end of a message
• Include a subject line. If applicable; Give a descriptive phrase in the subject line of the message header that tells the topic of the message (not just "Hi, there!").
• Avoid sarcasm. People who don't know you may misinterpret its meaning.
• Respect others' opinions privacy. Do not quote or forward personal email without the original author's permission.
• Acknowledge and return messages promptly.
• Copy with caution. Don't copy everyone you know on each message.
• No spam (aka junk mail). Don't contribute to worthless information on the Internet by sending or responding to mass postings of chain letters, rumors, etc.
• Be concise. Keep messages concise—about one screen, as a rule of thumb.
• Use appropriate language:
  • Avoid coarse, rough, or rude language.
  • Observe good grammar and spelling.
• Use appropriate emoticons (emotion icons) to help convey meaning. Use "smiley's" or punctuation such as :-) to convey emotions. View the list of emoticons  at Netlingo and SmugBook

• Use appropriate intensifiers to help convey meaning.
  • Avoid "flaming" (online "screaming") or sentences typed in all caps.
  • Use asterisks surrounding words to indicate italics used for emphasis (*at last*).
  • Use words in brackets, such as (grin), to show a state of mind.
  • Use common acronyms,but know the context meaning discussed. (e.g., LOL usually means "laugh out loud", in gaming in means League of Legends, it also means Lot of Love)
  • do not use ALL CAPS or multiple exclamation marks (!!!)
• Be courteous to the other students in the class. You might find it helpful to read your posting out loud before you submit it: the "tone" is a very important part of electronic communication. When you read your message out loud does it sound the way you would speak to another student in the classroom?
• Refrain from inappropriate language.
• Never make derogatory comments toward another person in the class.
• You can disagree with ideas, but do not make personal attacks.

Other than Disabled Students Programs and Services (DSPS) directed auxiliary aids and academic accommodations, the use of any electronic listening or recording device in any classroom is prohibited without the explicit prior consent of the instructor (CA Ed Code Sec. 78907). It is in violation of South Orange County Community College District (SOCCCD) policies (BP 5401 & AR 5401) which address student conduct. It is also a crime to record any private communication, such as a classroom lecture, without the consent of all parties to the conversation (Cal. Penal Code § 632). Violation of such rules may result in disciplinary action.