Database Systems

CSCI 330 - A course on SQL, database design, and data management.

This course is an introduction to the underlying data models and theory of database systems and the design, implementation, and manipulation of relational databases. On completion of this course, you will demonstrate:

  • a basic understanding of the relational database model and its SQL access language
  • a basic understanding of relational database design, primarily through entity-relationship diagrams and their translations to relational schemas
  • an introductory appreciation of functional dependency constraints and normal forms
  • the ability to interface with relational databases through a procedural programming language

Here are the tentative topics that will be covered in this course:

Week Topic Videos
Week 1 Introduction to SQL  
Week 2 Overview of database design  
  Entities, attributes, and keys  
Week 3 Relationships  
Week 4/5 Normalization and implementation  
Week 5/6 Security and optimization  


The lecture videos will be released as the course progresses.