CISC437 Section 40

Meeting Time and Place

TR 3:00-5:30 Alison Hall (ALS) Room 132 (15 times)

Instructor

Andrew Novocin

Office Hours: TR 10:15-11:15 in SMITH 430 also R 1:15-2:15ish Newark Deli Bagel or by appointment (I'm usually around)

Email: andynovo@udel.edu

Teaching Assistant

Matthew Lambert

Office Hours: MWF: 2-4 in SMITH 201

Email: lambert@udel.edu

Important Links

Course Notes and Daily Schedule

Course Projects

Project Submission Guide

Course DJ site

Piazza site

ECE/CIS workflow for our class

Super-powers for you:

• Become a proficient DB developer:
  • Write queries like a champ
  • Use an ORM
  • Use transactions responsibly
  • Control access by roles
  • Be able to wire up apps in various languages to various DBs
  • Understand the difference between SQL and No-SQL workflows
• Leave this course as an amateur DBA:
  • Understand and setup data-backed architectures
  • Design normalized DB schemas for real apps
  • Analyze performance
  • Fight concurrency issues
• Understand enough to have in-depth conversations with Oracle employees
  • Thinking in relations
  • Relational calculus
  • B+ trees
  • Query Optimization
  • The basics of implementing a DBMS

Your opportunities for feedback (Rough %-age of your evaluated Grade)

• Daily Challenges / Participation (5%)
• 4 DB projects (20% each)
• Possibly 1 End of term Theory Exam (15%)

Textbook

Database System Concepts 6th Edition Silberschatz, Korth, Sudarshan

Rough Deadlines

• June 16th Project 1 Due
• July 7th Project 2 Due
• July 21st Project 3 Due
• July 30th Project 4 Due