Welcome to CS 3200!

​

Mark Fontenot, PhD

Northeastern University

Your Guide …

• Mark Fontenot, PhD
• 353 Meserve Hall
• Office Hours:
• TBD (my schedule is settling for summer 2)
• Usually, very available on Slack… so just DM me.
• m.fontenot@northeastern.edu

Teaching Assistants

Where do I find … ?

• Course materials (Notes, HWs, etc) on Course Webpage
• Homework submissions via Gradescope; Project submission via GitHub
• Grades will be on GradeScope (will be synced to Canvas)
• Q & A Platform is CampusWire
• You should have received an email invite
• Quick DMs and Announcements will be on Slack

Course Webpage:

What’s this class about?

• By the end of this class, you should be able to
• Design a relational database data model
• Implement a data model in a modern RDBMS
• Perform simple and complex CRUD operations in SQL
• Access a DB from a programming language (Python, Java, etc.)
• Understand various modeling concepts in the DB world
• Design & implement a REST API to provide access to a DB and build a data driven application

High-Level Overview of the Semester

The Relational Model & SQL

Data Modeling & Database Design

Project + Cloud, Data Applications, Advanced Topics

Exam 1

Exam 2

Day 01

End of Semester

Course Deliverables and Evaluation

Homework Assignments

• Opportunity to practice and dig deeper
• Homework Due Dates
• HWs will be due Monday Nights at 11:59.
• 3% Bonus for submitting 24 hours early.
• (No… you can’t get > 3% for submitting >24 hours early)
• No Late Submissions accepted!
• But… life happens.. so everyone gets 1 free, no-questions-asked 24 hour extension.
• DM Dr. Fontenot on Slack sometime before or during the 24 hour window that you’re using your extension

Homework Assignments

• Submissions for Homeworks will be via GradeScope (unless directed otherwise)
• Only submit PDFs unless otherwise instructed
• It is YOUR responsibility to associate each question with your specific solution. Failure to do this could result in no credit for the problems not connected.
• All regrade requests must be submitted within 48 hours of grades being released on GradeScope. No Exceptions.
• Note: Grades on HWs may not be released before next scheduled exam.
• We will try to release solutions in a timely fashion, but don’t rely on that to study.

Exams

• There will be 2 exams
• Exam 1: July 18 (Thursday)
• Exam 2: Aug 8 (Thursday)
• Exam will be paper-based and taken during regular class time
• Exams are “officially” non-cumulative
• But you obviously will have to remember some stuff from Exam 1 in to Exam 2… e.g., can’t forget what a database is, which will be defined before Exam 1.
• There’s no final exam during finals period

Final Grade Breakdown

• Homeworks (5-6) 40%
• Exams (2) 30%
• Semester Project 30%
• More on this later in the semester

You & Success in 3200

YOU!

• Successfully completed one of the pre-req courses
• You need to be ready to:
• Work hard
• Practice and expand your independent research skills
• Start working on assignments when they’re released
• Ask questions when you have problems

Getting Help

• Me & TAs
• Office hour schedule for TAs will be released soon
• TA Office Hours will be virtual and start Tuesday (tomorrow)
• CampusWire
• If you have a question, others probably do also.
• Helps with efficiency and keeps our responses consistent
• Slack
• DM me or the TAs

My Teaching Philosophy

Foundations + Applications

​

Know + Do

Expectations

• Conduct yourself respectfully
• Don’t distract your classmates from learning
• Don’t cheat!!
• Do your own work unless group assignment
• Discussing problems is encouraged, but you must formulate your own solutions
• See Syllabus for details!

Materials

• Don’t need to purchase a textbook
• We’ll use O’Reilly for Higher Education
• Permalink to NU Library’s O’Reilly Site
• Login with NU Credentials.
• On O’Reilly site, make account with your Northeastern email address!
• Search for CS 3200 - References �Playlist

Playlist:

Your Laptop

• You’ll need to have sufficient space on your laptop for
• DataGrip, sample databases, etc.
• Docker + Containers
• You’ll need to free up at least 20-30 GBs of space.
• You should do this ASAP

Software to Get Started

• JetBrains DataGrip
• Sign up for JetBrains Student License
• Download and install DataGrip for your platform
• Docker Desktop
• Mac
• Windows

​

• For this course, we will be using MySQL RDBMS via Docker. More on this later.

Homework Assignments

• HW 01 is already posted on the class webpage
• Thinking about data, ensuring Slack and DataGrip are set up.
• Regular Deadline: Monday July 8 @ 11:59pm uploaded to GradeScope.
• Early EC Deadline: Sunday July 7 @ 11:59pm uploaded to GradeScope.

??