Home > Vendors > oracle > d61830

Share

D61830 - MySQL for Developers

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

Duration: 5.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training

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

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

Audience

 Application Developers
 Database Developers
 Analyst/Programmer
 Software Engineers

Prerequisites

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

Certification

product-certification

This course is not associated with any Certification.

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Oracle Popular Courses

d90871

This training is the first step in mastering MySQL, the world’s most popular open source database.

p10380

P10380 - Oracle Database 18c: Administration Workshop

d79995

Learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code.

d83527

D83527 - Java SE 8 Fundamentals
Enquire Now
AZDv7I
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy
➤