Information of Value Before the Semester Starts

Get the textbook: Harrison; MySQL Stored Procedure Programming; O'Reilly; ISBN 978-0-596-10089-6

Email address: Verify that the email address you have with CCSF is one that you read regularly. This is how you will be contacted for info re this class.

WaitList: This class has a waitlist set up. If the class is full when you try to enroll, add yourself to the waitlist. Waitlisted students will be added by the system if other students drop during the preregistration period. Refer to this Link for information on waitlists. I generally add all students on the waitlist. If you are on that waitlist I will send you an Add Code number by Tuesday evening the first week of class. I will send this Add Code to the email that you have registered with CCSF. Other requests for AddCodes will be handled after the waitlisted people.

Plan: When are you going to do the work for this class?
Organization Ideas This is a 3 unit class so you need to set aside a period of time to work on the class material on at least two days during the week. This is not a "self-paced" class. There will be weekly readings and assignments will be due almost every week.

Software: You must install MySQL version 5.0 ( or 5.1) on your local computer. You can download the MySQL software for free from the MySQL site.

Class Policy Class Policy statement

Info on the option of taking this course as a Pass/Fail (Cr/NoCr) class

The midterm and final exam are in-person exams to be held on the Phelan campus on Saturday October 10 and Dec 19.

On the First Day or Two of Class, You Need to Do the Following

Log into the class Insight web site. Please click on this Link for info on Insight, the Orientation session, and issues for the first weeks of class.

General Preparation for Classes

You can visit http://www.ccsf.edu/Departments/Distance_Education/students.htm to prepare for learning online.

Students who need academic accommodations should request them from the Disabled Students Programs and Services (DSPS) located in the Rosenberg Library,Room 323 on the Ocean Campus. Telephone: 415-452-5481 (V) 415-452-5451 (TDD). DSPS is the campus office responsible for verifying disability-related need for academic accommodations, assessing that need, and planning accommodations in cooperation with students and instructors as needed and consistent with course requirements.

General Information for CS 155P

This is a second semester course in the use of MySQL. This class focuses on the procedural approaches to data in MySQL databases.

Frequently Asked Questions

Q: Why MySQL?
A: MySQL is a major player in the database field and version 5 has added the ability to write and use stored routines.

Q: Why programming?
A: If you are going to develop MySQL solutions, you need to know how to use the available tools. For some tasks, non-procedural SQL is the best tool. For other tasks, being able to write your own stored procedures and functions using procedural programming code is the way to go. The programming approach lets you write triggers and handle transactions and errors which are necessary components of an application.

Q: What background do I need for this class?
A: The prerequisite is CS 155A or 150A or 151A, but this prerequisite is not enforced at registration.
You need to have experience with using SQL to create tables, access data, and make changes to the data. If your only experience using a database is using QBE, where you fill in a grid to create queries, you will need to spend some time with the SQL language. I will provide some links to SQL tutorials and post some examples of the SQL statements you should be able to use.
If you learned T-SQL or Oracle SQL that should be sufficient preparation.

Q: Which version of MySQL are we using?
A: Currently we are using MySQL version 5.0 You need to use a local installation of MySQL version on your computer. You can download MySQL at no cost.