Databases: Semistructured Data

Overview

This course is one of five self-paced courses on the topic of Databases, originating as one of Stanford's three inaugural massive open online courses released in the fall of 2011. The original "Databases" courses are now all available on edx.org.

Part of the Databases series, this is a standalone course; learners seeking to develop an understanding of topics in this course do not need to take other Databases courses. This course covers the JSON and XML standards for semistructured data, along...

What you'll learn

Introduction to the relational model and concepts in relational databases and relational database management systems
Comprehensive coverage of SQL, the long-accepted standard query language for relational database management systems
Creating indexes for increased query performance
Using transactions for concurrency control and failure recovery
Database constraints: key, referential integrity, and "check" constraints
Database triggers
How views are created, used, and updated in relational databases
Authorization in relational databases
Star schemas, the data cube concept, and On-Line Analytical Processing (OLAP) features in relational databases including the Cube and Rollup operators
The SQL standard for queries over recursively-defined relations
Relational algebra – the algebraic query language that provides the formal foundations of SQL
Dependency theory and normal forms in relational databases as the basis of schema design

Skills you'll practise

SQL (Programming Language)XPath Human Readable Data Abstraction XQuery Relational Databases Extensible Stylesheet Language Transformations (XSLT)Database Design Query Languages JSON Extensible Markup Language (XML)Database Systems Telecommunications Computer Science Concurrency Controls

Advantages and disadvantages

Advantages

University courses you can audit for free, with lectures, readings and practice quizzes.
A verified certificate from the university if you pay for it.
The actual Stanford lectures (CS229, CS224N, CS231N…): the deepest free material on AI anywhere.
Taught by Stanford University, one of the strongest names in its field.
Self-paced: start any time.

Disadvantages

Graded assignments and the certificate need the paid track.
Audit access can expire a few weeks after the course ends.
Graduate level: needs linear algebra, probability and programming first.
Learning is free, but the certificate costs money.
Some parts (graded work, certificate) are paid.

Some points apply to every course of this kind; see how we rank.

Free to audit

Free: Choose "Audit this course" when you enrol: lectures, readings and practice are free.
Paid: Graded assignments and the verified certificate (Certificate $69). Audit access may end after the course closes.

Taught by

Jennifer WidomDean, School of Engineering

Stanford University is in Tier 1: world-leading universities and India's top institutes of our institution ranking (97/100).

Similar courses

Compare these

Harvard University · YouTube

CS50's Web Programming with Python and JavaScript (CS50W) 2020

This is CS50W, CS50's Web Programming with Python and JavaScript. Register for free at https://cs50.edx.org/web. Slides and source code at https://cs50.harvard.edu/web. This course picks up where Harvard University’s CS50 leaves off, diving more deeply into the design and implementation of web apps…

Free video10 videos, 14 hours

Harvard University · YouTube

CS50's Web Programming with Python and JavaScript

Learning objectives This course picks up where Harvard University's CS50 leaves off, diving more deeply into the design and implementation of web apps with Python, JavaScript, and SQL using frameworks like Flask, Django, and Bootstrap. Topics include database design, scalability, security, and user…

Free video13 videos, 20 hours