- The Relational Algebra section of this course teaches the algebraic query language that provides the formal foundations of SQL.
- The Relational Design Theory section of the course provides comprehensive coverage of dependency theory and normal forms in relational databases, a well-accepted theoretical framework for developing good relational database schemas.
- The Unified Modeling Language section of this course introduces the data-modeling component of UML, and describes how UML diagrams are translated to relational database schemas.
The introductory videos in this course are the same as the introductory videos in Databases: Relational Databases and SQL ; they are included for the benefit of learners who have not taken Databases: Relational Databases and SQL.
ABOUT THIS COURSE
About the Database Series of Courses
“Databases” was one of Stanford’s three inaugural massive open online courses in the fall of 2011. It has been offered in synchronous and then in self-paced versions on a variety of platforms continuously since 2011. The material is now being offered as a set of five self-paced courses, which can be taken in a variety of ways to learn about different aspects of databases.
Relational Databases and SQL is the most popular course in the Databases series. It is applicable to learners seeking to gain a strong understanding of relational databases, and to master SQL, the long-accepted standard query language for relational database systems. Additional courses focus on advanced concepts in relational databases and SQL, formal foundations and database design methodologies, and semistructured data.
All of the courses are based around video lectures and demos. Many of them include quizzes between video segments to check understanding, in-depth standalone quizzes, and/or a variety of automatically-checked interactive exercises. Each course also includes an unmoderated discussion forum and pointers to readings and resources. The courses are described briefly below. Taught by Professor Jennifer Widom, the overall curriculum draws from Stanford’s popular longstanding 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 number 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.
INSTRUCTOR
Jennifer Widom
Length: 2 Weeks
Effort: 8-10 hours per week
Price: FREE
Add a Verified Certificate for $50 USD
Institution: StanfordOnline
Subject: Computer Science
Level: Introductory
Language: English
Video Transcripts: English
Course Type: Self-paced on your time
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
Easily Shareable
Add the certificate to your CV or resume, or post it directly on LinkedIn
Proven Motivator
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.