MySQL for Developers

5 Days

• Administrator 
• Analyst 
• Developer 

Suggested Prerequisite 

• MySQL Performance Tuning Ed 3 

• Developing simple web applications using PHP, Java/JSTL, or 
• Basic HTML 
• Knowledge of JSON (javascript object notation) 

Required Prerequisite 

• MySQL Fundamentals Ed 1 

• Knowledgable in using the mysql command-line client 
• Knowledgable in relational database concepts and MySQL data types 
• Knowledgable in executing basic DDL and DML queries using SQL 
• Knowledgable in Joining tables 

• 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 

• Introduction to MySQL 
• Connectors and APIs 

• Using Connectors 
• Prepared Statements 
• Handling Errors and Warnings 
• Building Database-Driven Web Applications 
• Tables and Views 

• Working with Strings 
• Working with Numeric and Temporal Data 
• Subqueries 
• Modifying Table Data 
• Transactions 

• Query Optimization 
• Stored Routines 
• Triggers and Scheduled Events 
• Reporting 
• NoSQL 

• Spatial Data 
• Conclusion