Java Database Connectivity




DESCRIPTION

In this course, you will learn how to write Java code that interacts with a relational database like MySQL, using the Java Data Base Connectivity or JDBC API.

Prerequisites:
  • Java programming,
  • SQL concepts.

  Download syllabus




DETAILS

Live or self-paced

  •   Course syllabus
  • Introduction to JDBC
    Install: Java, MySQL, NetBeans
    JDBC: architecture, packages
    JDBC drivers: types 1, 2, 3, 4
    Import JDBC Packages
    Database URL
    Create a Connection object
    Close JDBC connections
    Example

    How to create statements
    Statement objects
    Methods of Statement class
    PreparedStatement objects
    setXXX() methods: attach data
    Stored Procedures: IN, OUT, INOUT
    CallableStatement objects
    Methods setXXX(), getXXX()
    registerOutParameter()
    Lab: using statements

    Manipulating Resultsets
    Introduction
    Types of ResultSets
    Access concurrency
    Navigate in a ResultSet
    Display data from a ResultSet
    The get method for displaying
    Update data
    The update() method
    JDBC-SQL Data types
    Lab: using resultsets

    Transactions, batches and streams
    Transactions
    Commit and Rollback
    Use Savepoints
    SQLException class
    Batch with a Statement object
    Batch with a PreparedStatement
    JDBC batch management
    Lab: XML file in DB

    Labs
    SQL : defining data
    Create a new package
    Prepare the database
    Using Statements
    Using commit and rollback
    Using a CallableStatement
    Create and use a DAO
    Create an abstract class
    POJOs, Interfaces
    Create a Manager

  •   What's included
  • + Experienced instructor
    + Complete syllabus
    + Course material (PDF)
    + Miscellaneous course notes

  •   Who it is for
  • + Architects.
    + Project managers.
    + Consultants.
    + Developers.
    + Engineers.

  •   Certification
  • The training is illustrated by case studies and practical work. It does not yet lead to certification.



BENEFITS. TESTIMONIALS

  • Your Reconvert instructor,
  • Hands-on based teaching,
  • Immediate access to VODs,
  • Good quality PDF materials.

Excellent quality, the teacher knows how to create an environment of trust and confidence which makes the training really enjoyable. The course was dynamic and easy to understand. The trainer is an excellent instructor.
J. Ruiz
The Moneytizer, Mexico

The training session with you was awesome, really interesting and full of useful information. I’m currently a Cloud & Big Data engineer with Micropole, Paris. Thanks.
A. Chuttoo
Micropole, France

These 4 days have been enriching. After a training-course in HTML and then CSS, the one on Javascript gave me a lot more knowledge and skills in client side web development.
J. Salgueiro
The Moneytizer, Brazil



Other references :

Click on the logo.


Capgemini Atos Allianz TheMoneytizer CPAM M2iFormation Global Knowledge Ikea Hewlett Packard Department of Defense AKKA Ministry of the Interior AFP Enedis Viveris Titeflex Others


UPCOMING DATES


Dates on request
Request for new dates - Contact us


PRICE. BOOKING

  •   Online Instructor Led
  • Get a quote or book now.
    Video conference tools : Zoom or Teams.
    Getting a quote does not require any payment or commitment.

    Price : 780 €

    Get a quote

    I receive my quote fast

  •   Online self-paced
  • With Online self-paced format, the lesson is webcast AND turored. In fact, you are never left to work alone – you are able to interact asynchronously with the instructor via a dedicated Discord channel. The lesson is accessible during 30 days on our dedicated LMS platform.

    For the moment, this training course is available exclusively online via ZOOM or Microsoft TEAMS sessions, i.e. as Virtual Class (= Online Instructor Led). It will shortly be available Online self-paced.

    Please stay tuned for further information.

  •   Video On Demand
  • When available, access to VOD is immediate.
    And you'll get access to videos 24/7, by paying by credit card.

    For the moment, this training course is available exclusively online via ZOOM or Microsoft TEAMS sessions, i.e. as Virtual Class (= Online Instructor Led). It will shortly be available in VOD.

    Please stay tuned for further information.




Others trainings

Python programming by hands-on
Learn by hands-on how to program in Python language : syntax, functions, databases.

HTML5 & CSS: how to create modern websites
Learn how to create modern web pages using HTML5 and CSS3 languages.

Creating dynamic PHP web applications
Learn to create PHP applications connected to SQL databases.

Workshop: discovering web development
Discover web development in 30 minutes, and see if this job is for you.

Getting started in algorithms with Java
Learn how to solve a problem by describing it in pseudo code language and then by producing a Java code.

Workshop: learn SQL with MySQL
Learn how to get started with a database by writing simple SQL clauses.

Mastering SQL language with MySQL
Learn how to write and test SQL for your web application data.

Workshop: learn programming with Python
Get started with Python by learning how to install it and create small programs.

Javascript programming
Learn how to create interactivity on the browser with the Javascript language.

E-marketing: techniques and tools
Understand and carry out e-marketing campaigns with professional tools.

How to create a blog without coding
Learn how to create a personal or business blog in your web browser, without programming.

jQuery programming
Learn how to create interactivity with jQuery and use Ajax technology.

GIT - source code management
Learn how to manage and deploy all your IT projects with Git and GitHub.

UML: analysis and design
Learn to design object applications with UML by representing entities in classes and interactions between objects.

Java SE programming
Learn how to create Java applications using object-oriented programming.

Java Web Programming
Learn how to create dynamic, data-connected web applications using Java and JEE technology.

JPA and Hibernate persistence
Learn how to use the JPA standard and the Hibernate ORM to manage persistence in your applications.

Spring Web programming
Learn how to use Spring Framework, Spring MVC and Spring Boot to build secure web applications.

Web services with Java REST API
Learn how to create REST services in Java, secure them, deploy them and consume them.

Unit testing with JUnit
Get started with the JUnit reference testing framework and implement unit and integration tests.

Angular: web development
Learn how to develop web applications using the Angular framework.

Web application security
Learn how to detect attacks, secure web applications, implement best practices in web security.

Python API and REST Web Services
Learn how to create REST services in Python, secure them, deploy them and consume them.

Advanced PHP, Doctrine and Web Services
Learn how to create object-oriented PHP applications using specialized libraries and Web services.

Symfony : web development
Learn Symfony concepts to create modern and secure MVC web applications.

Django: web development with Python
Learn how to develop web applications in Python using the Django framework.