Java 2 Enterprise Design: Enterprise Data and JDBC
Product Code: J51303 Time: 4 Hour(s) CEUs: .40

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

Outline:

  • 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

Features:

  • Activities that allow users to apply course concepts in an interactive questioning environment
  • A glossary
  • A Skill Assessment

Applicability:

This course is for anyone who is interested in learning more about designing enterprise systems with J2EE.

Prerequisites:

Java 2 Enterprise Design: Enterprise FoundationsJava 2 Enterprise Design: Modeling Components with JavaBeans

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.


Copyright © 2004 eLearningDepot.com. All rights reserved.