|
This course explains the concepts involved in enterprise databases and how JDBC is used to connect to DBMSs from Java applications.
Objectives:
After completing this course, students will be able to:
- Describe the concepts and architecture of database management systems (DBMSs), including relational database management systems (RDBMSs) and object database management systems (ODBMSs)
- Describe transaction management, including ACID principles and middle-tier distributed transaction handling
- Describe JDBC in terms of database connections, driver types, queries, and result sets
- Use regular SQL statements and prepared SQL statements in JDBC, and call stored procedures from JDBC
Topics:
- Database basics
- Transactions
- Relational databases
- Data model diagram conventions
- Object databases
- Relational versus object databases
- Relational/object translations
- JDBC architecture
- JDBC drivers
- JDBC connections
- JDBC statements
- Prepared statements
- JDBC result sets
- Obtaining database information
- Stored procedures
- Database naming via JNDI
- Distributed transactions
|
