 |

Please contact us
for GSA pricing.

Contract #
GS-35F-0307T 
Recent Training Venues Accelebrate has recently trained for clients in the following cities:
- Huntsville, Alabama
- Montgomery / Birmingham, Alabama
- Anchorage, Alaska
- Edmonton & Calgary, Alberta
- Phoenix, Arizona
- Tucson, Arizona
- Fayetteville / Little Rock, Arkansas
- Amsterdam, The Netherlands / Brussels, Belgium
- Vancouver, British Columbia
- Oakland / San Jose / San Francisco, California
- Sacramento, California
- San Diego, California
- Orange County / Los Angeles, California
- Boulder / Colorado Springs / Denver, Colorado
- Washington, DC
- Wilmington, Delaware
- Manchester / London, England
- Orlando, Florida
- Fort Lauderdale / Miami, Florida
- Jacksonville, Florida
- Saint Petersburg / Tampa, Florida
- Alpharetta & Atlanta, Georgia
- Augusta & Savannah, Georgia
- Boise, Idaho
- Chicago, Illinois
- Indianapolis, Indiana
- Cedar Rapids / Des Moines, Iowa
- Dublin, Ireland
- Wichita, Kansas
- Lexington / Louisville, Kentucky
- Baton Rouge/New Orleans, Louisiana
- Portland, Maine
- Hagerstown & Frederick, Maryland
- Annapolis / Baltimore, Maryland
- Boston / Cambridge, Massachusetts
- Hartford, Connecticut / Springfield, Massachusetts
- Ann Arbor / Detroit, Michigan
- Grand Rapids, Michigan
- Saint Paul / Minneapolis, Minnesota
- Jackson, Mississippi
- St. Louis, Missouri
- Kansas City, Missouri
- Lincoln / Omaha, Nebraska
- Reno and Las Vegas, Nevada
- Fredericton / Moncton / Saint John, New Brunswick
- Albuquerque, New Mexico
- Princeton, New Jersey & Philadelphia, Pennsylvania
- Albany, New York
- Buffalo, New York
- White Plains / New York City, New York
- Charlotte, North Carolina
- Durham / Raleigh, North Carolina
- Canton / Akron, Ohio
- Cincinnati, Ohio
- Cleveland & Columbus, Ohio
- Dayton, Ohio
- Tulsa / Oklahoma City, Oklahoma
- Toronto, Ontario
- Portland, Oregon
- Pittsburgh, Pennsylvania
- San Juan, Puerto Rico
- Providence, Rhode Island
- Saskatoon / Regina, Saskatchewan
- Edinburgh / Glasgow, Scotland
- Columbia & Charleston, South Carolina
- Spartanburg & Greenville, South Carolina
- Knoxville, Tennessee
- Memphis / Nashville, Tennessee
- Houston, Texas
- El Paso, Texas
- San Antonio / Austin, Texas
- Dallas, Texas
- Salt Lake City, Utah
- Fairfax / Dulles / McLean / Herndon / Reston, Virginia
- Richmond / Alexandria / Arlington, Virginia
- Virginia Beach / Norfolk, Virginia
- Tacoma / Seattle, Washington
- Charleston, West Virginia
- Madison / Milwaukee, Wisconsin
|
 |
 |
Advanced JDBC Techniques for Java Programmers training |
Course Number: JAV-140
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. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, 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/?action=categorygroup&page=java.
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 Java® 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.
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
|
| |
Java® and all Java-based marks are registered trademarks of the Oracle Corporation in the U.S. and other countries. JBoss®, EAP® (Enterprise Application Platform) 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.
WebSphere® is a registered trademark of IBM. Accelebrate, Inc. has no affiliation with IBM. |
 |
Accelebrate®
Focuses on You! |
 |
Accelebrate’s courses are taught for private groups of 3 or more people at your site or online anywhere worldwide.
Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.
For pricing and to learn more, please contact us via information request form or phone, or email us at info@accelebrate.com today.

|
 |
|
 |