お問い合わせ 今すぐ始める

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

Module 2: 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

Module 3: Handling Exceptions

  • Set SQL Mode to modify the behavior of error output
  • Use SHOW WARNINGS and SHOW ERRORS
  • Handle Exceptions in Java
TiDB Dedicated

TiDB Dedicated

TiDB Cloudのエンタープライズ版。
専用VPC上に構築された専有DBaaSでAWSとGoogle Cloudで利用可能。

TiDB Dedicated

TiDB Serverless

TiDB Cloudのライト版。
TiDBの機能をフルマネージド環境で使用でき無料かつお客様の裁量で利用開始。