Książki po angielsku · odkrywaj nowe historie

Obsługa klienta: kontakt@bookbuy.pl

Znajdź książkę po tytule, autorze lub numerze ISBN.

Okładka książki

Książka po angielsku

DATABASE SYSTEMS IN PRACTICE

Thom Haagenrud

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

Termin wysyłki jest obecnie niedostępny.

Wszystkie podane terminy wysyłki liczymy w dniach roboczych.
Cena brutto 141,57 zł
Zadaj pytanie o książkę Wróć do katalogu

Poznaj twórczość autora

Inne książki tego samego autora

12 książek

Odkryj kolejną lekturę

Podobne książki

12 książek