- Secure your connections to the MySQL server
- Use prepared statements
- Guard against SQL injection
- Investigate and handle errors and warnings
- Create database-driven web applications
- Enable fast text search
- Respond to data changes and events
- Modify table data
- Use temporal and numeric functions in expressions
- Write queries that contain nested queries
- Safeguard concurrent queries by using transactions
- Find and fix poorly-performing queries
- Use NoSQL and JSON document stores
- Write stored programs
- Create MySQL client programs using Connectors
- Gain an understanding of the MySQL Cloud Service