Duración

5 días - 30 horas

Descripción

This MySQL for Developers training teaches developers how to develop console and web applications using MySQL. You have a choice of the PHP, Java, or Python programming languages. In this course, you will be introduced to the MySQL Cloud Service.

Objetivos

  1. Secure your connections to the MySQL server
  2. Use prepared statements
  3. Guard against SQL injection
  4. Investigate and handle errors and warnings
  5. Create database-driven web applications
  6. Enable fast text search
  7. Respond to data changes and events
  8. Modify table data
  9. Use temporal and numeric functions in expressions
  10. Write queries that contain nested queries
  11. Safeguard concurrent queries by using transactions
  12. Find and fix poorly-performing queries
  13. Use NoSQL and JSON document stores
  14. Write stored programs
  15. Create MySQL client programs using Connectors
  16. Gain an understanding of the MySQL Cloud Service

Contenidos del curso

  1. Introduction to MySQL
    • MySQL on the Web
    • What it means to provision a MySQL Cloud Service instance
    • What is MySQL Cloud Service
    • MySQL overview
    • How an instance of MySQL Cloud Service differs from having an on-premises instance
    • MySQL Enterprise Edition
    • How MySQL course content covers material that applies whether you run MySQL locally or in MySQL Cloud Service
    • The MySQL community
  2. Connectors and APIs
    • Integration with MySQL Fabric
    • Introducing MySQL Connectors
    • Connector/J
    • Embedding MySQL in an application
    • Connector/Python
    • PHP Connectors
  3. Using Connectors
    • Storing and retrieving connection details
    • Reusing connections
    • Dealing with special characters and null values
    • Creating secure connections to the MySQL server
    • PHP, Java, and Python Connectors
  4. Prepared Statements
    • Reasons for using prepared statements
    • Using prepared statements with Connectors
    • User-defined variables
    • Preparing, executing, and deallocating prepared statements
  5. Handling Errors and Warnings
    • MySQL diagnostics
    • Interpreting errors and warnings
    • SQL modes
    • Error and exception handling with Connectors
  6. Building Database-Driven Web Applications
    • Dynamic sorting of query results
    • Anatomy of a database-driven web application
    • Displaying query results across multiple pages
    • Different methods of displaying query results
    • Web forms and processing requests
    • Using hyperlinks for navigation
  7. Tables and Views
    • Temporary tables
    • Working with views
    • Using mysqldump
    • Creating new tables from existing tables
  8. Working with Strings
    • String functions
    • Sorting and comparing strings
    • Using FULLTEXT search
    • Matching string patterns with regular expressions
    • Overview of working with strings
  9. Working with Numeric and Temporal Data
    • Temporal functions
    • Numeric expressions
    • Numeric functions
    • Temporal expressions
    • Interval arithmetic
  10. Subqueries
    • Row subqueries
    • Subqueries in data modification statements
    • Table subqueries
    • Subquery: overview
    • Correlated and non-correlated subqueries
    • Scalar subqueries
  11. Modifying Table Data
    • Using the INSERT statement
    • Using the DELETE statement
    • Using the TRUNCATE statement
    • Using the UPDATE and REPLACE statements
    • Retrieving the ID of the last-inserted record
  12. Transactions
    • Consistency issues
    • Transactional statements
    • Isolation levels
    • Locking
    • Overview of transactions
    • Using transactions within programs
  13. Query Optimization
    • Query analysis with the EXPLAIN statement
    • Optimization strategies
    • Indexing
    • The MySQL Query Optimizer
    • MySQL Enterprise Monitor
    • Rewriting queries
  14. Stored Routines
    • Using cursors
    • Parameters in stored routines
    • Managing stored routines in the database
    • Limitations of stored routines
    • Creating stored routines
    • Variables in stored routines
    • Using flow control statements and constructs
  15. Triggers and Scheduled Events
    • Scheduled Events
    • Triggers
  16. Reporting
    • Bar charts
    • Decision tables
    • Crosstab reports
    • Grouping data
    • Summary tables
    • Aggregating data
  17. NoSQL
    • Memcached application development
    • NoSQL in MySQL
    • Generated columns
    • Memcached plugin for InnoDB
    • The JSON native data type
    • JSON functions
  18. Spatial Data
    • The MySQL spatial data types
    • Spatial data formats
    • Using spatial indexes for analysis
    • Useful spatial data functions
    • Spatial data support in MySQL
  19. Conclusion


Información extra

Learn to

This MySQL for Developers training teaches developers how to develop console and web applications using MySQL with their choice of the PHP, Java, or Python programming languages. Expert Oracle University instructors will guide you through realistic hands-on activities to teach you how to use Connectors to access MySQL databases, query the database effectively, present data in different formats, and use MySQL support for “NoSQL”. In this course, you will be introduced to the MySQL Cloud Service.

  • Program with Connectors.
  • Write console and web applications.
  • Optimize query performance.
  • Write stored routines and triggers.
  • Use the InnoDB memcached plugin for NoSQL access to your data.
  • Store, access, and analyze geospatial data.
  • Gain an understanding of the MySQL Cloud Service.

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.

Audience

  • Data Analyst
  • Application Developers
  • Developer
  • Support Engineer

Related Training

Required Prerequisites

  • MySQL Fundamentals Ed 1
  • MySQL for Database Administrators Ed 3.1

Suggested Prerequisites

  • Knowledgable in executing basic DDL and DML queries using SQL
  • Knowledgable in using the mysql command-line client
  • Knowledgable in relational database concepts and MySQL data types
  • Knowledgable in Joining tables
  • Knowledge of JSON (javascript object notation)
  • Developing simple web applications using PHP, Java/JSTL, or Basic HTML

Información general

Área formativa

Oracle MySQL

Fabricante

Oracle

Metodología

Presencial

Certificación

Garantía juvenil

 

¿TIENES DUDAS? PREGÚNTANOS

He leído y acepto la del sitio y las condiciones de tratamiento de mis datos de carácter personal

 

 

Fecha y precios de nuestros cursos

Fecha Horario de impartición Ubicación Precio por alumno Previsto en fecha
25 Feb 2019
De 09:00 a 15:00 h.
Core Madrid
1510 € + IVA
08 Jul 2019
De 09:00 a 15:00 h.
Core Madrid
1510 € + IVA
16 Sep 2019
De 09:00 a 15:00 h.
Core Madrid
1510 € + IVA
25 Nov 2019
De 09:00 a 15:00 h.
Core Madrid
1510 € + IVA

¿Necesitas Ayuda?

Consúltanos si necesitas información de nuestros cursos o masters.

 

Contacta con Core Networks