Duration: 2 days
Course code: SS-JAV-016
- Application developers
- System designers
Knowledge of database principles is preferred but not required. Experience with the Java programming language is required
The JDBC training course teaches developers and designers the art and science of database application development using the application programming interface (API) provided by Java, JDBC. In this course, attendees will learn about installing and managing database drivers in Java, using the DDL and DML functionality of JDBC, formulating simple and complex queries, using compiled queries and stored procedures, handling and formatting the results of queries and transaction management primitives. Extensive hands-on lab exercises reinforce various concepts and techniques as they are introduced.
While this is not a full course on database systems, fundamental database concepts are covered briefly with a special emphasis on relational databases. An overview of the Structured Query Language (SQL) will be provided.
The JDBC training course consists of 50% instruction and 50% lab exercises.
The JDBC training course teaches a developer to use JDBC to design and implement Java database solutions. On completion of this course, students will be able to:
- Master the JDBC API
- Use various database drivers, including the JDBC-ODBC bridge
- Use the DDL features to define relational tables, and update data
- Formulate and execute complex queries in SQL using the API
- Use the MetaData facilities to parse and format the results
Outline for JDBC Training Course
Fundamentals of Databases
- Various models of data storage
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- The relational model of data storage
- Relational algebra
- Structured Query Language (SQL)
Database Programming in Java using JDBC
- JDBC concepts
- Database drivers
- Connection objects
- Defining and creating databases and tables
- Updating database records
- Query formulation using Statements objects
- Using compiled queries and stored procedures
- Using the ResultSet and MetaData objects with query results
- Transaction processing: Commit, Rollback, etc.
- Connection Pooling