Head office, Rana Pratap Bagh, Delhi011 2721 1512+91 97116 99511

Programming and web15 books

SQL Practice Workbook

Learn SQL by querying a school database, step by step

  • Free ebook
  • Beginner
  • 29 pages
  • 128 KB
  • PDF, English
Download free PDFRead online

Free to download, read, print and share. Not for sale.

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.

Contents

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

At the end of the book

  • Practice questionsTo check what you have learnt, with the answers after them.
  • GlossaryThe key words of the book, each explained in one sentence.
  • Easy EnglishShort sentences and everyday words, with each new word explained the first time.

Reading, printing and sharing

  1. On a phone or computerTap Read online to open the book in your browser, or Download to keep it and read it without the internet.
  2. To printThe 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 shareSend 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.

More from this family

All 15 books in Programming and web

The library

100 free ebooks in 8 families

Browse the whole library
WhatsApp us