 |
Beginning Java Application Development
Introduction to Object-Oriented (OO) Analysis and Design using the Unified Modeling Language (UML)
Beginning JSP & Servlets
XML Programming Using Java training
Beginning JSP & Servlets
Java Development for Secure Systems

Please contact us
for GSA pricing.

Contract #
GS-35F-0307T
Complimentary Java Training Seminar
Organizations in the Atlanta, Georgia area are encouraged
to contact Accelebrate® about having a complimentary, one-hour Java seminar
delivered for their developers. Contact
us today for more information.

Recent Training Venues
Accelebrate has recently trained for clients in the following cities:
- Huntsville, Alabama
- Montgomery / Birmingham, Alabama
- Anchorage, Alaska
- Calgary, Alberta
- Phoenix, Arizona
- Fayetteville / Little Rock, Arkansas
- Oakland / San Jose / San Francisco, California
- Oceanside / San Diego, California
- Pasadena / Orange County / Los Angeles, California
- San Bernardino / Riverside, California
- Boulder / Colorado Springs / Denver, Colorado
- Washington, DC
- Wilmington, Delaware
- Manchester / London, England
- DeLand / Orlando, Florida
- Fort Lauderdale / Miami, Florida
- Gainesville / Jacksonville, Florida
- Saint Petersburg / Tampa, Florida
- Titusville & Melbourne, Florida
- Alpharetta & Atlanta, Georgia
- Augusta & Savannah, Georgia
- Macon & Columbus, Georgia
- Bloomington, Illinois
- Chicago, Illinois
- Indianapolis, Indiana
- Cedar Rapids / Des Moines, Iowa
- Dublin, Ireland
- Kingston, Jamaica
- Wichita, Kansas
- Paducah / Lexington / Louisville, Kentucky
- Baton Rouge, Louisiana
- Valletta, Malta
- Hagerstown & Frederick, Maryland
- Greenbelt / Silver Spring / Baltimore, Maryland
- Boston / Cambridge, Massachusetts
- Hartford, Connecticut / Springfield, Massachusetts
- Taunton, Massachusetts / Providence, Rhode Island
- Ann Arbor / Farmington Hills / Detroit, Michigan
- Grand Rapids, Michigan
- Lansing, Michigan
- Saginaw / Flint / Bay City / Midland, Michigan
- Saint Paul / Minneapolis, Minnesota
- Jackson, Mississippi
- Gulfport / Biloxi, Mississippi
- Whiteman Air Force Base / Kansas City, Missouri
- Reno and Las Vegas, Nevada
- Santa Fe / Albuquerque, New Mexico
- Newark, New Jersey
- Princeton, New Jersey & Philadelphia, Pennsylvania
- White Plains / New York City, New York
- Charlotte, North Carolina
- Durham / Raleigh, North Carolina
- Bowling Green / Toledo, Ohio
- Cincinnati, Ohio
- Cleveland & Columbus, Ohio
- Tulsa / Oklahoma City, Oklahoma
- Toronto, Ontario
- Portland, Oregon
- Pittsburgh, Pennsylvania
- Providence, Rhode Island
- Edinburgh / Glasgow, Scotland
- Columbia & Charleston, South Carolina
- Memphis / Jackson / Nashville, Tennessee
- College Station and Houston, Texas
- El Paso, Texas / Ciudad Juarez, Mexico
- San Antonio / Austin, Texas
- Wichita Falls & Dallas, Texas
- Ogden / Salt Lake City, Utah
- Burlington, Vermont
- Fairfax / Dulles / McLean / Herndon / Reston, Virginia
- Richmond / Alexandria / Arlington, Virginia
- Virginia Beach / Norfolk, Virginia
- Tacoma / Seattle, Washington
- Madison / Milwaukee, Wisconsin
|
 |
 |
