Skip to Content

University of Colorado Boulder
Search

Search

Computer Science
College of Engineering and Applied Science
Computer Science

Main menu

  • Home
  • Academics
  • Research
  • People
  • News & Events
  • Admissions

Secondary Menu

  • Students
  • Engage
  • Faculty/Staff Resources

Mobile menu

  • Home
  • Academics
  • Research
  • People
  • News & Events
  • Admissions
  • Students
  • Engage
  • Faculty/Staff Resources
  • About
  • Admissions
  • Contact Us
  • Jobs
  • Funding Opportunities

CSPB 3287 - Design and Analysis of Database Systems

Course Details

*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

Specific Outcomes of Instruction
 
  • 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

Brief List of Topics to be Covered
  • 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

Mathematical Concepts Used in Course
Discrete Mathematics, Algebra, Set Theory, Boolean Algebra, Algorithmic Complexity (Big O Notation)

Return to Course List

  • Facebook
  • Twitter
  • LinkedIn
  • Instagram
  • YouTube

Apply  Visit  Give

Departments

  • Ann and H.J. Smead Aerospace Engineering Sciences
  • Chemical & Biological Engineering
  • Civil, Environmental & Architectural Engineering
  • Computer Science
  • Electrical, Computer & Energy Engineering
  • Paul M. Rady Mechanical Engineering

Programs

  • Applied Mathematics
  • Biomedical Engineering
  • Creative Technology & Design
  • Engineering Management
  • Engineering Physics
  • Engineering Plus
  • Environmental Engineering
  • Materials Science & Engineering

Affiliates & Partners

  • ATLAS Institute
  • BOLD Center
  • Colorado Mesa University
  • Colorado Space Grant Consortium
  • Discovery Learning
  • Engineering Honors
  • Engineering Leadership
  • Entrepreneurship

 

  • Herbst Program for Engineering, Ethics & Society
  • Idea Forge
  • Integrated Teaching and Learning
  • Global Engineering
  • Mortenson Center for Global Engineering
  • National Center for Women & Information Technology
  • Western Colorado University

Footer menu

  • About
  • Admissions
  • Contact Us
  • Jobs
  • Funding Opportunities

Computer Science

1111 Engineering Drive
ECOT 717, 430 UCB
Boulder, CO 80309-0430 USA
Phone: 303-492-7514
Contact Us by Email
Fax: 303-492-2844   
GPS Coordinates 40.006387, -105.261582

College of Engineering & Applied Science
Phone: 303-492-5071
Email: cueng@colorado.edu

Connect with CU Engineering

  • Facebook
  • Twitter
  • YouTube
  • LinkedIn
  • Instagram

University of Colorado Boulder

University of Colorado Boulder
© Regents of the University of Colorado
Privacy • Legal & Trademarks • Campus Map

Return to the top of the page