SQL and Databases for IT Professionals: Learn Queries, Design, Backups, Performance and Administration with PostgreSQL, , (Paperback)
SQL and Databases for IT Professionals: Learn Queries, Design, Backups, Performance and Administration with PostgreSQL, , (Paperback)
Hero image 0 of SQL and Databases for IT Professionals: Learn Queries, Design, Backups, Performance and Administration with PostgreSQL, , (Paperback), 0 of 1

SQL and Databases for IT Professionals: Learn Queries, Design, Backups, Performance and Administration with PostgreSQL, , (Paperback)

(No ratings yet)

Key item features

  • SQL and Databases for IT Professionals: Learn Queries, Design, Backups, Performance and Administration with PostgreSQL, , (Paperback)
  • Author: Piyush Pandit
  • ISBN: 9798143224476
  • Format: Paperback
  • Publication Date: 2026-11-16
  • Page Count: 200

Specs

Publication date, November, 2026Author, Piyush PanditBook format, PaperbackGenre, Computing & InternetPages, 200Age group, Adult

About this item

Product details

SQL and Databases for IT Professionals teaches you the database skills that almost every IT job quietly expects, in plain English and one practical step at a time.

Your ticketing system, your monitoring tool, your web applications and your backups all keep their data in databases. When something breaks, someone has to read the data, find the cause and put things right. This book shows you how to be that person, even if you have never written a query before.

You follow Maya, a junior support analyst at an outdoor-gear retailer, as she learns from a patient senior administrator. Every chapter builds on one small sample database that you can set up on a laptop in minutes using free tools, so you practise on real queries instead of just reading about them.

INSIDE, YOU WILL LEARN HOW TO:

  • Build a safe lab with SQLite, PostgreSQL and MySQL, and load the sample data.
  • Write confident queries with SELECT, WHERE, joins, subqueries, common table expressions and window functions.
  • Understand NULL, data types and transactions so your results are correct.
  • Design tables with keys, constraints and normalization.
  • Create indexes, read query plans and fix slow queries step by step.
  • Use views, functions, procedures and triggers wisely.
  • Secure a database with least privilege and prevent SQL injection.
  • Back up, restore and test recovery, and understand replication and failover.
  • Monitor and maintain a database, and work with it in containers, cloud services and scripts.
  • Handle real incidents with a calm troubleshooting playbook.

Each chapter ends with hands-on exercises and worked answers. The appendices give you a SQL quick reference, a cheat sheet of differences between database systems, and a full glossary.

WRITTEN FOR: Help desk and support staff, system administrators, junior developers, career changers and anyone preparing for a technical role who wants a practical, honest guide.

All exercises are lab-based and defensive. Start with your first query today.

  • SQL and Databases for IT Professionals: Learn Queries, Design, Backups, Performance and Administration with PostgreSQL, , (Paperback)
  • Author: Piyush Pandit
  • ISBN: 9798143224476
  • Format: Paperback
  • Publication Date: 2026-11-16
  • Page Count: 200
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

Publication date

November, 2026

Author

Piyush Pandit

Book format

Paperback

Genre

Computing & Internet

Warranty

Warranty information

Please be aware that the warranty terms on items offered for sale by third party Marketplace sellers may differ from those displayed in this section (if any). To confirm warranty terms on an item offered for sale by a third party Marketplace seller, please use the 'Contact seller' feature on the third party Marketplace seller's information page and request the item's warranty terms prior to purchase.

Customer ratings & reviews

0 out of 5 stars
0 ratings|0 reviews
This item does not have any reviews yet
Current price is $9.99
Price when purchased online
  • Free 90-day returns

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 Fri, Nov 27
Sold and shipped by Walmart.com
Free 90-day returns
This item is gift eligible

More seller options (1)

Starting from $10.63
walmart plus

Try 30 days of Walmart+ for just $1!

T&C apply.