Databases
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Introduction
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
What does a database offer?
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Atomicity
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Consistency
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Isolation
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Durability
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Isolation levels
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Relational algebra and SQL
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Database normalisation
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Database migrations
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Database architecture
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
B-trees
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
B-tree structure
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
B-tree operations
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
B+ trees: the variant databases actually use
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Indexes
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Full-text search
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Query optimisation strategies
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Cost-based optimisation
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Join ordering
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Join algorithms
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Helping the optimiser
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Connection pooling
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Backup and recovery
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Logical backups
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Physical backups
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
WAL archiving
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Testing your backups
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Disaster recovery planning
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Monitoring and observability
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Concurrency control in SQLite and Postgres
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
How MVCC works in Postgres
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Handling conflicts
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
The cost of MVCC
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Scaling relational databases
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Vertical scaling
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Horizontal scaling
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
The practical reality
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Beyond relational: NoSQL databases
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
The CAP theorem in practice
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
When to consider NoSQL
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
The polyglot persistence approach
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Conclusion
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>
Further reading
<p>Learn the computer science foundations you need to jump start your career. Ten chapters covering all the career-essential topics. Become confident in computer architecture, networking, databases and much more. Perfect for beginners, self-taught developers, bootcamp graduates and anyone who wants to really understand how computers work.</p>