About this courseSkip About this course
This course includes modules that were part of a series of 14 self-paced courses based on “Databases”, one of Stanford's three inaugural massive open online courses released in the fall of 2011.
These 14 courses are now available via edX.org, and are reorganized into five courses: Databases: Relational Databases and SQL; Databases: Advanced Topics in SQL; Databases: OLAP and Recursion; Databases: Modeling and Theory; and Databases: Semistructured Data.
What you'll learnSkip What you'll learn
Indexes and Transactions covers two very important features of database systems, from the application-builder's perspective: indexing for increased performance, and transactions for concurrency control and failure recovery.
Constraints and Triggers explains key, referential integrity, and "check" constraints, followed by extensive coverage of database triggers.
Views and Authorization provides extensive coverage of how database views can be created, used, and updated, and introduces standard techniques for authorization in relational databases.
Meet your instructors
Pursue a Verified Certificate to highlight the knowledge and skills you gain$50 USD
Official and Verified
Receive an instructor-signed certificate with the institution's logo to verify your achievement and increase your job prospects
Add the certificate to your CV or resume, or post it directly on LinkedIn
Give yourself an additional incentive to complete the course
Support our Mission
EdX, a non-profit, relies on verified certificates to help fund free education for everyone globally
Frequently asked questions
How long will it take to go through the course material?
All courses in the Databases series are self-paced and include videos, quizzes, and/or exercises. The courses vary considerably in length and complexity, and some students work faster than others, so we're not able to predict an individual time commitment.
What background do I need?
The series of courses 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.
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.