SQL Practice Workbook

About this ebook

What you will learn

Build a small school database and learn SQL by asking it real questions. You will write queries that filter, sort, count and join tables, change data safely and design tables well, then test yourself with 50 practice queries and their answers.

Who it is for

Students learning databases.

Chapters

Contents

1. Chapter 1: Databases, tables and keys
2. Chapter 2: Building the school database
3. Chapter 3: Asking questions with SELECT
4. Chapter 4: Better filters: LIKE, IN, BETWEEN and NULL
5. Chapter 5: Counting and summarising with GROUP BY
6. Chapter 6: Joining tables
7. Chapter 7: Queries inside queries
8. Chapter 8: Changing data safely
9. Chapter 9: Constraints, indexes and views
10. Chapter 10: Normalisation: designing tables well

Inside

At the end of the book

• Practice questions. To check what you have learnt, with the answers after them.
• Glossary. The key words of the book, each explained in one sentence.
• Easy English. Short sentences and everyday words, with each new word explained the first time.

How to use it

Reading, printing and sharing

1. On a phone or computer. Tap Read online to open the book in your browser, or Download to keep it and read it without the internet.
2. To print. The pages are A5, half the size of A4. Choose two pages per sheet in the print settings to fit two pages on each A4 sheet.
3. To share. Send the link to this page, or the PDF itself, to friends, classmates or students. The book is free for everyone.

Courses

Courses this book supports

Students of this course also find the book in the student portal, with the other ebooks for their course.

• Web development, networking, databases and IT security (class 10 pass)Programming & Web Development · About the course