main
December 6th, 2022    

CISC 7510X
Main
Files
Syllabus
Links
Homeworks

Notes
0001

DB1
Intro
SQL Intro
More SQL
Oracle Primer
MySQL Primer
PostgreSQL Primer
Indexes/Joins
Data Loads
AnalyticFuncs
DB Procs
DB Design
Hierarchical
DB Speed
Security
Dist DBs
Big Data
Hadoop/Hive
HBase Primer
Spark Primer

Code Gen
PHP (src code)
php src | php gen
C# DB (src code)
More C# DB (src code)
Java DB (src code)


Past Tests
F2022 Midterm(key)
S2020 Final
F2021 Midterm
F2021 Final
S2022 Midterm(key)
S2022 Final(key)
S2020 Final(key)
S2021 Midterm
S2021 Final(key)
F2020 Midterm (key)
F2020 Final Exam (key)
S2019 Midterm(key) S2019 Midterm2(key)
F2019 Midterm(key)
S2018 Midterm(key)
S2018 Midterm2(key)
S2018 Final(key)
S2018 Final2(key)
S2017 Midterm
F2017 Midterm(key)
F2017 Final(key)
S2017 Midterm(key)
S2017 Midterm2(key)
S2017 Final(key)
S2017 Final2(key)
F2015 Midterm
S2014 Midterm
S2014 Final
F2016 Final


Sample Data
ctsdata.20140211.tar
Stock Ordrs


SQLRunner

CISC 7510X - Database Systems

CISC 7510X: Tu 6:05PM - 8:10PM, Room: 234 IA

Fall 2022 semester, class will meet in-person.

My primary E-Mail: alex at theparticle dot com

WhatsApp: group link

Books:
[recommended] The Art of SQL, by Stephane Faroult (Author), Peter Robson
[recommended] Domain-Driven Design: Tackling Complexity in the Heart of Software, by Eric Evans
[recommended] The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling by Ralph Kimball, Margy Ross
[recommended] Big Data: Principles and best practices of scalable realtime data systems by by Nathan Marz, James Warren
[recommended] Fundamentals of Database Systems, by Ramez Elmasri and Shamkant B. Navathe

Description:
CISC 7510X - Database Systems

Database systems.

Office Hours:
I'm reachable online via email, or before or after class, or during scheduled office hours. Please text me or send me an email to arrange.

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 other 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.

CLASSROOM BEHAVIOR: Disruptive classroom behavior negatively affects the classroom environment as well as the educational experience for students enrolled in the course. Any serious or continued disruption of class will result in a report to the Office of Judicial Affairs. Public Safety will be summoned immediately if a serious disruption prevents the continued teaching of the class and you may be subject to disciplinary action. For disruptive behavior that does not prevent the continued teaching of the class, you will receive a warning after one such disruption. If the disruptive behavior is repeated in the same or subsequent classes, you may be asked to leave the classroom for the remainder of class and you may be subject to disciplinary action.

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.

IMPORTANT: All projects, assignments, homeworks, etc., will be submitted via email (subject line: "CISC 7510X HW#" ). Emails without this subject may be filtered/deleted/ignored. Do not print out 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