After doing these courses, I feel confident creating professional visualizations and dashboards
Shoebur RahmanProcurement Specialist, Giz Bangladesh
课程介绍
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.
先修要求
课程大纲
课程大纲
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 经验值
- Connection URL100 经验值
- Setting up the connection100 经验值
- Executing Basic SQL Queries50 经验值
- Working with Statements100 经验值
- Data in a ResultSet100 经验值
- Handling Database Exceptions100 经验值
- Managing Database Connections50 经验值
- Connection management100 经验值
- Connection Pooling100 经验值
- Books report100 经验值
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
课程完成
