db: Introduction to Databases

开始时间: 04/22/2022 持续时间: 未知

所在平台: Stanford Online

课程类别: 计算机科学

大学或机构: Stanford University(斯坦福大学)

课程主页: https://class.stanford.edu/courses/Engineering/db/2014_1/about

课程评论: 1 个评论

评论课程        关注课程

课程详情

"Introduction to Databases" was one of Stanford's inaugural three massive open online courses in the fall of 2011 and was offered again in early 2013. January 2014 will mark its third offering. The course includes video lectures and demos with in-video quizzes to check understanding, in-depth standalone quizzes, a wide variety of automatically-checked interactive programming exercises, midterm and final exams, a discussion forum, optional additional exercises with solutions, and pointers to readings and resources. Taught by Professor Jennifer Widom, the curriculum draws from Stanford's popular Introduction to Databases course. Databases are incredibly prevalent -- they underlie technology used by most people every day if not every hour. Databases reside behind a huge fraction of websites; they're a crucial component of telecommunications systems, banking systems, video games, and just about any other software system or electronic device that maintains some amount of persistent information. In addition to persistence, database systems provide a number of other properties that make them exceptionally useful and convenient: reliability, efficiency, scalability, concurrency control, data abstractions, and high-level query languages. Databases are so ubiquitous and important that computer science graduates frequently cite their database class as the one most useful to them in their industry or graduate-school careers. This course covers database design and the use of database management systems for applications. It includes extensive coverage of the relational model, relational algebra, and SQL. It also covers XML data including DTDs and XML Schema for validation, and the query and transformation languages XPath, XQuery, and XSLT. The course includes database design in UML, and relational design principles based on dependencies and normal forms. Many additional key database topics from the design and application-building perspective are also covered: indexes, views, transactions, authorization, integrity constraints, triggers, on-line analytical processing (OLAP), JSON, and emerging NoSQL systems. Working through the entire course provides comprehensive coverage of the field, but most of the topics are also well-suited for "a la carte" learning.

课程评论(1条)

0

超級現實的超現實理想主義者 2014-03-19 17:09 0 票支持; 0 票反对

轮次:
2014年1月

背景:
去年知道这门课的时候已经快结束了,没有拿到证书所以今年补回来。这门课不需要什么背景,任何人都可以上。

内容:
主要围绕SQL和XML展开,并且包括Relational Algebra和JSON等内容。据官方描述这门课的内容和习题与Stanford校内的课程基本一致。授课方式在现在看来还是比较传统的:先讲概念,然后Demo。如果说稍微有点不满意的点应该就是视频长度有点不符合时代潮流了,有的视频动辄30min以上...虽然这门课程名以上有要求相应的教材,其实以视频的内容已经绰绰有余了。自从将MOOC作为生活方式后,我已经很久没看书了...

习题:
主要分为概念题和编程题,题目量不少,尤其是编程题,通过不断的练习巩固概念这一点挺好。题目做不出来的地方回头重新瞄一眼Demo基本上就能够解决。

总结:
作为MOOC的元老级别课程(另外两门是Udacity的AI和Andrew Ng的ML),两年过去以后这门课程的内容基本上没有什么变化。毕竟是以SQL和XML这些比较成熟的技术展开,所以也不算什么问题。不过里面也讲了No SQL,不过好像感觉目前也没什么人提了,所以这个部分也就没怎么听。

如果要系统学习数据库的话,这门课在目前的MOOC课程里面是最好也是唯一的选择。

课程简介

"Introduction to Databases" was one of Stanford's inaugural three massive open online courses in the fall of 2011 and was offered again in early 2013. January 2014 will mark its third offering. The course includes video lectures and demos with in-video quizzes to check understanding, in-depth standalone quizzes, a wide variety of automatically-checked interactive programming exercises, midterm and final exams, a discussion forum, optional additional exercises with solutions, and pointers to readings and resources. Taught by Professor Jennifer Widom, the curriculum draws from Stanford's popular Introduction to Databases course.

课程标签

数据库 数据库导论 数据库入门 斯坦福数据库导论 SQL NOSQL JSON XML

58人关注该课程

主题相关的课程