Database System (CS307)
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.
About
- Instructor:
Ran CHENG (程然) - TA:
Weiyu Wang (王维语) - Semester:
2023 Fall - Textbook:
Database System Concepts
Content
| 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 |