SQL – Structured Query Language
Section 5416 | CS 81.61 | 1.5 credits
March 28, 2011 – May 22, 2011
A Santa Rosa Junior College online class.
This class explores how to build information-driven systems using MySQL. Students will develop a working SQL database using MySQL Workbench. Database design and integrity, normalization and table structures, Data Definition and Manipulation and Query functions are used to see how SQL organizes and manipulates complex data models.
|March 28||Basic SQL||Chapter 5|
|April 4||Database Structures||Chapter 6||Project 1
|April 11||Database Design & Modeling||Chapter 4||Project 2 Quiz 2|
|April 18||Advanced Querying||Chapter 7||Project 3
|April 25||Midterm||Midterm exam|
|May 2||Web Database Access & PHP||Chapter 13-14||Project 4
|May 9||Web Database Applications||Chapter 15|
|May 16||Web Database Analytic System||Chapter 8||Project 5|
You need to have a webserver host account that includes FTP access, Apache webserver, PHP, MySQL and the Zend framework. Santa Rosa Junior College offers free Linux-based webserver account – apply for an account here. If you already have an SRJC Linux account, you may need to install MySQL . Here is more information about your account.
In addition, we will be using the free version of MySQL Workbench to develop our database, please download and install it. It is available for Windows, Mac and Linux.
Learning MySQL by Seyed M.M. (Saied) Tahaghoghi & Hugh Williams | ISBN-13: 978-0596008642 O’Reilly Media
Your final grade will be based on the following:
- 91% -100% = A
- 81% -9 0% = B
- 71% – 80% = C
- 65% – 70% = D
- <65 = F
|Date Class Begins:||1/20/2011|
|Date Class Ends:||5/22/2011|
|Last Day Add w/o add code:||3/30/2011|
|Last Day Add with add code:||4/8/2011|
|Last Day to Drop and be eligible for refund:||4/2/2011|
|Last Day for P/NP option:||4/13/2011|
|Last Day Drop w/o W:||4/8/2011|
|Last Day Drop with W:||5/8/2011|
Tests and Quizzes
There will be four online quizzes throughout the course and an online midterm and final exam. The material comes from the class textbook and supplemental materials such as published class notes or blogs. If any exam is missed, a zero will be recorded as the score. It is your responsibility to take the online exams by the due date.
You must submit five complete projects throughout the semester.
There are five project tutorials assigned throughout the semester and your projewillcts be based on these examples or on others as pre-approved by the instructor.
Projects are late if not submitted by Sunday at midnight following the class that the assignment is due. Late assignments can be submitted (or resubmitted with instructors consent) for 83.3% credit up to one week after the due date. Any assignments turned in more than two week late will receive no credit.
You may take this class credit/no-credit. You must decide before the fifth class and file the appropriate form with Admissions and Records. You must complete the midterm and final quizzes and projects to receive class credit.
Dropping the Class
If you decide to discontinue this course, it is your responsibility to officially drop it to avoid getting no refund (after 10% of course length), a W symbol (after 20%), or a grade (after 60%). Also, for several consecutive, unexplained absences, the instructor may drop a student. See the schedule on this page for deadlines specific to this class.
Standards of Conduct
Students shall conduct themselves in a manner that reflects their awareness of common standards of decency and the rights of others. Interference with SRJC’s educational objectives is a cause for disciplinary action. All members of the college community are expected to refrain from such interference, including the following types of conduct:
- Disruption of teaching
- Dishonesty, cheating, plagiarism
- Physical or verbal abuse
- Disorderly, lewd, indecent, or obscene conduct
Here is a list of some basic guidelines for using the class forum or emailing directly to the instructor or a classmate:
- Email can easily be misinterpreted; be brief, polite, never send email when angry.
- Always include a pertinent subject title for the message.
- Capitalize words only to highlight an important point or to distinguish a title or heading. Capitalizing whole words is termed as SHOUTING!
- It is rude to forward personal email without the author’s permission
Students with disabilities who believe they need accommodations in this class are encouraged to contact SRJC Disability Resources (527-4278), Analy Village – C, as soon as possible to better ensure such accommodations are implemented in a timely fashion.