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 | Relational Databases for Beginners — Tables, Entities, Keys & SQL |
| SQL Filtering & Aggregation Made Easy (WHERE, GROUP BY, COUNT) | ||
| Master SQL Table Commands (CREATE, DROP, INSERT, DELETE, UPDATE, ALTER) | ||
| 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.