When | TF 1:35p-3:15p ET/Boston | |
Where | Online on Zoom (See Canvas for connection details.) | |
GradeScope | Submit homework | |
Piazza | The discussion board and OH schedule | |
j.rachlin@northeastern.edu | ||
Web | https://www.khoury.northeastern.edu/home/rachlin | |
My Office Hours | Wed 2-5p and Thu 1-4p ET/Boston on Zoom and by appointment only. Click here to reserve 20m for one-on-one help |
Hope McClew |
Malhar Parikh |
Yujin Park |
Pranav Raghavendra Rao |
|||
Madison Singlak |
Jahanavi Sinha |
Dachuan Zhang |
Title | Murach(2023) : Murach's MySQL 4rd Edition. |
Buy online | Amazon.com |
Description | Highly recommended. A very popular overview of MySQL including database administration, database design, writing SQL queries, and implementing stored programs. |
Title | Lemahieu, vanden Broucke (2018): Principles of Database Management | |
Buy online | Amazon.com | |
Description | Recommended. A modern textbook on Database Systems and design. Purchase as a reference, but not critical to succeeding in the class. |
The final grade for this course will be weighted as follows:
The homework and project will be weighted individually to optimize your grade. (If your homework average is better than your project grade, I'll give more weight to homework, for example.) Final grades will be assigned based on the following scale. Please note that grades are not rounded.
Letter | Range |
---|---|
A | 94 - 100 |
A- | 90 - 93.99 |
B+ | 87 - 89.99 |
B | 83 - 86.99 |
B- | 80 - 82.99 |
C+ | 77 - 79.99 |
C | 73 - 76.99 |
C- | 70 - 72.99 |
D+ | 67 - 69.99 |
D | 63 - 66.99 |
D- | 60 - 62.99 |
F | <60 |
Note: This schedule is subject to change and will be adjusted as needed throughout the semester.
Wk | Day | Topic | Due | |
---|---|---|---|---|
1 | Sep 3 | No Class |
||
Sep 6 | Intro: Why study databases? The Marine Biologist Story |
|||
2 | Sep 10 | Concepts: The database environment | ||
Sep 13 | MySQL up and running | |||
3 | Sep 17 | SQL Basics. Aggregation functions. | HW1:Concepts (9/15) | |
Sep 20 | More Aggregation: GROUP BY, HAVING + Data Import | |||
4 | Sep 24 | Views and Subqueries, Lab 06 | ||
Sep 27 | More Subqueries, SQL Review | |||
5 | Oct 1 | Data Types: varchar, int, date, etc. | HW2:Genes and Disease (9/29) | |
Oct 4 | DDL: Creating Tables, Inserting Records | |||
6 | Oct 8 | Conceptual Modeling | ||
Oct 11 | Logical Modeling | |||
7 | Oct 15 | More Logical Modeling | HW3: SceneSense (10/16) | |
Oct 18 | Normalization | |||
8 | Oct 22 | TBD | ||
Oct 25 | SQL Join Basics "Consider the following Venn Diagram..." |
HW4: Books that will change your life (10/27?) | ||
9 | Oct 29 | Advanced Joins | ||
Nov 1 | Indexing | |||
10 | Nov 5 | Stored Programs I | ||
Nov 8 | Stored Programs II | Required Project:
Declare Group, Title, Abstract. Submit Details to Gradescope Project Due: November 25th (No Extensions) |
||
11 | Nov 12 | ACID Transactions, Serialization | HW5: Adverse-Drug Reactions (11/13?) | |
Nov 15 | Locking and Deadlocks | |||
12 | Nov 19 | Programmings with Databases
Database APIs = ♥ |
||
Nov 22 | NoSQL | |||
13 | Nov 26 | Databases 2024: Poster Session | Products Due Monday 11/25 @ 11:59pm (No Extensions) | |
Nov 29 | No Class | |||
14 | Dec 3 | Rachlin gets the last word. Virtual Cookies.
The story of the 2nd time he almost got kicked out of Cornell shall be told. TRACE EVALUTIONS: The Good, the Bad, and the Ugly. Class will not be recorded. |
Northeastern University values the diversity of our students, staff, and faculty; recognizing the important contribution each makes to our unique community.
Respect is demanded at all times throughout this course. In the classroom, not only is participation required, it is expected that everyone is treated with dignity and respect. We realize everyone comes from a different background with different experiences and abilities. Our knowledge will always be used to better everyone in the class.
We strive to create a learning environment that is welcoming to students of all backgrounds. If you feel unwelcome for any reason, please let us know so we can work to make things better. You can let us know by talking to anyone on the teaching staff. If you feel uncomfortable talking to members of the teaching staff, please consider reaching out to your academic advisor.
Northeastern is committed to providing equal access and support to all qualified students through the provision of reasonable accommodations so that each student may fully participate in the learning experience. If you have a disability that requires accommodations, please contact the Disability Resource Center http://www.northeastern.edu/drc/, DRC@northeastern.edu, 617-353-2675. Accommodations cannot be made retroactively and to receive an accommodation, a letter from the DRC or LDP is required.