SQLite from Scratch: SQL for beginners tutorial Python database programming relational data modeling joins subqueries an, (Paperback)

SQLite from Scratch: SQL for beginners tutorial Python database programming relational data modeling joins subqueries an, (Paperback)

(No ratings yet)

Key item features

  • SQLite from Scratch: SQL for beginners tutorial Python database programming relational data modeling joins subqueries an, (Paperback)
  • Author: Frederick Kensington
  • ISBN: 9798142912848
  • Format: Paperback
  • Publication Date: 2026-11-15
  • Page Count: 404

Specs

Author, Frederick KensingtonBook format, PaperbackGenre, Computing & InternetPages, 404Age group, AdultSeries title, No Series

About this item

Product details

You don't need a complicated database server or an expensive development setup to start building applications that work with real data. Sometimes, all you need is a single file and the right knowledge to use it.

That's where SQLite comes in.

SQLite is used in mobile apps, desktop software, browsers, websites, and countless other applications. It is lightweight, reliable, and remarkably capable. Yet knowing that SQLite exists is very different from knowing how to use it effectively in your own projects.

SQLite from Scratch bridges that gap with a practical, step-by-step approach that takes you from your first database to a complete working application.

Rather than leaving you with a collection of SQL commands to memorize, this book shows you how the different pieces fit together. You'll learn how to create databases, design well-structured tables, write useful queries, connect SQLite to Python, and build applications that store and manage information reliably.

As you progress, you'll also discover how to improve query performance, protect important data, handle transactions, manage database changes, and avoid common mistakes that can cause problems in real projects.

What You'll Learn

Inside this hands-on manual, you'll discover how to:

  • Get Started with SQLite: Set up your workspace, create your first database, and understand how SQLite works without managing a separate database server.
  • Write Practical SQL Queries: Create tables, insert and update records, filter results, sort information, and summarize data.
  • Design Better Database Schemas: Work with primary keys, foreign keys, constraints, relationships, and data types to build organized databases.
  • Work with Related Data: Use JOINs, subqueries, common table expressions, and views to retrieve information from multiple tables.
  • Connect SQLite with Python: Use Python's sqlite3 module, write parameterized queries, and build a functional command-line application.
  • Use SQLite in Mobile and Desktop Applications: Understand local storage, offline-first design, application settings, backups, imports, and exports.
  • Improve Database Performance: Learn how indexes work, read query plans, identify slow queries, and make informed performance improvements.
  • Protect and Maintain Your Data: Understand transactions, ACID properties, journaling modes, Write-Ahead Logging (WAL), database migrations, and maintenance.
  • Build a Complete Project: Bring your knowledge together in a capstone project that takes you through planning, implementation, testing, and shipping a database-powered application.
Who Is This Book For?

This book is designed for:

  • Complete Beginners who want a clear, practical introduction to SQLite and relational databases.
  • Students and Computer Science Learners who want to strengthen their understanding of SQL, database d
  • SQLite from Scratch: SQL for beginners tutorial Python database programming relational data modeling joins subqueries an, (Paperback)
  • Author: Frederick Kensington
  • ISBN: 9798142912848
  • Format: Paperback
  • Publication Date: 2026-11-15
  • Page Count: 404
info:
We aim to show you accurate product information. Manufacturers, suppliers and others provide what you see here, and we have not verified it.  

Specifications

Author

Frederick Kensington

Book format

Paperback

Genre

Computing & Internet

Pages

404

Customer ratings & reviews

0 out of 5 stars
0 ratings|0 reviews
This item does not have any reviews yet
Current price is $30.00
Price when purchased online

How do you want your item?

Try 30 days for just $1! Choose a plan at checkout.
How do you want your item?
Ships to
Arrives by Tue, Nov 24
Sold and shipped by Walmart.com
This item is gift eligible
walmart plus

Try 30 days of Walmart+ for just $1!

T&C apply.