Introduction to Relational Databases
Coursera
Database management systems are a crucial part of most large-scale industry and open-source systems. This course will introduce you to important concepts of database systems and design. We will learn what relational databases are, what they are used for, the theory underlying their design, and how to query and modify a database using the declarative SQL language. At the end of the course, you will be able to: - Describe what relational databases are, and how they are used. - Master the Relational Database Model. - Demonstrate proficiency in formal relational database theory. - Demonstrate comprehensive SQL skills. - Apply database knowledge to practical problems. Software Requirements: Jupyter Notebooks, SQL
More resources on Relational Databases
Relational Database
Master SQL database concepts with freeCodeCamp's interactive Relational Database course. Build practical projects and gain valuable skills!
MySQL 8.0 Reference Manual
The official and most comprehensive documentation for MySQL. It's an invaluable resource for understanding all aspects of MySQL, from installation and configuration to advanced features, SQL syntax, and administration. While not a traditional 'book' in print, it functions as a highly detailed and authoritative reference available online for free.
use-the-index-luke.com
A practical guide to database indexing and query optimization, offering clear explanations of how indexes work, how to design them, and tutorials with SQL examples across major relational databases.
sqlzoo.net
SQLZoo.net is an interactive SQL learning resource offering free tutorials and hands-on practice with live databases. It provides step-by-step lessons and coding exercises on SQL topics (SELECT, JOIN, aggregation, etc.) with immediate feedback.
Introduction to Database Systems (15-445/645)
Learn relational database systems from Carnegie Mellon's Andy Pavlo. Explore core concepts and implementations!
DB-Fiddle
A browser-based playground where you paste schema and query SQL, choose a MySQL, MariaDB, PostgreSQL or SQLite version, run it, and share the result by link. Useful for reproducing query behaviour and comparing engines without local installs.