This course takes knowledge of the Java programming language and knowledge of a SQL database system and combines this experience via JDBC. When complete, the student will be well-versed in all aspects of Java database development, including advanced concepts such as updating results sets, large database objects (CLOBs and BLOBs), and invoking stored procedures.
Prerequisites: Knowledge of the Java programming language and object oriented fundamentals. Knowledge of an SQL database system.
Duration: 2 days
Price: $750
JDBC Basics
- The JDBC connectivity model
- JDBC and other J2EE technologies
- Relational databases and SQL
- Object-relational mapping
- Connecting to a database
- The DriverManager class
- The Connection class
|
Basic Database Access
- SQL summary
- Using the Statement class
- Using the PreparedStatement class
- Using the ResultSet class
- SQL datatypes and Java datatypes
- SQL NULL and Java null
- SQL exceptions
|
Transactions
- Inserts, updates, and deletes
- Transaction isolation levels
- Performance issues
|
Advanced Topics
- Scrollable result sets
- Updateable result sets
- Batch processing
- Advanced datatypes
- Using ResultSetMetaData
- Using DatabaseMetaData
- Connection pooling
- Transaction monitors and distributed transactions
|
Register Now
This page is printer friendly.
