Java 2 Enterprise Design Series: Enterprise Data and JDBC
Product Code: j51303 Time: 3.0 hour(s) CEUs: Available

Summary:

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

Technical Requirements:

200MHz Pentium with 32MB Ram. 800 x 600 minimum screen resolution. Windows 98, NT, 2000, or XP. 56K minimum connection speed, broadband (256 kbps or greater) connection recommended. Internet Explorer 5.0 or higher required. Flash Player 7.0 or higher required. JavaScript must be enabled. Netscape, Firefox and AOL browsers not supported.

Copyright © 2006 MindLeaders. All rights reserved.