MySQL for Developers

Course details

• This MySQL for Developers training teaches developers how to develop console and web applications using MySQL with their choice of the PHP, Java, or Python programming languages. Expert Oracle University instructors will guide you through realistic hands-on activities to teach you how to use Connectors to access MySQL databases, query the database effectively, present data in different formats, and use MySQL support for “NoSQL”. In this course, you will be introduced to the MySQL Cloud Service.
• 
  After completing this course, students will be able to:
  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