College of San Mateo
CIS 360/361: Introduction to Database Management, SQL & PL/SQL - Spring 2007
Instructor: Bob TimlinAbout Bob:
I've been in the Information Technology field for over 15 years and have been teaching in this field for over five. I obtained my MS in Software Engineering from Golden Gate University in 2002 and undergraduate degree in Management Information Technology from Pace University, New York, in 1991. My experience includes over 15 years with Oracle, SQL, C and Unix. I also have five to ten years experience with Java, Visual Basic, PL/SQL, Perl, C++ and many more.
I currently work during the day at California Pacific Medical Center where I work on their Oracle data-warehouse and do web development using Java, JSP, Servlets, etc. Prior to CPMC I worked at Apple Computer on their Oracle data-warehouse. Between the two I have a total of ten years experience with data warehouses.
I am originally from New York and moved out to California in 1992 after a one year stint in Australia. My Californization was completed in 1995 when I gave up red meat and started to eat and like tofu.
When I am not doing this computer geek stuff I love to train in the Martial Arts. I have a black belt in Karate and have trained in Taekwon Do, Aikido, and Muay Thai Kickboxing, so get your homework assignments in on time! (Just Kidding...).
Please feel free to consult with me during the semester for assistance. This can be done personally, by phone, or by email. If you call or email, please leave me contact information and the best time to contact you.
Don't wait until late in the semester.
Required Text:
Prerequisite: CIS 255 or CIS 278 or equivalent.
Class Hours:
CIS 360 (Lecture): Mon/Wed: 7PM - 8:15PM. Please be on time.
CIS 361 (Lab): Mon/Wed: 8:30PM - 9:45PM. Please be on time.
Method of Instruction: Discussions and Cyber. Instructional material can be found at www.timlin.net
Course Description:
Provides an in-depth coverage of Structured Query Language (SQL) and PL/SQL. SQL is the standard relational database access and programming language for computers of all sizes. Students will be exposed to ORACLE/SQL and they will have extensive use of our computer labs during the course. If time allows the course will also introduce
Stored Procedures and Functions, Database Triggers, Transaction Processing,
Normalization,
Client/Server with Java & Oracle, and Database Administration.
Class Assignments: Weekly reading assignments and regular class exercises, which will consist of short hands-on SQL & PL/SQL scripts. All assignments and lecture notes will be available several days prior to class at www.timlin.net. You may be able to download a personal version of Oracle 10g Express from Oracle's web-site (www.oracle.com). You must turn in all assignments on time, one AND ONLY ONE late assignment will be forgiven. Turn in the SQL and/or PL/SQL script file along with the spooled output on hard copy one week after it is assigned. If you miss a class, it is your responsibility to contact the instructor or another student by email to obtain the current assignment, or any changes to the current assignment. NOTE: While this will usually be available at my web-site, you should still confirm by email in the event of last minute changes.
Course Requirements:
1. Assignments
2. Midterm and Final
3. Project
Grading Policy: Assignments : 20% Projects : 30% Mid Term Exam: : 20% Final Exam: : 30%
Average Grade:
90 - 100 A
80 - 89 B
70 - 79 C
60 - 69 D
< 60 F