home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
C
All CoursesbalkjeGeneral » Introduction to HW & SW » Soft skills » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » Mac OS X » iPad and iPhone iOSDatabases and middleware » Relational databases & SQL » DB2 for z/OS » DB2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Big data and analyticsApplication development » Methods and techniques » TOGAF » PRINCE2 » Agile development and Scrum » Programming languages » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesSystems management » ITIL » SecuritybalkjePractical informationRegistration 
JDBC

Objectives

Nowadays, Java is a well-accepted programming language within enterprises. Therefore, it is needed to access existing or new relational databases from these Java applications. Although most application developers make their programs in an IDE (Integrated Development Environment), having a basic knowledge on how databases are accessed from Java code is a must. This course provides the foundations on how data can be stored into and retrieved from relational databases using JDBC (Java Data Base Connectivity).

Main topics

  • Overview of JDBC:
  • JDBC vs ODBC • different types of JDBC drivers • two-tier vs. three-tier vs. n-tier
  • Using JDBC: the basics
  • Connecting to the database
  • Preparing and executing SQL select statements
  • Processing the result: handling multiple rows • exception handling
  • parameterized queries
  • Non-select statements
  • More JDBC:
  • Scrollable result sets • rowsets
  • Advanced topics: transactions • locking • JNDI
  • Metadata
  • Calling stored procedures
  • Java persistence frameworks
  • Object relational mapping
  • Persistence mechanisms
 

Intended for

Application developers, technical analysts and database administrators who are involved in the development of Java applications that access relational databases.

Background

The participants should have experience (at least 3 months) with Java programming (see course Java programming) and be familiar with at least basic SQL (see course SQL and relational databases fundamentals).

Training method

Lecture and hands-on exercises. The participants will work with Java applications accessing IBM DB2, Oracle, MySQL or other relational databases.

Course leader

Sandy Schillebeeckx, Guido Indesteege.

Duration

1 day.

Schedule

You can enrol by clicking on a date
datedur.lang.  location  price
16 Oct1ELeuven  (BE)500 EUR  (excl. VAT) 

Global score

   
4.0/5 (based on 60 evaluations)

Reviews

     
Voor mij (mainframe ervaring) iets te snel, maar perfect opgevangen door Sandy. (, )
     
Les 3 design pattern ont été abordé. La connection à la base de donnée a été décrite. (, )
     
Alles duidelijk uitgelegd en genoeg oefeningen. Goede cursus. (, )
     
veel topics voor 1 dag (, )
     
Prima cursus, goed gepresenteerd door Sandy (, )
     
Ik vond het moeilijk, had precies wat meer tijd nodig.. (, )
     
Cours bien présenté et complet. (, )
     
Docent: uitstekend, gemotiveerd, gepassioneerd. Inhoud: Ok als basis vooor JPA. Tijd: Ok als basis vooor JPA (, )
     
veel leerstof voor 1 dag (, )
     
Ik heb geen java achtergrond, dus het java gedeelte was geheel nieuw voor mij. Maar op zich wel te begrijpen (, )