|
|
 |
|
|
| |
|
|
| |
| |
| Database Programming in Java |
| Duration: 2 days |
|
|
|
- Application developers
- Programmers
- System designers
|
|
Knowledge of database
principles is preferred but not required. Experience with the Java programming language is required |
|
|
| Description |
This course trains developers and designers in the art and science of database application development using the application programming interface (API) provided by Java, JDBC 2.0. 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 course consists of 50% instruction and 50% lab exercises. |
|
| Objectives |
This 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 2.0 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
|
|
| Course Outline |
Fundamentals of Databases
- Concepts
- Various models of data storage
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
Relational Databases
- The relational model of data storage
- Relational algebra
- Normalization
- 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
- Datasources
- Transaction processing: Commit, Rollback, etc.
- Connection Pooling
| |
|
|
Process
and
Featured Courses