DB: Introduction to Databases

Jennifer Widom, Stanford

Learn about Databases, one of the most prevalent technologies underlying internet and computing applications today.

Overview

About This Course

"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.

Why Learn About Databases

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.

Course Syllabus

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.

Course Staff

Jennifer Widom

Jennifer Widom is the Fletcher Jones Professor and Chair of the Computer Science Department at Stanford University. She received her Bachelors degree from the Indiana University School of Music in 1982 and her Computer Science Ph.D. from Cornell University in 1987. She was a Research Staff Member at the IBM Almaden Research Center before joining the Stanford faculty in 1993. Her research interests span many aspects of nontraditional data management. She is an ACM Fellow and a member of the National Academy of Engineering and the American Academy of Arts & Sciences; she received the ACM SIGMOD Edgar F. Codd Innovations Award in 2007 and was a Guggenheim Fellow in 2000; she has served on a variety of program committees, advisory boards, and editorial boards.

Frequently Asked Questions

How long does the course last?

The course material is scheduled for just over 9 weeks, followed by a final exam period March 20-22, 2014.

How many hours per week can I expect this course to last?

Each week includes 1-2 hours of video material, although some students review videos multiple times, while others opt to crank up the speed. Quizzes and exercises can vary from attempting the minimum number of problems just once (perhaps a couple of hours), to repeating all of the required and optional problems until you have them completely nailed. Because we provide pointers to a great deal of review material, and we've created a large number of optional exercises, the sky's the limit in terms of time commitment.

What background do I need?

The course does not assume prior knowledge of any specific topics, however a solid computer science foundation -- a reasonable amount of programming, as well as knowledge of basic computer science theory -- will make the material more accessible. Also bear in mind that picking and choosing which topics to learn is a great approach, and not all topics require the same level of background.

Do I need to buy a textbook?

Detailed lecture notes are provided. Having a textbook in addition to the notes is not necessary, but you might want to purchase one for reference, to reinforce the core material, and as a source of additional exercises. Suggested textbooks and readings are listed as part of the materials.

How does this course differ from the corresponding course for Stanford students?

Stanford students watch exactly the same videos and do exactly the same quizzes and exercises. In addition, Stanford students work hand-graded "challenge problems" in certain topics, and they have a multi-part programming project.

Do I get a credit or a certificate?

No, you will receive an informal Statement of Accomplishment from the instructor.

What will be required to receive a Statement of Accomplishment?

In the previous two offerings, all students who achieved at least 50% of the possible points received a Statement of Accomplishment. We expect to use a similar metric this year.

Share with friends and family!
  1. Course Number

    DB
  2. Classes Start

    Jan 06, 2014
  3. Classes End

    Mar 22, 2014
  4. Estimated Effort

    8-12 hours per week
Dates:
  • 6 January 2014
Course properties:
  • Free:
  • Paid:
  • Certificate:
  • MOOC:
  • Video:
  • Audio:
  • Email-course:
  • Language: English Gb

Reviews

No reviews yet. Want to be the first?

Register to leave a review

Show?id=n3eliycplgk&bids=695438
Included in selections:
NVIDIA
More on this topic:
6-080s08 Great Ideas in Theoretical Computer Science
This course provides a challenging introduction to some of the central ideas...
Cs50-verified-262x136 CS50x: Introduction to Computer Science
An introduction to the intellectual enterprises of computer science and the...
Images_course_image HRP258: Statistics in Medicine
Provides a firm grounding in the foundations of probability and statistics,...
53948_d893_20 Microsoft Excel 2010 for Beginners
Master Excel basics in this easy to follow, step-by-step course.
Images_course_image-262x136 30240184x: Data Structures • 数据结构
Learn the basics of data structures and methods to design algorithms and analyze...
More from 'Engineering & Technology':
Regular_e43a8f30-65ab-4ca0-be29-0885c6232610 Building a Future with Robots
Explore the role of robots and autonomous systems in the factories, homes, hospitals...
Regular_aff4cca2-6ed7-47d3-a142-04cd74524847 Challenges in Antibiotic Resistance: Gram Negative Bacteria
This course by BSAC is for healthcare professionals managing infections. You...
Regular_c8f9ad07-d725-4ea2-8fad-4bc795f096cb Precalculus: the Mathematics of Numbers, Functions and Equations
Gain an introduction to the essential mathematical knowledge and skills required...
Regular_a82712b5-ece9-4d0c-b37f-8a1427e62f33 Data Science in the Games Industry
Learn how the games industry can use big data to enhance the gaming experience...
Regular_cb4150ad-bc3f-4745-8e31-3db6ceec8563 Written in Bone: An Introduction to Forensic and Bio-archaeology
Learn to use human skeletal analysis to read and uncover the story behind human...
More from 'Stanford':
Nlp-logo CS224d: Deep Learning for Natural Language Processing
Natural language processing (NLP) is one of the most important technologies...
Visionlablogo CS231n: Convolutional Neural Networks for Visual Recognition
Computer Vision has become ubiquitous in our society, with applications in search...
Envphys_water EP101: Your Body in the World: Adapting to Your Next Big Adventure
Discover the amazing adaptability of the human body to environmental stressors...
Images_course_image HRP258: Statistics in Medicine
Provides a firm grounding in the foundations of probability and statistics,...

© 2013-2019