Free Database Tutorials: Master SQL, NoSQL & DB Design

Free PDFs for people who query and design data stores: SQL from the first SELECT to window functions, MySQL, SQL Server and Oracle guides, plus modelling and tuning material.

This shelf collects free database PDFs: SQL tutorials, MySQL, SQL Server and Oracle guides, data modelling material and the performance advice that separates a working query from a fast one. It suits students who are meeting relational theory for the first time, developers who write queries every day, and analysts who need a reference for a system they did not design.

What these database PDFs cover

• SQL from scratch: SELECT, joins, grouping, subqueries and window functions
• Engines and tools: MySQL, Microsoft SQL Server, Oracle and SQL*Plus
• Modelling and design: entity-relationship diagrams, normalisation and keys
• Administration: users, permissions, backups, indexes and query plans
• Data work: reporting queries, stored procedures and scripting basics

Where to start

Complete beginners should read Learning SQL, which takes a single sample database from the first SELECT to joins and views. If your project runs on MySQL, continue with Learning MySQL for installation, storage engines and tuning; on the Microsoft side, Learning Microsoft SQL Server covers management and T-SQL. Readers who only need to query an existing Oracle system can start with the compact hands-on tutorial or the Oracle/SQL course.

Languages, formats and prerequisites

Every document is a free download: a standard PDF with no registration, readable in any browser or PDF viewer. The tutorials assume no prior experience, but a little general computing knowledge helps when they explain servers and clients. You can follow the SQL chapters with a free local engine such as MySQL, MariaDB or SQLite, and most books say clearly where to install it; nothing in the shelf requires a commercial licence.

How to get the most out of this shelf

• Type every query and break it on purpose — reading an error message teaches more than reading a correct result.
• Keep the normalisation chapter open while you design; most slow systems are a schema problem, not a server problem.
• When you inherit an unfamiliar system, start from the modelling documents before touching the queries.
• Download the sample schema chapters and rebuild the tables yourself; most of the lesson is in the design, not the syntax.
• Write each query twice — once the obvious way, once with the indexes in mind — and compare the plans.
• Keep a notebook of the errors you meet and what caused them; the same three mistakes come back in every project.

Related shelves

These systems sit behind most applications, so the web programming shelf pairs well with this one, and the underlying engines are explained in operating systems.