The content of this course is actually about how to use the database and principles to design the tables and customized functions. It will not deep into the principles of database and teach you how to build a database system from scratch neither.
- Instructor:
Ran CHENG (程然) - TA:
Weiyu Wang (王维语) - Semester:
2023 Fall - Textbook:
Database System Concepts
- Lab Tutorial and experiments for SQL in PostgreSQL
- Assignment Programming assignment in SQL
- Practice Try to build a database from scratch (learn by myself)
- Project Documents for projects (two parts in total)
- Slides Slides for theory part
- Text Reference book for this course.
| Chapter | Content | Note |
|---|---|---|
| Database Design | Intro to SQL (Structure Query Language) 1-3 Normal Form Entity-Relation Diagram |
|
| SQL | DDL (Data Definition Language) DML (Data Manipulation Language) Data Type Constraint Query and Subquery Aggregate Function Join Window Function |
|
| Function and Trigger | ||
| Transaction | ||
| Relational Algebra | ||
| Index |