News

Webinars from Spindustry on SharePoint, MS Teams, and Power BI

Spindustry offers a variety of ways to learn more about solutions to benefit your business. Below is a list of upcoming webinars or pre-recorded sessions that we hope you find helpful.

Spindustry Training Offers SharePoint Governance Consulting

Avoid costly, time consuming mistakes with your SharePoint installation.

Live Instructor-Led Training

The Power to Boost Productivity!


CONTACT US
Training partners

Spindustry Training

spindustrytraining.com - (515) 334-9556

Bookmark and Share

JDBC - Java Database Connectivity

Course Code: P-JDBC
Length: 1 Day
Tuition: $599.00

Schedule for this Course

There are no dates scheduled for this course.
If you would like to be added to the wait list for this class Click Here

Course Description:

JDBC is a Java technology for accessing SQL databases.  It is a core part of J2EE, and it works with every major database product.  This hands-on course covers all the details that you will need to use JDBC to access the information in your databases using Java.  It also talks about real world issues in using JDBC.

All labs can be done with the Eclipse IDE or a simple editor, and the lab instructions include detailed directions on both environments.

Skills Gained

  • Understand the JDBC architecture
  • Connect to different databases with JDBC
  • Understand the JDBC API
  • Execute SQL statements using JDBC, and retrieve results
  • Call stored procedures from JDBC
  • Understand and control transactions with JDBC
  • Retrieve information about database structure using DatabaseMetaData
  • Use Advanced JDBC features

Prerequisites

Course Outline:

Introduction

  • Relational Database and JDBC Overview
    • Overview, Table Relationships, Web Based Data Access, JDBC Characteristics
  • JDBC Architecture, JDBC API Overview
    • DriverManager, JDBC Drivers
    • Naming databases with JDBC URLs
  • Connecting to a database
    • Connection interface, Establishing a connection
  • DataBaseMetaData
  • Handling Database Exceptions


Data Access

  • DAO – Data Access Objects, O-R Mapping, Value Objects
  • Processing Database Data
    • Executing statements, precompiled statements and stored procedures
    • Processing ResultSets,
    • Dealing with Null data
    • Updating, inserting, retrieving data
    • Controlling Transactions
  • JDBC Driver Types
  • DataSource
    • J2EE and DataSource
    • Using JNDI
  • Connection Pooling
    • Overview, Usage, Advantages, Statement Pooling


 Advanced Topics

  • Other Database Access Technologies
    • SQLJ, O-R Mapping Tools, JDO (Java Data Objects), EJB Entity Beans
  • Advanced JDBC Features
    • Batch Updates, Srollable Result Sets, Rowsets, User Defined Types, BLOBS, CLOB

back to top