|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/tutoriald-for-sql-developers/
课程评论：没有评论
**Coursera 课程总结：面向 SQL 开发者的 TutorialD 教程** 本课程旨在介绍 TutorialD，一种基于关系代数数学原理的数据库查询语言，作为对 SQL 现有特性和潜在不足的补充和替代。 **核心内容：** * **SQL 的局限性：** 课程将探讨 SQL 中存在的“怪癖”，以及这些怪癖如何偏离了关系代数，并对查询结果的准确性和可靠性产生影响。 * **SQL 的替代方案：** 重点介绍 TutorialD 的设计理念和优势，包括： * 是否可能设计一个不包含 NULL 值的数据库。 * SQL 与关系代数的具体差异。 * 一个更好的 SQL 替代语言可能是什么样子，以及为什么。 * 用 TutorialD 替换 SQL 可以带来哪些收益。 * **实践操作：** 课程将引导学员使用 Project:M36（一个开源的关系代数引擎）来实践 TutorialD 语言，并构建自己的数据库。**请注意，运行 Project:M36 需要 Docker 环境。** **学习目标：** 通过本课程，学员将能够： * 识别 SQL 语言中的缺陷及其对查询结果可信度的影响。 * 理解 SQL 的不足并非数据库系统的固有复杂性，而是源于历史原因和设计选择。 * 认识到 TutorialD 作为一种基于坚实数学基础的替代语言的价值。 **适用人群：** 本课程特别推荐给已经掌握基础 SQL，并对探索替代性数据库语言感兴趣的技术人员。
Have you been bitten by the odd quirks of SQL and wondered if there could be something better? There is- it's called "TutorialD" which strictly adheres to the mathematics of the relational algebra.This course answers questions such as:is it possible to design a database without NULLs?how does SQL deviate from the relational algebra?what would an SQL alternative look like and why?what do we gain by replacing SQL with a different language?TutorialD is not merely a hypothetical language, but one implemented by Project:M36, a relational algebra engine, which is open-source software which can be downloaded and used for free. Using Project:M36, you will be able to experiment with the new TutorialD language and build real databases of your own. Docker is required to run Project:M36.By the end of this course, you will be aware of the flaws in SQL and how such flaws can reduce the confidence in your query results. At the same time, you will understand how SQL's flaws and historical baggage are not essential complexity of database systems, as proven by the alternative language: TutorialD.This course is recommended for technologists already familiar with basic SQL who are curious about alternative database languages.
