The MySQL for Developers training course teaches developers you how to develop console and web applications using MySQL with your choice of the PHP, Java, or Python programming languages.
Objectives
- Create MySQL client programs in PHP, Java, and Python using Connectors
- Use prepared statements to execute similar queries with different parameters
- Protect against SQL injection using prepared statements
- Interpret and handle errors and warnings
- Create database-driven web applications and work with views
- Manipulate string data with functions and operators
- Use temporal and numeric functions in expressions
- Use transactions to group multiple SQL statements into an atomic operation
Topics
- Introduction to MySQL
- Connectors and APIs
- Using Connectors
- Prepared Statements
- Handling Errors and Warnings
- Creating Database-Driven Web Applications
- Working with Views
- Working with Strings
- Working with Numeric and Temporal Data
- Transactions
- Optimizing Queries
- Stored Routines
- Triggers and Scheduled Events
- Reporting
- Spatial Data
- JSON Data
- Document Store
- Conclusion
Other Trainings
MySQL
8 Training Set
