Database Systems: The Complete Book
by Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom · Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom
A comprehensive Stanford textbook spanning relational database design, the relational model and algebra, SQL, constraints, transactions, storage structures, indexing, and query execution and optimization. Readers learn both how to design and query databases and how database engines work internally.
This link may earn us a small commission at no extra cost to you. Affiliate disclosure
More resources on Database Fundamentals
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.
SQL Tutorial for Beginners
Four-hour freeCodeCamp course by Mike Dane using MySQL. Covers tables, keys, constraints, inserts and updates, basic queries, functions, wildcards, unions, joins, nested queries and triggers, plus ER diagrams, ending with a company-database project.
Databases and SQL for Data Science with Python
IBM course on Coursera teaching SQL for data work, from SELECT, INSERT, UPDATE and DELETE through filtering, grouping, subqueries, joins, views, stored procedures and transactions. Labs query cloud databases from Jupyter notebooks with Python, ending in a project analysing real-world datasets.
Introduction to Databases
In this course, you will be introduced to databases and explore the modern ways in which they are used. Learn to distinguish between different types of database management systems then practice basic creation and data selection with the use of Structured Query Language (SQL) commands. By the end of this course, you’ll be able to: - Demonstrate a working knowledge of the concepts and principles that underpin how databases work - Identify and explain the different types of core technology and management systems used in databases - Identify and interpret basic SQL statements and commands - Manipulate records in a database with the use of SQL statements and commands - Outline alternatives to SQL - and plan and design a simple relational database system You’ll also gain experience with the following: • Fundamental concepts in database • Basic MySQL syntax and commands • Database management systems • MySQL software • Relational databases
Database Management Systems
A widely used university textbook covering the relational model, SQL, ER modeling, normalization, file organization, indexing, query evaluation and optimization, transaction management, and concurrency control. Readers understand how relational database systems store, query, and protect data.