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

Programming and web15 books

Databases and SQL Study Book

The complete study notes, practice questions and glossary for Databases and SQL

  • Study book
  • Beginner
  • 29 pages
  • 136 KB
  • PDF, English
Download free PDFRead online

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

About this ebook

What you will learn

Understand how a database management system stores data in related tables, and write MySQL 8 queries to create tables, add, read, change and summarise data, join tables and design them well.

Who it is for

Students learning databases and SQL.

Contents

  1. Databases and the DBMS
  2. Data types, NULL and keys
  3. Creating tables and inserting data
  4. Reading data: SELECT, WHERE and ORDER BY
  5. Changing data: UPDATE, DELETE and transactions
  6. Aggregate functions and GROUP BY
  7. JOINs and normalisation

At the end of the book

  • Practice questionsTo check what you have learnt.
  • 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