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

## Prerequisites
+ Experience with Python programming and SQL

## Description
+ This course guides you through a series of concepts and hands-on best practices to implement read and write operations via Python applications. It focuses on the connectors perspective to get the audience ready to face any Python based ORM frameworks.

## Audience
+ SQL and Python developers 

## Level
+ Intermediate

## Duration
+ 3 hours

## Summary
+ Using Database Connector API
  + Describe Database Connector
  + Describe TiDB Connector
  + Describe the benefits of connection pooling
  + Handle special characters in SQL statements 
  + Handle NULL values in the result set
  + Use TiDB with Python
+ Using Prepared Statements
  + List reasons for using prepared statements
  + Use the `mysql` command line client to `Prepare`, `Execute`, and `Deallocate` the prepared statements
  + Describe the execution plan cache
  + Use prepared statements by programming API
+ Handling Exceptions
  + Set SQL Mode to modify the behavior of error output
  + Use SHOW WARNINGS and SHOW ERRORS
  + Interpreting Error Messages
  + Handle Exceptions in Python