# Course 4: Working with TiDB from Java (Code#: 201.4-Java) 

## Prerequisites
+ Experience with Java programming and SQL

## Description
+ This course guides you through a series concepts and hands-on best practices to implement read and write operations via Java program. It focuses on the JDBC Connector/J driver perspective to get the audience ready to face any ORM frameworks built upon Connector/J. 

## Audience
+ SQL and Java developers 

## Level
+ Intermediate

## Duration
+ 3 hours

## Summary
+ Using Database Connector API
  + Describe Database Connector
  + Describe TiDB Connector
  + Access TiDB via Java
  + Describe the benefits of connection pooling
  + Handle NULL values in the result set
+ Using Prepared Statements
  + Describe the reasons for using prepared statements and their limitations
  + Use mysql command line client to prepare, execute, and deallocate prepared statements
  + Use prepared statements in your code via the Connector API
  + Use batch processing API
+ Handling Exceptions
  + Set SQL Mode to modify the behavior of error output
  + Use SHOW WARNINGS and SHOW ERRORS
  + Handle Exceptions in Java