MP9005: Web Development - Enterprise Data and JDBC > Java 2 Enterprise Design

This course explains the concepts involved in enterprise databases and how JDBC is used to connect to DBMSs from Java applications. 

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

Objectives:
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

Duration:
4 Hours