Summer-Ready Savings: Find the Training Course You Need at a Price You'll Love

closeClose

MySQL for Developers (Training On Demand)

Course Details
Code: D99534GC40
Tuition (USD): $2,325.00 $2,208.75 • Self Paced (5 days)
Generate a quote
This course is available in other formats
Instructor-Led Classroom & Virtual
MySQL for Developers (D61830GC40)

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

Benefits to you:

This course will teach you how to write applications that maximize your investment in MySQL. You will learn best practice techniques for writing programs that store and retrieve MySQL data and present it to users in a way that allows them to gain insight into that data.

Skills Gained

  • 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

Who Can Benefit

  • 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)

Course Details

Topics

  • 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
  • MySQL overview
  • MySQL Enterprise Edition
  • MySQL on the Web
  • The MySQL community
  • What is MySQL Cloud Service
  • What it means to provision a MySQL Cloud Service instance
  • How an instance of MySQL Cloud Service differs from having an on-premises instance
  • How MySQL course content covers material that applies whether you run MySQL locally or in MySQL Cloud Service

Connectors and APIs

  • Introducing MySQL Connectors
  • PHP Connectors
  • Connector/J
  • Connector/Python
  • Embedding MySQL in an application
  • Integration with MySQL Fabric

Using Connectors

  • PHP, Java, and Python Connectors
  • Reusing connections
  • Dealing with special characters and null values
  • Storing and retrieving connection details
  • Creating secure connections to the MySQL server

Prepared Statements

  • Reasons for using prepared statements
  • User-defined variables
  • Preparing, executing, and deallocating prepared statements
  • Using prepared statements with Connectors

Handling Errors and Warnings

  • SQL modes
  • Interpreting errors and warnings
  • MySQL diagnostics
  • Error and exception handling with Connectors

Building Database-Driven Web Applications

  • Anatomy of a database-driven web application
  • Different methods of displaying query results
  • Web forms and processing requests
  • Using hyperlinks for navigation
  • Displaying query results across multiple pages
  • Dynamic sorting of query results

Tables and Views

  • Creating new tables from existing tables
  • Temporary tables
  • Using mysqldump
  • Working with views

Working with Strings

  • Overview of working with strings
  • String functions
  • Sorting and comparing strings
  • Matching string patterns with regular expressions
  • Using FULLTEXT search

Working with Numeric and Temporal Data

  • Numeric expressions
  • Temporal expressions
  • Interval arithmetic
  • Numeric functions
  • Temporal functions

Subqueries

  • Subquery: overview
  • Scalar subqueries
  • Row subqueries
  • Table subqueries
  • Correlated and non-correlated subqueries
  • Subqueries in data modification statements

Modifying Table Data

  • Using the INSERT statement
  • Retrieving the ID of the last-inserted record
  • Using the DELETE statement
  • Using the UPDATE and REPLACE statements
  • Using the TRUNCATE statement

Transactions

  • Overview of transactions
  • Transactional statements
  • Using transactions within programs
  • Consistency issues
  • Isolation levels
  • Locking

Query Optimization

  • Optimization strategies
  • The MySQL Query Optimizer
  • Indexing
  • Query analysis with the EXPLAIN statement
  • Rewriting queries
  • MySQL Enterprise Monitor

Stored Routines

  • Creating stored routines
  • Variables in stored routines
  • Parameters in stored routines
  • Managing stored routines in the database
  • Using flow control statements and constructs
  • Using cursors
  • Limitations of stored routines

Triggers and Scheduled Events

  • Triggers
  • Scheduled Events

Reporting

  • Aggregating data
  • Summary tables
  • Grouping data
  • Crosstab reports
  • Bar charts
  • Decision tables

NoSQL

  • NoSQL in MySQL
  • Memcached plugin for InnoDB
  • Memcached application development
  • The JSON native data type
  • JSON functions
  • Generated columns

Spatial Data

  • Spatial data support in MySQL
  • The MySQL spatial data types
  • Spatial data formats
  • Using spatial indexes for analysis
  • Useful spatial data functions

Conclusion

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward