Canada IT Courses
ExitCertified US




ExitCertified - Excellence in IT Certified Education
 
IT education classes
IT training feature sheet
 
   
 
start > courses and registration > training feature sheet
Database Application Programming with Java Technology :: [SL-330]
 
 
 
 
sun microsystems certified training   this course works with savings passes
 
code. SL-330   length. 4 days
type. Instructor-Led   partner. Sun Microsystems
price.
$2,000 :: contact for GSA GOV.
 
 
Database Application Programming With Java Technology is a focused-technology course that provides students with a hands-on approach to developing database applications using Java technology and the JDBC application programming interface (API). Students will learn to use the features of the JDBC 1.0 API, and will learn about the new features added in JDBC 2.0. Note - Lab exercises currently include only JDBC 1.0 features. Students will also learn how to map an object-oriented design to a relational database, and how to design a multi-tier database application.
 
course schedule  
 
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.
   
Request course date Request on site training
 
who can benefit
  
 
Programmers and database administrators interested in developing enterprise database applications, and those who have taken SL-285: Java Programming Workshop and want to learn more about the JDBC API.
 
prerequisites
  
 

Design applications using object-oriented analysis and design
Develop applications using the Java programming language
Use SQL to retrieve and manipulate data in a relational database
 
skills gained
  
 

Design a multi-tier database application architecture
Create a multi-tier database application using the Java programming language and the JDBC 1.0 API
Map an object-oriented design to a relational database
Explain the features added to the JDBC 2.0 API


 
course content details  
 


  Module 1: JDBC Overview

Describe the purpose of the JDBC API
Explain how to use the JDBC API to connect an application using Java technology to a database
Define the different components of the JDBC architecture
Select the correct kind of JDBC driver for a given application architecture
Describe the uniform resource locator (URL) syntax used to identify a database


  Module 2: Using JDBC

Select an appropriate method to register a JDBC driver
Establish a database connection with the registered JDBC driver
Query a database using the JDBC connection
Select the appropriate type of statement given the data query requirements
Manipulate data in the database using a JDBC connection
Process the results of a query
Shut down the appropriate objects after a JDBC process is complete


  Module 3: OOAD and Database Design

Describe the purpose of an object ID
Describe two ways to create an object ID
Given a class diagram, map objects to a relational database
Given a class diagram, map object relationships in the database
Define the use of a persistence layer in a database application


  Module 4: JDBC Advanced Topics

Write code to catch exceptions in JDBC processes
View metadata for a table or result set
Create transactions
Use concurrency control to determine how data is read and changed


  Module 5: JDBC 2.0 Core Features

List the new features in the JDBC 2.0 Core API
Explain how to scroll forward and backward within a result set
Understand how to use a scroll cursor to process the results of a query
Use a scroll cursor to manipulate data in the database
Describe how to perform batch processing with statements
List the new data types added to JDBC 2.0


  Module 6: JDBC 2.0 Standard Extensions

List the features in the JDBC 2.0 Standard Extension API
Understand how to use Java Naming and Directory Interface (JNDI) functionality to reduce dependence of a JDBC program on a particular driver
Learn how connection pooling is used to connect an application to a database
Understand how distributed transactions work
Explain how to use row sets to encapsulate rows for use with the JavaBeans component model


  Module 7: Row Set Implementation

Explain how to use the CachedRowSet implementation
Modify a RowSetReader or RowSetWriter
Understand the benefit provided by using the CachedRowSet


  Module 8: JDBC and Application Architecture

Define the components in a multi-tier application
Explain which components belong to each tier in a multi-tier application
Explain where JDBC components should be installed in a multi-tier application
Describe when to use a two-tier application architecture in a database application
Describe when to use a three-tier application architecture
Describe when to use an n-tier application architecture


  Appendix A: Database Basics

Define database and database management system (DBMS)
Identify three major DBMS categories
Describe major characteristics of relational databases
Describe guidelines for partitioning work into transactions
Explain the importance of SQL
Query a database using the SQL statement SELECT
Modify database contents using the SQL statements INSERT, UPDATE, and DELETE


  Appendix B: Using SQLJ

Explain how SQLJ works
Explain the purpose of the SQLJ Translator
Code database queries with SQLJ
Code database manipulation with SQLJ



 
Sun Microsystems Training Special

Save on Sun Microsystems Training



find a course
 
phone us
 
view course schedule





Sun Microsystems Training Special

 
go to top
Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education
© 2008 ExitCertified. All rights reserved.
terms of use and disclaimer :: privacy policy :: webmaster :: link to us
   
Sacramento Training :: 916.669.3970 | Las Vegas Training :: 1.800.803.EXIT (3948) | San Francisco Training :: 415.975.3948 | San Jose Training :: 408.288.EXIT (3948)
Phoenix, Arizona Training | Los Angeles, California Training | San Diego, California Training | Broomfield, Colorado Training | Fort Lauderdale, Florida Training
Tampa, Florida Training | Atlanta, Georgia | Downers Grove, Illinois | Kansas City, Kansas Training | Portland, Maine Training | Baltimore, Maryland Training | Burlington, Massachusetts Training
Troy, Detroit, Michigan Training | Minneapolis, Minesota Training | St. Louis, Missouri Training | Omaha, Nebraska Training | Edison, New Jersey Training | New York City, New York Training
Raleigh, North Carolina Training | Columbus, Ohio Training | Philadelphia, Pennsylvania Training | Nashville, Tennessee Training | Dallas, Texas Training
Houston, Texas Training | Hampton, Virginia Training | Madison, Wisconsin Training | Seattle, Washington Training

ExitCertified is a global provider of authorized technology training. Some of our popular course topic searches include:

Java Training | J2EE Training | JSP Training | Java Courses | Servlets Training | EJB Training | Struts Training | Networking Courses | Solaris Training
Red Hat Training | SUSE Training | XML Training | Oracle SQL | Oracle PL/SQL | DBA Training | DBA Certification | Oracle Certification
RedHat Training | Solaris Certification | Java Certification | Veritas Certification | PeopleSoft Training | 11g Training | 11g Certification
RedHat Courses | SQL Training | 10g Training | 9i Training | Application Development Training | Certified Training | Corporate Training
Government Training | Course Catalogue | Training Schedule | Certification Training | Project Management Training | Linux Training
Solaris 10 Training | Unix Training | NetBackup Training | Virus Protection Courses | Education Technology Newsletter | zSeries Training
s/390 Training | iSeries Training | DB2 Training | OS/400 Training | AIX Training | Rational Courses | PMI Training | Project Management Training
SeeBeyond Training | Java Composite Application Platform (JCAPS) Training | MySQL Training | MySQL Database Course | Hyperion Training | Fusion Middleware