CSPB 3287 - Design and Analysis of Database Systems

*Note: This course description is only applicable for the Computer Science Post-Baccalaureate program. Additionally, students must always refer to course syllabus for the most up to date information. 

  • Credits: 3.0
  • Prerequisites: CSPB or CSCI 2270 Computer Science 2: Data Structures with minimum grade C-.
  • Minimum Passing Grade: C-
  • Textbook: "Database Systems: The Complete Book, 2nd Edition", Garcia-Molina, H., Ullman, J. D., and Widom, J. (domestic, or international edition)

Sample course video coming soon! 

Brief Description of Course Content

Analyzes design of data systems, including data stored in file systems, database management systems and physical data organizations. Studies calculus of data models, query languages, concurrency and data privacy and security.

Specific Goals for the Course

 
  • Understand the theoretical underpinnings of modern databases
  • Be capable of choosing appropriate models and their related databases
  • Gain familiarity with the underlying mechanisms of various database implementations
  • Develop troubleshooting and optimization skills for Relational Database Management Systems
  • Relational Algebra and Algebraic Query Languages
  • Structured Query Language (SQL)
  • Data Modelling and Normalization
  • Entity Relationship Models and E/R Design Techniques
  • Keys, Constraints and Indexes
  • Transactions and Optimization
  • Hardware and implementation issues
  • NoSQL, Key-Value and Column Databases
  • Introduction to the CAP Theorem
Discrete Mathematics, Algebra, Set Theory, Boolean Algebra, Algorithmic Complexity (Big O Notation)

  Return to Course List