Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - Java: Database Access with JDBC

Home

distance-learning center

Application of Classic Teaching Models Mobile Classrooms

Professional Distance-learning

IT Training Services



INPR2081

Java: Database Access with JDBC
DURATION: 3 days

FEE: $1,785

PRIVATE GROUP FEE: $
Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.

AUDIENCE:

  • Webmaster
  • Programmer
  • System Designer
  • System Analyst
  • IT Professional
 
   

DATES:

HANDS-ON TRAINING:
    1. Database: Introduction
      • Describe the 2-tier and 3-tier method of working with JDBC.
    2. SQL
      • Code and test a number of SQL statements including joins, unions, and subqueries.
    3. Querying and Modifying Data
      • Code a number of queries with significant filtering and multiple tables.
    4. JDBC: Java Database Connectivity
      • Examine the assumptions and featureset underlying JDBC.
      • Set up a database and establish a connection.
      • Become knowledgeable with multi-tier models and develop designs for different multi-tiered applications.
    5. Using JDBC
      • Set up and install a new JDBC driver on the client systems.
      • Create a remote JDBC driver on a server.
      • Code two different techniques for establishing a connection to the test server.
      • Use a PreparedStatement object for sending SQL statements to the database; this special type of statement is derived from the Statement class.
    6. JDBC: Advanced Techniques
      • Acquire proficiency in handling exceptions.
      • Handle errors which include: 1- A bad connection. 2- Invalid SQL statements. 3- Truncated values. 4. Returning no values.
      • Compare dates and perform date arithmetic.
      • Perform table joins; code an outer and a full inner join.
      • A stored procedure is a group of SQL statements that form a logical unit and perform a specific task; they are used to encapsulate a set of operations or queries which execute on a database server: 1- Invoke a stored procedure that returns a resultset. 2- Process the resultset.
    7. Special Features
      • Return the count of the number of rows affected by the operation.
      • Create parameterized statements, fill in the values, and invoke a parameterized SQL statement.
      • Work with large objects; retrieve a LOB and display the results.
 
 
    Web-based Training   Blended Learning    
Synchronous
Instruction
Asynchronous
Instruction
Value Added Service

Common Questions


Website

 

Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.

SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.