My solvings of problem sets from Stanford's Databases MOOC by Jennifer Widom
"Databases" was one of Stanford's three inaugural massive open online courses in the fall of 2011; it was offered again in MOOC format in 2013 and 2014. The course is now being offered as a set of smaller self-paced "mini-courses", which can be assembled in a variety of ways to learn about different aspects of databases. All of the mini-courses are based around video lectures and/or video demos. Many of them include in-video quizzes to check understanding, in-depth standalone quizzes, and/or a variety of automatically-checked interactive programming exercises. Each mini-course also includes a discussion forum and pointers to readings and resources. Individual mini-courses can be accessed by selecting the title from the dropdown list above. The mini-courses are described briefly below, along with suggested pathways through them. Taught by Professor Jennifer Widom, the overall curriculum draws from Stanford's popular Databases course.
The following are a number of suggested pathways through the mini-courses, depending on the topics and depth desired. Of course you are welcome to mix and match the mini-courses any way you like!
- Basic: INTRODUCTION AND RELATIONAL DATABASES, SQL
- Extended version add: INDEXES AND TRANSACTIONS, CONSTRAINTS AND TRIGGERS, VIEWS AND AUTHORIZATION
- Comprehensive version also add: ON-LINE ANALYTICAL PROCESSING, RECURSION IN SQL
- Basic: INTRODUCTION AND RELATIONAL DATABASES, UNIFIED MODELING LANGUAGE (UML), SQL
- Extended version add: INDEXES AND TRANSACTIONS, CONSTRAINTS AND TRIGGERS, VIEWS AND AUTHORIZATION
- Comprehensive version also add: ON-LINE ANALYTICAL PROCESSING, RECURSION IN SQL
- Basic: INTRODUCTION AND RELATIONAL DATABASES, RELATIONAL ALGEBRA, SQL, RELATIONAL DESIGN THEORY, UNIFIED MODELING LANGUAGE (UML)
- Extended version add: INDEXES AND TRANSACTIONS, CONSTRAINTS and TRIGGERS, VIEWS AND AUTHORIZATION
- Comprehensive version also add: ON-LINE ANALYTICAL PROCESSING, RECURSION IN SQL
- Basic: XML DATA, JSON DATA
- With querying add: XPATH AND XQUERY
- With querying, comprehensive version add: XSLT
Unless otherwise indicated, the Site and all its content, such as text, images, and the HTML used to generate the pages ("Material") are the property of Stanford or that of our suppliers or licensors and are protected by patent, trademark and/or copyright under US or foreign laws. In consideration for your agreement to the terms and conditions contained here, Stanford grants you a personal, non-exclusive, non-transferable license to access and use the Site and the Material. Registered users may download Material from the Site only for such user's own personal, non-commercial use. No user may otherwise copy, reproduce, duplicate, retransmit, distribute, publish, scrape, download in bulk, sell, resell, commercially exploit or otherwise transfer any Material or modify or create derivative works of the Material. The burden of determining that use of any information, software, material or any other content on the Site is permissible rests with User. Some content on the Site is provided by third parties, and the use of that content is subject to rules and restrictions as indicated on the Site. You agree to be bound by all such rules and restrictions.