The structure of this summary is mainly derived from the course materials and experimental materials of the same-name course in the Department of Computer Science and Engineering(CSE) of Southern University of Science and Technology(SUSTECH). At the same time, many search engines, including google, edge, and many websites, such as csdn, StackOverflow, chatgpt also gave me great help. Here I would like to express my gratitude to all the above people, websites, etc. who have helped me.
This course focuses on database machanism, manipulation, and its good design.
Please note that we will use PostgreSQL in this course
1.I will try my best to update it once a week
2. I will try my best to update it in both Chinese and English
If you feel that these documents have helped you, you can light up a small star in the upper right corner
Preparation -- How to use command to access the postgreSQL?
Lab1 -- Introduction
Lecture 2 & Lab 2 -- SQL introduction and basic grammer in PostgreSQL
Lecture 3 & Lab 3 -- Query in single table: select, from, where and some functions
Lecture 4 & Lab 4 -- Distinct, count and groupby, Join, Quickly Search properties of a table
Lecture 5 & Lab 5 -- More about join, Set Operation, Subquery, Update and Delete
Lecture 6 & Lab 6 -- More about NULL, Ordering and Window function
本摘要结构主要来源于 南方科技大学（SUSTECH）计算机科学与工程系（CSE） 同名课程的课程资料和实验资料。同时很多搜索引擎，包括google，edge，还有很多网站，比如csdn，StackOverflow，chatgpt也给了我很大的帮助。在此向以上所有帮助过我的人、网站等表示感谢。
本课程侧重于数据库机制、操作及其良好设计
请注意，我们将在本课程中使用 PostgreSQL
1.我会尽量每周更新一次
2.我会尽量更新中英文版本
如果你觉得这些文件给予了你帮助，你可以在右上角Star出点亮一个小星星
准备 -- 如何使用命令访问postgreSQL？
实验 1 -- 简介
课程 2 & 实验 2 -- SQL 介绍和 PostgreSQL 中的基本语法
课程 3 & 实验 3 -- 单表查询：select、from、where和一些函数
课程 4 & 实验 4 -- Distinct、count 和 groupby、Join、快速查看表的属性
课程 5 & 实验 5 -- 更多关于连接、集合操作、子查询、更新和删除
课程 6 & 实验 6 -- 更多关于 NULL、排序和窗口函数