MySQL 8.0 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.

STUDENTS WILL 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
Phone
Phone
Product
Oracle
Code
D66378GC50
Duration
5 Days
Price (baht)
56,500

About the course

COURSE TOPICS

Module 1 : Introduction to MySQL

  • Introduction to MySQL
  • Practice 0-1: Course Overview Environment
  • Practice 1-1: Course Environment

 Module 2 : Connectors and APIs

  • Connectors and APls
  • Practice 2-1: Quiz

 Module 3 : Using Connectors

  • Connection Pooling
  • Practice 3-1: Connecting to the MySQL Server in a Web Environment with PHP/PDO
  • Practice 3-2: Connecting to the MySQL Server in a Web Environment with Connector/]
  • Practice 3-3: Connecting to the MySQL Server in a Web Environment with Connector/Python
  • Practice 3-4: Executing SQL in a Web Environment with PHP/PDO
  • Practice 3-5: Executing SQL in a Web Environment with Connector/]
  • Practice 3-6: Executing SQL in a Web Environment with Connector/Python

 Module 4 : Prepared Statements

  • Prepared Statements
  • Practice 4-1: Preparing Statements in MySQL
  • Practice 4-2: Using Prepared Statements with PHP/PDO
  • Practice 4-3: Using Prepared Statements with Connector/J
  • Practice 4-4: Using Prepared Statements with Connector/Python

 Module 5 : Handling Errors and Warnings

  • Handling Errors and Warnings
  • Practice 5-1: Quiz – Handling Errors
  • Practice 5-2: Identifying Errors and Warnings with the mysql Command-Line Client
  • Practice 5-3: Handling Errors and Warnings When Coding with PHP/PDO
  • Practice 5-4: Handling Errors and Warnings When Coding with Connector/]
  • Practice 5-5: Handling Errors and Warnings When Coding with Connector/Python

Module 6: Creating Database-Driven Web Applications

  • Creating Database-Driven Web Applications
  • Web Forms
  • Practice 6-1: Displaying Query Results in a Table Using PHP/PDO
  • Practice 6-2: Displaying Query Results in a Table Using Java/JSP
  • Practice 6-3: Displaying Query Results in a Table Using Python
  • Practice 6-4: Paging Query Results Using PHP/PDO
  • Practice 6-5: Paging Query Results Using Java/JSP
  • Practice 6-6: Paging Query Results Using Python
  • Practice 6-7: Enabling Sorting of Query Results Using PHP/PDO
  • Practice 6-8: Enabling Sorting of Query Results Using Java/JSP
  • Practice 6-9: Enabling Sorting of Query Results Using Python

 Module 7: Working with Views

  • Working with Views
  • Practice 7-1: Creating a View
  • Practice 7-2: Updating a View
  • Practice 7-3: Checking a View
  • Practice 7-4: Obtaining View Metadata
  • Practice 7-5: Creating, Updating, and Querying Multiple-table Views

 Module 8: Working with Strings

  • Working with Strings
  • Practice 8.1: Manipulating String Data with MySQL Expressions
  • Practice 8.2: Matching Patterns in Strings
  • Practice 8.3: Using Full-Text Searches

 Module 9: Working with Numeric and Temporal Data

  • Working with Numeric and Temporal Data
  • Practice 9-1: Using Numeric Data in SQL Expressions
  • Practice 9-2: Using Temporal Data in SQL Expressions
  • Practice 9-3: Using Control Flow Functions in SQL Expressions

 Module 10: Transactions

  • Transactions
  • Consistency Issues
  • Practice 10-1: Quiz-Transactions, Isolation Levels, and Locking
  • Practice 10-2: Examining the Effect of Isolation Levels in Concurrent Transactions
  • Practice 10-3: Using Transactional Statements with PHP/PDO
  • Practice 10-4: Using Transactional Statements with Connector/]
  • Practice 10-5: Using Transactional Statements with Connector/Python

 Module 11: Optimizing Queries

  • Optimizing Queries
  • Using EXPLAIN to Analyze Queries
  • Practice 11-1: Quiz – Optimization
  • Practice 11-2: Managing Table Indexes
  • Practice 11-3: Optimizing Queries Using Indexes
  • Practice 11-4: Rewriting Queries for Optimization
  • Practice 11-5: Identifying and Fixing Slow Queries with MySQL Enterprise Monitor Query Analyzer

 Module 12: Stored Routines

  • Stored Routines
  • Control Flow Statements
  • Practice 12-1: Creating Simple Stored Routines
  • Practice 12-2: Creating Stored Routines with Compound Statements
  • Practice 12-3: Creating Stored Routines with Parameters
  • Practice 12-4: Examining Stored Routines Metadata
  • Practice 12-5: Deleting and Recreating a Stored Routine
  • Practice 12-6: Creating Stored Routines with Control Flow Statements
  • Practice 12-7: Working with Conditions and Handler in Stored Routines
  • Practice 12-8: Working with Cursors in Stored Routines
  • Practice 12-9: Creating a Functional Library

Module 13: Triggers and Scheduled Events

  • Triggers and Scheduled Events
  • Using OLD and NEW Qualifiers
  • Practice 13-1: Creating and Dropping Triggers
  • Practice 13-2: Investigating Triggers in the sakila Database
  • Practice 13-3: Creating a Scheduled Event

 Module 14: Reporting

  • Reporting
  • Materialized Views
  • Practice 14-1: Aggregating Data
  • Practice 14-2: Grouping Aggregated Data
  • Practice 14-3: Using Window Functions
  • Practice 14-4: Creating a Crosstab Report with a Bar Chart

Module 15: Spatial Data

  • Spatial Data
  • Practice 15-1: Creating Spatial Data
  • Practice 15-2: Using Spatial Indexes for Analysis

Module 16: JSON Data

  • JSON Data
  • Practice 16-1: Creating and Querying JSON Data
  • Practice 16-2: Updating JSON Data
  • Practice 16-3: Indexing JSON Data

Module 17: Document Store

  • Document Store
  • Using X DevAPI with Connector/] to Access a Document Store
  • Practice 17-1: Accessing JSON in MySQL Shell
  • Practice 17-2: Accessing JSON by Using X DevAPI with PHP
  • Practice 17-3: Accessing JSON by Using X DevAPI with Connector/]
  • Practice 17-4: Accessing JSON by Using X DevAPI with Connector/Python
  • Practice 17-5: Accessing JSON by Using Python Statements in MySQL Shell

 Module 18: Conclusion

  • Conclusion

Register for Training

Schedule

Start DateEnd DateDuration (days)PriceRegisterCourseCodeProduct

เราใช้คุกกี้เพื่อพัฒนาประสิทธิภาพ และประสบการณ์ที่ดีในการใช้เว็บไซต์ของคุณ คุณสามารถศึกษารายละเอียดได้ที่ นโยบายความเป็นส่วนตัว และสามารถจัดการความเป็นส่วนตัวเองได้ของคุณได้เองโดยคลิกที่ ตั้งค่า

Privacy Preferences

คุณสามารถเลือกการตั้งค่าคุกกี้โดยเปิด/ปิด คุกกี้ในแต่ละประเภทได้ตามความต้องการ ยกเว้น คุกกี้ที่จำเป็น

Allow All
Manage Consent Preferences
  • Always Active

Save