SanEd consulting

Company profile

SanEd consulting is an IT training company which initiated its services in 2005 primarily as Sun Microsystem's authorised training provider. Our training portfolio was Solaris and Java focused. Later on we upgraded our portfolio and included authorisations from Veritas / Symantec and Oracle after aquisition of Sun. 

As the global IT market is rapidly changing and developing we must have accepted its needs and trends. Thus, beginning of 2014 we decided to "refurbish" our services and included new, young and perspective partners and together prepared number of interesting trainings you can find in our catalogue.

We are looking forward to successful cooperation with you.

.
поздравления с новорожденным

JDBC Programming

Start Date:
Not Specified
Finish date:
Not Specified
Code:
CJP168
Price:
0.00 EUR (VAT excl.)

Description


This one-day course covers the fundamentals of database programming in Java using JDBC (Java Database connectivity) in an incremental fashion, to get the programmer up to speed quickly and then to layer a deeper understanding of JDBC upon that foundation. This course has been designed to work with any of these relational database management systems:

  •  Apache Derby 10.6
  •  Oracle, version 9i, 10g, or 11g

Lab exercises use SQL99 constructs whenever possible in order to be relevant to databases from all vendors.

 

Training days

1 day

 

Prerequisites

  • Experience in Java Programming is essential. The student must be comfortable with object-oriented Java, interfaces and abstract classes. Course "Java Programming," is excellent preparation.
  • Understanding of basic SQL usage or other work with relational databases will be helpful, but is not required.

 

Skills gained

 Briefly review relational database fundamentals with an awareness of the differences between SQL99 and SQL implementations by database vendors.
 Connect to a database using JDBC and perform a simple query.
 Update relational data using JDBC to execute updates, inserts and deletes.
 Use prepared statements to produce reusable database queries and optimize execution time.
 Use callable statements to access database procedures.
 Use scrollable and updatable results sets for more robust solutions.
 Use commit, rollback, and savepoint to build transactional systems.
 Use batch processing for efficient handling of large datasets.
 Understand the use of RowSets and the improved techniques and portability that they bring to JDBC.

 

Course content

 

1. Database and SQL Fundamentals

  • Relational Databases and SQL
  • SQL Versions and Code Portability
  • Database, Schema, Tables, Columns and Rows
  • DDL -- Creating and Managing Database Objects
  • DML -- Retrieving and Managing Data
  • Sequences
  • Stored Procedures
  • Result Sets and Cursors
  • Using SQL Terminals

 

2. JDBC Fundamentals

  • What is the JDBC API?
  • JDBC Drivers
  • Making a Connection
  • Creating and Executing a Statement
  • Retrieving Values from a ResultSet
  • SQL and Java Datatypes
  • SQL NULL Versus Java null
  • Creating and Updating Tables
  • Handling SQL Exceptions and Proper Cleanup
  • Handling SQLWarning
  • The JDBC 4.0 Cause Facility

 

3. Advanced JDBC

  • SQL Escape Syntax
  • Using Prepared Statements
  • Using Callable Statements
  • Scrollable Result Sets
  • Updatable Result Sets
  • Transactions
  • Commits, Rollbacks, and Savepoints
  • Batch Processing
  • Alternatives to JDBC

 

4. Introduction to Row Sets

  • Row Sets in GUI and J2EE programming
  • Advantages of RowSets
  • RowSet Specializations
  • Using CachedRowSets

 

Price:  on demand

 

Date:  on demand


Book the course: JDBC Programming

Bookings are disabled.

     

- Trainings - - - JDBC Programming