College of San Mateo
 

CIS 363: Enterprise Database Management - Spring 2012



Instructor: Bob Timlin
Email: bob@timlin.net
Web Site: www.Timlin.net
Yahoo Messenger: timlinr@yahoo.com  -- Online
AIM/AOL: timlinr@aol.com -- Online
Yahoo Group: TimlinMySQL

Weekly Webinar @ 6PM Tuesdays: Join Webinar

Office: None -- Off Site
 

About Bob:

I've been in the Information Technology field for over 20 years and have been teaching in this field for over ten.  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 20 years with Oracle, SQL, C and Unix. I also have ten+ years experience with Java, MySQL, Visual Basic, PL/SQL, Perl,  C++ and many more. 

I currently work during the day at California Pacific Medical Center (now Sutter Health) 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.

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:

MySQL 5.0 Certification Study Guide
MySQL Press
ISBN: 0672328127

 

Prerequisite: CIS 254 or equivalent.

Class Hours: 
        CIS 363 (Lecture): Tuesday
: 6 PM - 8:50PM. Online using Goto Webinar and also on Youtube.
        CIS 363 (Lab):TBD. Online.

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 MySQL database. SQL is the standard relational database access and programming language for computers of all sizes. Students will be exposed to MySQL/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 and/or PHP & MySQL, and Database Administration.

Week Of TOPICS: Reading/Homework
1/17/2012 Introduction Class Chapters 1 & 2 for week of 1/24
1/24/2012

Weekly Webinar @ 6PM: Join Webinar

Introduction to DBMS and MySQL.

Chapters 1 & 2: Client/Server concepts.

Instructions on downloading & Installing MySQL 5.5

2012 Webinar on Youtube: Part A Part B MySQL on Mac Part D

2011 Webinar on Youtube: Part A Part B Part C Part D Part E Part F

Lab 1 -- due: 2/3/2012
1/31/2012

Weekly Webinar @ 6PM: Join Webinar

Normalization                Client/Server Architecture

ER Diagram for Simple Doctor to Patient Many to Many relationship

Chapters 4 (Connectors), 5 (Data-Types), and 6 (Identifiers)

Replay on You Tube (2012): Part A Part B Part C

Replay on You Tube (2011): Part A Part B Part C Part D Part E Part F Part G Part H Part I Part J

Lab 2 -- due: 2/10/2012
2/2/2012 ALERT: On campus in building 19 computer lab from 6pm to 8pm
2/7/2012 Chapters 7 (databases), 8 (Tables & Indexes), 9 (Querying for Data), Meta-data , and Class Notes

Replay on You Tube (2012): Part A Part B Part C Lab 2

Watch on You Tube and submit comments and/or questions prior to webinar: Part A Part B Part C Part D Part E

Weekly Webinar @ 6PM: Join Webinar

Lab 3 -- Due: 2/22/2012
2/14/2012 Chapters 10 (SQL Expressions) and 11 (Updating Data)

Notes from Class and Patient ERD

2012 Youtube lectures: Part A Part B Part C Part D Part E Part F

Watch on You Tube and submit comments and/or questions prior to webinar: Part A Part B Part C Part D Part E Part F

Weekly Webinar @ 6PM: Join Webinar

Read Chapters 12 & 13 for 2/25/2012
2/21/2012

Watch on You Tube prior to webinar: Part A Part B Part C Part D Part E

No Webinar this week

Chapters Twelve (Joins) & Thirteen (Sub-Queries)

QA for 2/21 & 2/28

Lab 4 -- Due: 3/5/2012
2/28/2012

2012 Youtube lectures: Part A Part B Part C Part D Part E Part F

Watch on You Tube prior to webinar: Part A Part B Part C Part D Part E Part F

Weekly Webinar @ 6PM: Join Webinar

Chapters Fourteen(14): Views, (15) Data Import/Export, (16) Variables

Lab 5 -- Due: 3/12/2012
3/6/2012

Watch on You Tube prior to webinar: Part A Part B Part C Part D Part E Part F

No Webinar this week, goto Thursday lab instead if you can

Chapters Chapters 18: Stored Procedures, Functions & Chapter 17: Prepared Statements

 
3/8/2012 Special Lab on campus in building 19 lab.  
3/13/2012 Review for Midterm on youtube Prepared Statements Stored Routines Q&A Notes Midterm due 3/18/12
3/20/2012

Weekly Webinar: Join Webinar

Chapters 19: Triggers (Examples) and 20: Meta Data.

Replay on You Tube (new 2012 links): Part A Part B Part C Part D

Webinar from 20-March-2012: Triggers-A Triggers-B Triggers-C

Read Chapters 17, 18, 19
3/22/2012 Optional lab help from 6pm to 8pm in building 19 lab  
3/27/2012

Weekly Webinar: Join Webinar

Chapter 21: Debugging MySQL Applications & Chapter 22: Basic Optimizations more on optimization

Midterm review from 27-Mar.: MT-A MT-B MT-C MT-D

Replay on You Tube (new 2012 links): Ch 21a Ch 22a Ch 21b Ch 21c Ch 21d

See Also Syllabus on data-warehouse

Lab 6 Due: 4/12/2012
4/3/2012 Spring Recess -- No Class. Lab 7 -- Due: 4/26/2012
4/10/2012 Client / Server with Java

Weekly Webinar: Join Webinar

You Tube lecture: Part A Part B Part C Part D Part E Part F

Q&A (2012): Part A Part B Part C Part D Part E

Lab 8 -- Due: May 10
4/17/2012 Java Web Apps: Part A Part B Part C Part D Part E Part D Part G

Weekly Webinar: Join Webinar

4/24/2012 Client/Server with PHP PHP Examples and developing PHP in Netbeans

Weekly Webinar: Join Webinar

You Tube Lecture: Part A Part B Part C

5/1/2011

Weekly Webinar:

Introduction to Database Administration. | Transaction Processing | HACMP | Replication

You Tube Lecture: Part A Part B Part C Part D Part E Part F Part G Part H Part I Part J

Lab 9 -- due: 5/17/2012
5/8/2011

No Webinar Tonight: Lab tonight from 7pm to 8pm

 
5/15/2011 Uploading/downloading files using MySQL, Java, and/or PHP

Weekly Webinar: Join Webinar | Review for Final | PHP files for upload/download

You Tube Lecture: Part A Part B Part C Review for Final.

 
5/22/2011 Final Exam  

 

Class Assignments: Weekly reading assignments and regular class exercises, which will consist of short hands-on 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 MySQL 5.x from MySQL web-site (www.mysql.com). You may also want to download the GUI tools for the query browser, which we will discuss in Chapter 3.  You must turn in all assignments on time, one AND ONLY ONE late assignment will be forgiven.  Turn in the 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. Weekly Questions.

Grading Policy:
Weekly Questions        : 10%
Labs			: 40%
Mid Term Exam:		: 20%
Final Exam:             : 30%

Average        Grade: 
90 - 100           A
80 - 89            B
70 - 79            C
60 - 69            D
< 60               F