Okładka książki
Książka po angielsku
DATABASE SYSTEMS IN PRACTICE
Opis książki
Knowing how to write a query is only the beginning. Knowing how a reliable database actually works is what turns knowledge into a practical skill.Database Systems in Practice takes you beyond isolated commands and introduces the complete world behind modern relational databases-from organizing information and creating reliable schemas to writing queries, managing transactions, improving performance, protecting access, recovering from failure, and keeping a database environment healthy.Written with beginners and developing professionals in mind, this practical guide breaks complex concepts into clear explanations, realistic examples, structured exercises, and repeatable workflows.Inside, you'll learn how to: - Understand how a DBMS works beyond tables and queriesBR- Build relational structures using keys, relationships, constraints, and normalizationBR- Write accurate queries using joins, aggregation, subqueries, CTEs, and other essential techniquesBR- Work safely with INSERT, UPDATE, DELETE, transactions, and NULL valuesBR- Understand ACID principles, locking, blocking, isolation levels, and concurrencyBR- Read execution plans and make evidence-based indexing and optimization decisionsBR- Apply authentication, authorization, least privilege, encryption, auditing, and injection defensesBR- Plan and test backups, restores, replication, point-in-time recovery, and high availabilityBR- Monitor logs, alerts, capacity, failed jobs, and common operational problemsBR- Troubleshoot systematically instead of changing configurations by guessworkRather than teaching each topic in isolation, the book follows Northstar Outfitters, a fictional business whose evolving environment lets you see how requirements connect to schemas, queries, permissions, indexing, recovery, and day-to-day management.Examples primarily use PostgreSQL-compatible syntax while explaining important differences found in MySQL, Microsoft SQL Server, Oracle Database, and SQLite.Whether you're opening a database console for the first time, moving from software development into a data-focused role, preparing for DBA responsibilities, or strengthening your technical foundation, this book gives you a practical framework you can continue using long after the final chapter.Stop memorizing disconnected commands. Start understanding how databases work as complete, living environments.The promises in that description closely match the manuscript's stated learning objectives, including relational modeling, multi-table querying, transactions, execution-plan interpretation, least-privilege access, recovery techniques, and health reviews.
- ISBN-13
- 9798175248693
- Język
- Angielski
- Waga
- 218 g
- Oprawa
- Miękka
- Wydawnictwo
- Independently published
- Liczba stron
- 172
- Rok wydania
- 2026
- Kategoria
- Nauka, technika i medycyna
Termin wysyłki jest obecnie niedostępny.
Wszystkie podane terminy wysyłki liczymy w dniach roboczych.