Advanced JDBC Techniques for Java Programmers training |
Course Number: 210
Duration: 3 days
view class outline
JDBC Training Overview
Advanced JDBC Techniques for Java Programmers teaches intermediate-level Java developers the JDBC skills they need to build powerful, database-driven applications.
Note: The class can be oriented to Web applications, Swing applications, or a mix of the two. We'll talk with you in-depth before scheduling this class to establish which orientation is most appropriate for your group.
Location and Pricing
Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. To receive a customized proposal and price quote, please contact us.
In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/java.htm.
JDBC Training Prerequisites
All attendees should be familiar with basic Java programming, either from their own experience or from Accelebrate's Beginning Java Application Development training or Beginning Java Web Application Development with JSP training.
Hands-on/Lecture Ratio
This class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 20 minutes.
JDBC Training Materials
All students receive a copy of Prentice-Hall's JDBC: Database Programming with Java EE, which is used as the instructional guide for the course, as well as related courseware and a CD-R with all programs demonstrated and developed during the course.
Software Needed on Each PC
- Any operating system that supports the Java SE SDK
- Java SE SDK, version 1.4.2 or later (downloadable from http://java.sun.com/j2se/downloads.html); 1.5.0 or later is strongly recommended
- The Java tool the students are likely to use after the class (if no tool has been selected, a good free tool is Eclipse, downloadable from http://www.eclipse.org/downloads/)
- Microsoft Access, SQL Server, or another relational database accessible via JDBC or the JDBC-ODBC bridge driver
JDBC Training Objective
- To teach attendees how to build beginning through advanced database-driven applications using Java and JDBC
|
JDBC Training Outline
- Re-Introducing JDBC
- Review of JDBC architecture
- Review of JDBC driver types
- Discussion of evolution of JDBC from version 1.0 through 2.0 and 3.0
- Database concepts review
- Relational database terminology
- SELECT, INSERT, UPDATE, and DELETE statements
- Transactions, logging, isolation, and concurrency
- Key JDBC classes and the java.sql package
- DriverManager and DataSource
- Connection
- Statement, PreparedStatement, and CallableStatement
- ResultSet
- Extra features supported by the javax.sql package
- Rowsets
- Application development activities using the basic JDBC concepts
- Building an interface for selecting records
- Building a data-drilldown example
- Building interfaces for inserting, updating, and deleting records
- Connecting to databases
- Selecting and installing a database driver
- Connecting to the database via a network address
- Connecting to the database based on information supplied by JNDI (the Java Naming and Directory Interface)
- Using the java.sql.DataSource class
- Increasing performance with connection pooling
- Opening and closing the connection
- Handling ClassNotFoundException and SQLException
- Working with a database connection
- Controlling transaction behavior
- Using getWarning and clearWarnings to retrieve, respond to, and clear warnings
- Creating statements, prepared statements, and callable statements
- Retrieving and using database metadata
- Ad-Hoc SQL queries with Statement and PreparedStatement
- Creating a Statement object
- Executing a SQL statement
- Using executeQuery() for statements that return a ResultSet
- Using executeUpdate() for statements that change the database and don't return a ResultSet
- Receiving a ResultSet as the result of a query
- Iterating through and retrieving results
- Moving the cursor within the ResultSet
- Establishing when you are at the beginning or end of the ResultSet
- Creating a PreparedStatement object
- Setting PreparedStatement parameters
- Executing the PreparedStatement
- Additional techniques for working with ResultSets
- Navigating the cursor forward, backward, and arbitrarily within a ResultSet
- Using updateable ResultSets
- Batch updating of ResultSets
- More in-depth
- Obtaining ResultSetMetaData
- What you can/can't find out via ResultSetMetaData
- Obtaining column data types, names, labels, and display sizes
- Obtaining the column count
- Additional useful applications for the ResultSetMetaData
- JDBC transactions
- Understanding ACID (atomicity, consistency, isolation, and durability)
- Turning the committing of transactions on or off
- Committing and rolling back transactions
- Overview of distributed transactions in Java EE
- JDBC design patterns
- Overview of client tier, presentation tier, business tier, and resource tier patterns
- The data access object pattern
- The value object pattern
- The model-view-controller pattern
- Conclusion
|
| |
JBoss® and Hibernate® are registered trademarks of Red Hat, Inc. Accelebrate, Inc. has no affiliation with Red Hat, Inc. and no courses offered by Accelebrate, Inc. are endorsed by Red Hat, Inc. in any way.
|
 |
Accelebrate®
Comes to You! |
 |
Accelebrate's courses are taught exclusively on-site at your location for groups of 3 or more attendees, anywhere worldwide.
Don't settle for a "one size fits all" public class! Have Accelebrate come to your site and deliver exactly the training you want, for less than the cost of a public class.
For pricing and to learn more, please call us at +1 877 849 1850, fill out our information request form, or email us at info@accelebrate.com today.

|
 |
|
| |
| Accelebrate E-Newsletter |
 |
Get the latest Web development news delivered to your email box once a month!

|
 |
|
|
 |