User name:
Password:
 

 

Copyright © 2006.
cisco-certificatiom.co.uk
All Rights Reserved
Java 2 Enterprise Design Series: Enterprise Data and JDBC
Product Code: j51303 Time: 4.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:

  • 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.

Copyright � 2006 Webteks. All rights reserved.