A complete guide to MySQL in Java — JDBC connections, HikariCP connection pooling, CRUD operations with PreparedStatement, transactions, batch processing, Spring Boot JPA integration, and SQL security best practices.
A complete guide to Microsoft SQL Server in Java — JDBC connections with mssql-jdbc, HikariCP, CRUD operations, stored procedures, Windows Authentication, transactions with isolation levels, Spring Boot JPA, and SQL Server-specific features.
A complete guide to Oracle Database in Java — JDBC Thin and OCI connections, Sequences and IDENTITY, PL/SQL stored procedures, REF CURSORs, CLOB/BLOB, HikariCP, Spring Boot JPA with the Oracle dialect, and differences from MySQL and SQL Server.
A complete guide to PostgreSQL in Java — JDBC connections, rich data types (UUID, JSONB, Arrays, Enums), UPSERT with ON CONFLICT, LISTEN/NOTIFY for real-time notifications, CopyManager for bulk imports, Spring Boot JPA, and PostgreSQL's unique features.