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.
Check in to CATE system here first!
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.
Weekly Outline
| Week | Topic | Reading | Assignments |
|---|---|---|---|
| Database Concepts | |||
| March 28 | Basic SQL | Chapter 5 | |
| April 4 | Database Structures | Chapter 6 | Project 1 Quiz 1 |
| April 11 | Database Design & Modeling | Chapter 4 | Project 2 Quiz 2 |
| April 18 | Advanced Querying | Chapter 7 | Project 3 Quiz 3 |
| April 25 | Midterm | Midterm exam | |
| May 2 | Web Database Access & PHP | Chapter 13-14 | Project 4 Quiz 4 |
| May 9 | Web Database Applications | Chapter 15 | |
| May 16 | Web Database Analytic System | Chapter 8 | Project 5 |
| Final exam
|
Software Requirements
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.
Required Textbook
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:
| Assignment | Number | Points |
|---|---|---|
| Projects | 5 | 50 |
| Quizzes | 4 | 20 |
| Midterm | 10 | |
| Final | 20 | |
| Total | 100 |
- 91% -100% = A
- 81% -9 0% = B
- 71% – 80% = C
- 65% – 70% = D
- <65 = F
Class Schedule
| 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.
Projects
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.
Late Projects
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.
Credit-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
Email Etiquette
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
Special Needs
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.
Hello Jay Peretz!
Thanks for this page. I have a student server web account already set up, and it was used last semester for my php programming class. It has mysql, and php installed. I also took the Access class last semester. I am looking forward to the SQL class!
Best wishes,
Don Ensley
Hi. My name is Don Ensley. I am coming to this class in the last semester of my training as a web programmer. I am also taking Java programming, and the business of web development classes.
Hi Jay,
I’m currently enrolled in your SQL class. I’m reading thru the text and I’ve downloaded the XAMPP as recommended. As for the software needed for the class whats on the page plus the XAMPP will cover it?
I just want to make sure I have the right software.
Hi Michael. Actually you do not need to install the server software (XAMPP, WAMP, MAMP, etc.) I suggest that you get a server account on student.santarosa.edu and use the MySQL services through that account.
For week of April 4, what and where is the project and quiz? I do not see any link in the weekly outline section and I want to start on it.
Let me know.
Thanks.
Pla – I added links to the pages for each topic. You can also access them through a submenu on any of the blog pages under SRJC Classes -> SQL.
Jay,
I think your weekly outline is behind by one week:
For example: April 18 has link to April 11 homework and April 11 has the link to April 4 home work. I only did 1 quiz and it looks like I missed two quizes. Is the Quiz on April 11 for April 18? I do not want to click on it because I have not done April 18 homework.
Pla – sorry for the confusion. We are ahead in the TOPICS, but on schedule regarding the assignments, so this week we are studying Database Design & Modeling, and we are working on Project 2 and Quiz 2.
Hi Jay,
I have created my EER model for the database and am using the forward engineer wizard to create theSQL script to make it real. However, it asks me to connect to a DBMS and the only one we are connected to at the moment doesn’t allow us to create new schemas. Do we need to connect to another one, this time using the Read&Write user name and password? If so it is SRJC_MySQL_Read&Write? Or is there something I am missing here?
I posted a tutorial that will step you through the process…
http://www.jayperetz.com/myblog/?p=726