technifyed

Stanford University via edX

Databases: Relational Databases and SQL

4.547 ratings at edX

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.

This course provides an introduction to relational databases and comprehensive coverage of SQL, the long-accepted standard query language for relational database systems.

Databases: Advanced Topics in SQL and Databases: OLAP and Recursion are follow-...

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

Database DesignReliabilityPersistenceRelational DatabasesDatabase SystemsData AbstractionComputer ScienceScalabilityQuery LanguagesSQL (Programming Language)Concurrency ControlsAuthorization (Computing)Online Analytical Processing

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.
  • 152,493 learners have taken it, so help and notes are easy to find.
  • 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.

Before you start

There are no specific prerequisites for this course; however, some computer science background is expected for all of the courses in the Databases series.

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 Introduction to Programming with Python (CS50P) 2022

This is CS50P, CS50's Introduction to Programming with Python. Register for free at https://cs50.edx.org/python. Slides and source code at https://cs50.harvard.edu/python. Playlist at https://www.youtube.com/playlist?list=PLhQjrBD2T3817j24-GogXmWqO5Q5vYy0V. An introduction to programming using a la…

Free video11 videos, 16 hours

Massachusetts Institute of Technology · YouTube

MIT 6.100L Introduction to CS and Programming using Python, Fall 2022

Instructor: Ana Bell View the complete course: https://ocw.mit.edu/courses/6-100l-introduction-to-cs-and-programming-using-python-fall-2022/ *Note: Lectures 6, 10 have been updated! This subject is aimed at students with little to no programming experience. It aims to provide students with an under…

Free video26 videos, 28 hours

Massachusetts Institute of Technology · YouTube

MIT 6.01SC Introduction to EECS I

Instructor: Dennis Freeman, Kendra Pugh This course provides an integrated introduction to electrical engineering and computer science, including modern software engineering, linear systems analysis, electronic circuits, and decision-making. The lecture videos provide an overview of each topic, whi…

Free video27 videos, 17 hours

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 Introduction to Artificial Intelligence with Python 2023

This course explores the concepts and algorithms at the foundation of modern artificial intelligence, diving into the ideas that give rise to technologies like game-playing engines, handwriting recognition, and machine translation. Through hands-on projects, students gain exposure to the theory beh…

Free video8 videos, 12 hours

Harvard University · YouTube

CS50's Introduction to Artificial Intelligence with Python 2020

This course explores the concepts and algorithms at the foundation of modern artificial intelligence, diving into the ideas that give rise to technologies like game-playing engines, handwriting recognition, and machine translation. Through hands-on projects, students gain exposure to the theory beh…

Free video8 videos, 13 hours

Enter your email and the official page opens. Phone is optional.