Total Time: 4 hour(s)

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

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

Technical Requirements: 
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.