CSCI 23200 Relational Databases and SQL, Section 03
Department of Computer Science
Hunter College, City University of New York
Fall 2021 Semester
3 credits
Prerequisite: CSCI 12700 or CSCI 13200
Susan Sun
susan.sun@hunter.cuny.edu
Lecture hours: Monday / Wednesday 7:00 - 8:15 PM ET
Office hours: Wednesday 8:15 PM - 9:00 PM ET, or by appointment
Classroom: on-line through Blackboard Collaborate Ultra
This course is an introduction to elementary database concepts and SQL, the standard language of communicating with most database systems. It is intended for students in the Quantitative Biology program and computer science minors. It does not offer credit to the computer science major.
SQL is a language in which to ask questions of a database. For large, pre-existing databases without customized interfaces (including many under development by biologists here at Hunter), SQL is either the standard access language or a more flexible and incisive alternative. The primary objective of this course is to enable you, working from the command line of an SQL interpreter or a GUI tool, to extract and reformulate data from large relational databases. Your goal is to produce readable, useful output from large collections of data. Although we will occasionally work with biological data, the fundamental principles you will learn can be applied in any database environment that supports SQL.
This course is organized around three essential questions:
By the end of the course, students will be able to:
This is a zero cost course. All reading materials will be freely available to enrolled students.
Participation is measured by attendance, as well as answering/asking questions in lecture. There are 28 lecture totals. The lowest 3 participation grades will be dropped.
Homework will be assigned on a weekly basis. There will be a 50% penalty for late submission.
You are encouraged to work together on the overall design of the homework and project, but all work submitted must be your own.
You are responsible for knowing and following Hunter College’s Academic Integrity Policy:
Hunter College regards acts of academic dishonesty (e.g., plagiarism, cheating on examinations, obtaining unfair advantage, and falsification of records and official documents) as serious offenses against the values of intellectual honesty. The College is committed to enforcing the CUNY Policy on Academic Integrity and will pursue cases of academic dishonesty according to the Hunter College Academic Integrity Procedures.
All incidents of cheating will be reported to the Office of Student Conduct in the Vice President for Student Affairs and Dean of Students office.
Computer Access: A computer is needed to attend lecture, complete the on-line assessments, and programming assignments and projects. Hunter College is committed to all students having the technology needed for their courses. If you are in need of technology, see Student Life’s Support & Resources Page.
Accommodating Disabilities: In compliance with the American Disability Act of 1990 (ADA) and with Section 504 of the Rehabilitation Act of 1973, Hunter College is committed to ensuring educational parity and accommodations for all students with documented disabilities and/or medical conditions. It is recommended that all students with documented disabilities (Emotional, Medical, Physical, and/or Learning) consult the Office of AccessABILITY. For further information and assistance, see their contact page.
Hunter College Policy on Sexual Misconduct: In compliance with the CUNY Policy on Sexual Misconduct, Hunter College reaffirms the prohibition of any sexual misconduct, which includes sexual violence, sexual harassment, and gender-based harassment retaliation against students, employees, or visitors, as well as certain intimate relationships. Students who have experienced any form of sexual violence on or off campus (including CUNY-sponsored trips and events) are entitled to the rights outlined in the Bill of Rights for Hunter College.
Sexual Violence: Students are strongly encouraged to immediately report the incident by calling 911, contacting NYPD Special Victims Division Hotline (646-610-7272) or their local police precinct, or contacting the College’s Public Safety Office (212-772-4444).
All Other Forms of Sexual Misconduct: Students are also encouraged to contact the College’s Title IX Campus Coordinator, Dean John Rose (jtrose@hunter.cuny.edu or 212-650-3262) or Colleen Barry (colleen.barry@hunter.cuny.edu or 212-772-4534) and seek complimentary services through the Counseling and Wellness Services Office, Hunter East 1123.