After doing these courses, I feel confident creating professional visualizations and dashboards
Shoebur RahmanProcurement Specialist, Giz Bangladesh
Course Description
Learn how Java applications work with PostgreSQL databases using JDBC. You will begin by setting up database connections and running queries, then proceed to creating secure, parameterized queries with prepared statements to avoid SQL injection. The course covers techniques like filtering, sorting, and pagination, followed by multi-table queries with joins and subqueries. You will also explore aggregations and grouping operations, implement transaction management to ensure data consistency, and utilize batch processing to efficiently handle multiple operations.
Prerequisites
Curriculum
Course outline
1
Connecting Java to PostgreSQL
Connect Java applications to PostgreSQL using JDBC. You'll execute queries, process results, and manage connections with pooling and proper resource handling.
- Setting Up JDBC for PostgreSQL50 XP
- Connection URL100 XP
- Setting up the connection100 XP
- Executing Basic SQL Queries50 XP
- Working with Statements100 XP
- Data in a ResultSet100 XP
- Handling Database Exceptions100 XP
- Managing Database Connections50 XP
- Connection management100 XP
- Connection Pooling100 XP
- Books report100 XP
2
Advanced Query Techniques
Build secure queries with prepared statements to prevent SQL injection. You'll filter and sort data, implement joins and subqueries, and add pagination for efficient retrieval.
3
Advanced Data Retrieval and Management
Aggregate data using COUNT, SUM, AVG, GROUP BY, and HAVING. You'll manage transactions for consistency, optimize operations with batch processing, and handle large objects using streaming techniques.
J
Querying a PostgreSQL Database in Java
Course
Complete
