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.