Introduction to SQL
Bobby Iliev
An open source guide for beginners. You learn to create tables, insert and update data, filter with WHERE, sort and group results, join tables, and back up a MySQL database.
Loading the book...
Keep reading
-
Next in this topic
Structured Query LanguageA vendor-neutral course on standard SQL. It starts with the relational model and moves through CREATE TABLE, data types, SELECT, joins, grouping, NULL handling, transactions, and views.
Verified PDF · Secure download - Microsoft SQL Server Notes for Professionals
More than 280 pages of T-SQL tips. Topics include data types, common table expressions, window functions, JSON and XML handling, indexes, stored procedures, triggers, and backup and restore.
Verified PDF · Secure download - Oracle Database Notes for Professionals
A hands-on reference for SQL in Oracle. It covers joins, hierarchical queries, string and date functions, sequences, partitioning, indexes, and the basics of PL/SQL.
Verified PDF · Secure download - Database Design, 2nd Edition
An open textbook on designing relational databases. It teaches data modeling, entity-relationship diagrams, integrity rules, functional dependencies, and normalization, and closes with SQL exercises.
Verified PDF · Secure download - Relational Databases and Microsoft Access 365
Learn relational design by building real databases in Access. The book covers tables and keys, queries, forms and reports, entity-relationship modeling, mapping ERDs to tables, and normalization.
Verified PDF · Secure download
