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
