601.315/415/615 - Databases
Instructor:
David Yarowsky
Syllabus:
PDF version
TAs, Office Hours and Review Sections:
Current Office Hour Timetable available on Piazza.
Office Hours and TA contacts
Current CA office hours spreadsheet
Piazza signup
(passcode emailed to all students)
Gradescope access code: BK8EXK
Textbooks:
Assignments:
Homework 1a - Due 10/1/24
Homework 1b - Due 10/4/24
Homework 1 help session
Homework 2 - Due 10/23/24
Homework 2 - jhu2024sql.txt
Homework 2 - jhu.schema
2020 Midterm TABLES for 601.315/415/615
2020 Midterm for 601.315 (PDF)
2020 Midterm for 601.415/615 (PDF)
2020 Midterm Sample Solutions for 601.315/415/615
2020 Midterm Question 5d corrected for 601.415/615
2020 Midterm Question 6b corrected for 601.415/615
2022 midterm for practice (please do under timed conditions)
2022 midterm for practice (tables)
2022 midterm for practice (sample solutions)
notes regarding midterm
Homework 3 - Due 11/07/24
Class Notes:
Lecture 0 Notes (PDF)
Topics on Final Exam
(December 18, 2023, 6-9PM Baltimore time, Hackerman B-17)
All class slides to date
MySql installation and use demo (PDF)
Comparative analysis of SQL/RelAlgb/Domain+TupleRelCalc/English (PDF)
Relational Algebra Examples (PDF)
HW3 lecture slides (PDF)
Notes on PL-SQL (PDF)
Additional examples on MySQL stored procedures and PHP (html)
Stored Procedure Examples
Notes on MySQL/PHP/Web interaction (PDF)
Notes on MySQL/PHP/Stored-Procedures interaction (PDF)
MySQL-PHP-and-Perl.pdf [additional notes]
Using mysql on Dbase [basic]
mysql-storedprocedures.pdf [official MySQL documentation]
mysql-views.pdf [official MySQL documentation]
ADDITIONAL CLASS NOTES AND RESOURCES
All remaining lecture notes are available in a class-only directory on the undergraduate network