main
October 9th, 2008    

CIS 717.2 3.0 2750 ERV8
Main
Files
Syllabus
Links
Homeworks

UPLOAD HOMEWORKS

Notes
0001

PDFs
DB Design
Oracle Primer
Data Loads
DB Procs
Hierarchical
Partitions
Indexes/Joins
Security
Dist DBs

Intro
SQL Intro
Modeling
More SQL
Normal Forms
MySQL
PHP (src code)
php src | php gen
C# DB (src code)
More C# DB (src code)
Code Gen
Java DB (src code)
PL/SQL
T-SQL
Triggers
DB Speed

Tools(?)
DWSQLTool Alpha

Sample Data
Stock Ordrs

CIS 717.2 3.0 2750 ERV8 - Advanced Database Systems

Thursdays 08:10-10:15PM Room: 236 NE

Primary E-Mail: alex at the particle dot com
ICQ#: 2279415
AOL IM: profparticle
MSN IM: profphreak at msn dot com
Google IM: profphreak at gmail.com Yahoo IM: iparticle

Books:
[recommended] The Art of SQL, by Stephane Faroult (Author), Peter Robson
[recommended] Fundamentals of Database Systems, by Ramez Elmasri and Shamkant B. Navathe

Description:
CIS 717.2 Advanced Database Systems

Advanced topics in database systems.

Prerequisite: Computer and Information Science 717 or a database course.

Office Hours:
I'll be around right before and right after class. Also, I'll be somewhere around BC on Tuesdays and Thursdays from 6 till 8. Let me know, and we can setup a time.

Projects:
There will be several projects (ie: homeworks).

Tests:
You will have at least a midterm and a final exam. There might also be a surprise quiz every week.

In This Class:
Peer cooperation is encouraged, however, everyone must submit their own work. You will be expected to answer detailed questions about your assignments/projects. (i.e.: if you didn't write them, I'll know.)

Required:
Academic Integrity: The faculty and administration of Brooklyn College support an environment free from cheating and plagiarism. Each student is responsible for being aware of what constitutes cheating and plagiarism and for avoiding both. The complete text of the CUNY Academic Integrity Policy and the Brooklyn College procedure for implementing that policy can be found at this site: http://www.brooklyn.cuny.edu/bc/policies. If a faculty member suspects a violation of academic integrity and, upon investigation, confirms that violation, or if the student admits the violation, the faculty member MUST report the violation.

This means that if you cheat on a test or an assignment, I must file a report which will initiate academic penalties.

Attendance is not mandatory (I don't need a doctors note!), but highly recommended. [you must attend at least a few times in the first six weeks, or you will be dropped from the class with a WU grade]. Also, it would be VERY difficult to pass the class without regular attendence; you are responsible for catching up if you miss class (for any reason). That being said, if you hardly ever show up (miss >= 4 classes) don't expect to get anything but a WU grade.

All projects, assignments, homeworks, etc., will be submitted via that submission site. Do not print out nor e-mail me the assignments - they will promptly be trashed.

Grading:
Tentative grade breakup: ~25% for Midterm, ~35% for Projects, ~40% Final - These may change slightly depending on how well the class does in any of the above.





































© 2006, Particle