|
|
 |
|
|
| |
|
|
| |
| |
| Java Programming with Oracle JDeveloper |
| 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 |
|
|
| 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