trainocate-oracle-training-b
Home > Vendors > oracle > d61830

D61830 - MySQL for Developers

Overview

Duration: 5 days
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.
Learn to:
 Program with Connectors
 Write console and web applications
 Optimize query performance
 Write stored routines and triggers
 Store, access, and analyze geospatial data
 Use X DevAPI to access JSON data in document store

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
 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
 Identify and optimize poorly performing queries
 Write stored routines, triggers, and scheduled events
 Aggregate and summarize data to create reports
 Store spatial and JSON data using MySQL native data type
 Query and manipulate spatial and JSON data using functions and operators
 Store JSON documents using MySQL Document Store
 Use X DevAPI to access document store and relational data

Audience

 Application Developers
 Database Developers
 Analyst/Programmer
 Software Engineers

Content

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


Prerequisites

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

Certification

This course is not associated with any Certification.

Schedule

Show Schedule for:




Enquire Now
 
 
 
 
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy