Intermediate Notes - Page 3

Inside the DBMS: Components and How a Query Flows

A DBMS is built from a query processor, a storage manager, a transaction manager and a recovery manager. Following one query through all of them is th...

DBMS

Centralised and Distributed Databases

A centralised database keeps all data at one site; a distributed database spreads it across several. The choice changes availability, performance, com...

DBMS

Client Server Architecture and Database Servers

In client server architecture the database server owns the data and answers requests, while clients ask questions. Understanding what the server keeps...

DBMS

Logical and Physical Data Independence

Data independence is the ability to change a schema at one level without changing the level above. Physical independence is easy to achieve; logical i...

Java

Test Doubles and Mocking Concepts in Java

A test double stands in for a real dependency so a unit can be tested in isolation, quickly and predictably.

Java

Unit Testing Fundamentals in Java

A unit test runs a small piece of code with known input and asserts the result, automatically and repeatedly.

Java

JDBC Transactions and Batch Operations

A transaction makes several statements succeed or fail together, and batching turns many round trips into one.

Java

PreparedStatement and SQL Injection Prevention in Java

Concatenating input into SQL lets a caller rewrite your query. Bound parameters make that structurally impossible.

Java

JDBC Fundamentals in Java

JDBC is the standard API for talking to a relational database from Java: a connection, a statement, and a result set.

Java

The Java HTTP Client

Since Java 11 the platform includes a modern HTTP client with synchronous and asynchronous requests and HTTP/2 support.

Java

Java Networking Fundamentals: URI, URL and Sockets

Addresses, sockets and streams. Underneath every network library in Java is a socket carrying bytes.

Java

Thread Lifecycle in Java

A thread moves through six states, and knowing which one it is in is the first step in diagnosing any hang.