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 | ||
| Master SQL Table Commands | ||
| Week 2 | Querying related tables | Foreign Keys in SQL |
| How SQL JOINs Actually Work | ||
| How to learn more SQL on your own | ||
| Week 3 | Overview of database design | 5 Database Design Goals You Must Get Right |
| The Database Design Lifecycle: Three Steps You Need to Know | ||
| Entities, attributes, and data types | How to Turn Real-World Ideas into Database Tables |
The lecture videos will be released as the course progresses.