Course Code: 19200

MySQL for Developers

Class Dates:
3/21/2022
Length:
4 Days
Cost:
$3895.00
Class Time:
Technology:
Developer
Delivery:
Instructor-Led Training, Virtual Instructor-Led Training

Overview

  • Course 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.

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

Course Details

  • 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
  • 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, Temporal, Expressions
  • Interval Arithmetic
  • Numberic and 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
  • Stored Routines
  • Triggers and Scheduled Events
  • Reporting
  • NoSQL
  • Spatial Data