# Course 5: Best Practices for Developing on TiDB (Code#: 201.5) 

## Prerequisites
+ Experience with SQL and backend application programming

## Description
+ This course summarizes the guidelines and best practices about developing on TiDB.

## Audience
+ Backend developers 

## Level
+ Intermediate

## Duration
+ 3 hours

## Summary
+ Describe best practices for using TiDB SQL
  + Describe best scenarios for TiDB
  + Describe transaction best practices on TiDB
  + Describe best practices for using secondary indexes
  + Try to avoid full table scan
  + Ensure the returning order for result set
+ Describe best practices for developing applications using TiDB (using Java as an example)
  + JDBC configuration parameters best practices
  + Prepared statements best practices
  + Batching best practices