MySQL 8.0 for Developers

Overview

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. Expert Oracle University instructors will guide you through realistic hands-on activities in which you will learn how to use Connectors to access MySQL databases, query the database effectively, present data in different formats, and how to use MySQL’s support for JSON and spatial data.

Audience

• Application Developers
• Database Developers
• Analyst/Programmer
• Software Engineers

Suggested Prerequisites

Developing simple web applications using PHP, Java/JSTL, or Python Basic HTML Knowledge of JavaScript Object Notation (JSON)

Topics

• 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
• Transactions
• Optimizing Queries
• Stored Routines
• Triggers and Scheduled Events
• Reporting
• Spatial Data
• JSON Data
• Document Store
• NoSQL