|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/rdbmsdev/
课程评论：没有评论
Coursera 课程总结：从零开始用 C/C++ 实现 SQL 关系型数据库 本课程（预计于 2023 年 12 月 29 日发布）旨在深入探讨关系型数据库管理系统 (RDBMS) 的内部设计与实现原理，而非教授 SQL 查询或数据库使用技巧。该课程面向开发者，将一步步揭示驱动 `SELECT` 查询正常工作的底层设计、实现、数据结构与算法。 **第一部分课程内容：** * **目标：** 实现一个基础的、可在内存中运行的 RDBMS（PostgreSQL 克隆）。 * **基础功能：** 支持基本的 SQL `SELECT`、`CREATE`、`INSERT` 和 `DELETE` 查询。 * **进阶功能：** 逐步实现对聚合函数、`JOIN`、`WHERE`、`GROUP BY` 子句的支持，甚至包括嵌套查询。 * **局限性：** 所有数据存储在内存中，进程终止后数据将丢失。 **续篇课程内容（计划）：** * **持久化存储：** 将 RDBMS 实现转移到磁盘，实现真实数据库的持久化存储。 * **高级特性：** 实现并发读/写、写前日志 (WAL)、事务、数据库更新钩子等复杂功能。 **课程定位与要求：** * **适合人群：** 追求知识和卓越的开发者。 * **难度：** 中级到高级。 * **前提知识：** 要求对数据结构有扎实的掌握，并具备熟练的编程能力。 * **项目建议：** 可作为学期项目或毕业设计。 **警告：** 本课程难度较高，不适合仍在学习基础数据结构或编程能力欠佳的学习者。
** 29 DEC 2023 Under Dev ** This Course is about Learning Internal Design and Implementation of RDBMSs. Several times you have used RDBMSs and written a few SQL queries - but, never given a thought to how RDBMSs internally work. This Course is exactly about this. This course is not about learning SQL queries or how to work with RDBMSs. This course is for developers. We shall explore step by step - The Design, Implementation, Data Structures, and Algorithms in place which work together to make your SELECT queries work!This Course Will be delivered as two courses - In the first Course (this course), we would implement a basic working RDBMS (PostgreSQL clone ) which can handle basic SQL select, create, insert, and delete queries. We will enhance the functionality further by supporting advanced features such as Aggregate functions, Joins, Where, and Group by Clauses. Nested Queries can also be supported. This RDBMS completely exists in RAM, and all data would vanish upon process termination.In the sequel part of the course, We will take our RDBMS implementation onto the disk for persistent storage ( like real RDBMS do ) and also Implement other Database complexities such as Concurrnet readers/Writers , Write-Ahead-Logging ( WAL), Transactions, DB Update Hooks etc.Talk to your prof - Do it as a Semester or Final year project. Best of luck!Needless to say - This course is Advanced and for Champs who are chasing knowledge and excellence rather than degrees and jobs.Warning: The Level of this course is intermediate to Advanced. Those who are still struggling with basic data structures, better excuse this course. You are expected to be thorough with Coding.
