Your hands-on guide to programming databases with SQL!

SQL The Practical Guide

written by Kerem Koseoglu

Print edition E-book Bundle

$49.95

Available

$44.99

Available

$59.99

Available

490 pages, 2025, Print edition paperback
ISBN 978-1-4932-2679-5 490 pages, 2025
E-book formats: EPUB, PDF, online
ISBN 978-1-4932-2680-1 490 pages, 2025, Print edition paperback
E-book formats: EPUB, PDF, online
ISBN 978-1-4932-2681-8

Whether you’re managing large datasets or writing your first query, build your SQL skills with this practical guide! Learn the basic elements of relational databases and walk through the syntax, features, and applications of SQL. Then dive into the sublanguages of SQL and apply them for tasks such as modifying tables and querying data. See SQL in action with an example PostgreSQL database and detailed code samples from real-world applications!

Master SQL programming for database management and manipulation
Learn to use the five SQL sublanguages: DDL, DML, TCL, DQL, and DCL
Define schemas and tables; modify and query data; and configure database authorizations

About the Book About the E-book 490 pages, paperback, 1.45 in. Reference book format 7 x 10 in. Printed black and white on 50# offset paper from sustainable sources. Reader-friendly serif font (TheAntiquaB 9.5 Pt.). One-column layout. E-book in full color. PDF (12 MB) and EPUB (11MB) files for download, DRM-free with personalized digital watermark. Copy and paste, bookmarks, and print-out permitted. Table of contents, in-text references, and index fully linked. Including online book edition in dedicated reader application.

In this book, you’ll learn about:

Relational Database Elements

Understand the fundamentals of relational databases and schemas. Learn the elements of database structures, from tables to views to keys. Then review more advanced concepts like normalization, stored procedures, triggers, and authorization.
Setting Up Your Environment

Follow click-by-click instructions to install and set up a local PostgreSQL database and a pgAdmin or Visual Studio Code IDE. See a SQL demo in action in your environment and experiment with code samples.
SQL Sublanguages

Use the sublanguages of SQL for your daily tasks. Start by creating and altering database objects. Insert, update, and delete data in tables and then modify multiple tables together. Query data from single or combined tables and limit data access using authorizations.

Highlights include:

Databases
Schemas
Tables
Views
Keys
PostgreSQL
Data definition language (DDL)
Data manipulation language (DML)
Transaction control language (TCL)
Data query language (DQL)
Data control language (DCL)
Entity-relationship diagrams (ERD)

Reading Sample

Table of Contents

Dr. Kerem Koseoglu is a seasoned software engineer, author, and educator with extensive experience in global software development projects.

more >

Product supplements

Here you can find downloadable supplements for the product.

Supplements list >

SQL The Practical Guide

In this book, you’ll learn about:

Relational Database Elements

Setting Up Your Environment

SQL Sublanguages

Highlights include:

Product supplements

You may also like:

Python 3 –
The Comprehensive Guide

Getting Started with Python

AI-Assisted Coding –
The Practical Guide for Software Development

SQL The Practical Guide

In this book, you’ll learn about:

Relational Database Elements

Setting Up Your Environment

SQL Sublanguages

Highlights include:

Product supplements

You may also like:

Python 3 – The Comprehensive Guide

Getting Started with Python

AI-Assisted Coding – The Practical Guide for Software Development

Python 3 –
The Comprehensive Guide

AI-Assisted Coding –
The Practical Guide for Software Development