Introduction

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.

Free online learning is coming soon!

Private Training is available now. To purchase Private Training, contact sales to build out a custom training plan.

Contact Sales

Summary

  • Audience: SQL and Java developers
  • Level: Intermediate
  • Duration: 3 hours
  • Prerequisites: Experience with Java programming and SQL
  • TiDB Version: v6.x

Course Outline

  • Describe Database Connector
  • Describe TiDB Connector
  • Access TiDB via Java
  • Describe the benefits of connection pooling
  • Handle NULL values in the result set
  • 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
  • Set SQL Mode to modify the behavior of error output
  • Use SHOW WARNINGS and SHOW ERRORS
  • Handle Exceptions in Java

Build out a custom training plan?  Contact Sales

Module 1: 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
TiDB Cloud logo-white

TiDB Cloud

Get the massive scale and resiliency of TiDB databases in a fully managed cloud service

TiDB logo-white

TiDB

TiDB is effortlessly scalable, open, and trusted to meet the real-time needs of the digital enterprise