CMSI 486: Links to Class Notes

The following outline presents the topics that are covered, in the approximate order and time frame in which they will be discussed.

• Week 01 — Introduction, Syllabus, Getting Started
  
  • Syllabus items and issues
• Week 02 — The Fundamental Concepts (1)
  
  • Introduction
  • Brief historical perspective and methodology for the class
  • Relational Algebra for Fun and Profit
• Week 03 & Week 04 — Fundamental Concepts (2)
  
  • Traditional Databases
  • Schema, ANSI SPARC 3-Layer model
  • Entities / Attributes/Relations
  • Diagrams: Crow's foot vs Wang vs UML
  • Cardinality
  • Tables, Keys, and Normalization
  • ACID and CRUD
  • Constraints and Stored Procedures
  • SQL Language / MySQL / PostGreSQL
• Week 05 — Transactional Analysis
  
  • Transaction processing
• Week 06 — Transactions and Locking
  
  • Transaction processing concludes
  • Concurrency and Locking
• Week 07 — Midterm Examination
  
  • Review for mid-term exam during first session of the week
  • Midterm exam 2019-10-09 Wednesday
• Week 08 — NoSQL Databases (1)
  
  • Re-hash the mid-term: first session of the week
  • The Mongo DB — Mongo only Pawn in Game of Life
• Week 09 — NoSQL Databases (2)
  
  • Mongo DB Part Deux
• Week 10 — Graph Databases (1)
  
  • Neo4J part 1
  • Project SCRUMs
• Week 11 — Graph Databases (2)
  
  • Neo4J part 2
  • Project SCRUMs
• Week 12 — Data Warehousing
  
  • Big Data
  • Data Mining Schemas
  • Project SCRUMs
• Week 13 — A Secure Thanksgiving
  
  • Security and Database Vulnerabilities
  • Something else goes here...
  • Project SCRUMs
• Week 14 — Demonstrations Week I
  
  • Project demonstrations
  • Thanksgiving Holiday — no class Wednesday or Thursday
• Week 15 — Demonstrations Week II and Review Week
  
  • Course Evaluations
  • Finish the Project Presentations
  • Review for final exam
• Week 16: FINAL EXAM
• Wednesday, Dec 11, 08:00