Breadcrumb

Activity Record

Specialized
 

MySQL Level 2: Advanced SQL - Oracle MySQL 8.0 Database Developer 1Z0-909 Certificate Preparation

Learn how to improve database performance using advanced SQL techniques. You'll learn how to optimize queries, indexes, and stored procedures for efficient databases. In addition, we prepare you for the official 1Z0-909 MySQL 8.0 Database Developer certification from Oracle.

Specific goals | Temary

OBJECTIVES

< class="lh-1 main-list-t">
  • Creating tables and queries for the best performance
  • Master the use of indexes and execution plans to speed up queries
  • Optimize stored procedures for specific tasks
  • Master transactions and concurrency controls
  • Optimize stored procedures for specific tasks
  • Apply performance tuning techniques to databases in real time

  • SYLLABUS

    1. Basic SQL Techniques Review
    2. Subqueries and advanced joins
    3. Stored procedures and performance
    4. Transactions and concurrency
    5. Continuous performance monitoring and adjustment
    6. Case studies and problem-solving exercises

    INFO: This activity prepares students to obtain the official certificate 1Z0-909 MySQL 8.0 Database Developer from Oracle. This action is voluntary and requires payment. Barcelona Activa does not manage or facilitate the certification process, which is completely external to this institution.


    RECOMMENDED SQL AND MYSQL TRAINING PATH

    Editions

    Edition 1
    Duration: 5 sessions (20h)
    Dates: From 16/02/2026 to 20/02/2026
    Modality: Attended session
    Language: Catalan
    Dates: From 16/02/2026 to 20/02/2026
    5 onsite sessions at:
    Cibernàrium-22@ - Carrer Roc Boronat, 117 - 127, BARCELONA
  • Monday 16 February, 15:30h - 19:30h
  • Tuesday 17 February, 15:30h - 19:30h
  • Wednesday 18 February, 15:30h - 19:30h
  • Thursday 19 February, 15:30h - 19:30h
  • Friday 20 February, 15:30h - 19:30h
  • Registration closed.

    General information

    . This action is voluntary and requires payment. Barcelona Activa does not manage or facilitate the certification process, which is completely external to this institution.

    Modality: Attended session
    Duration: 5 sessions (20h)
    Language: Catalan
    Dates: From 16/02/2026 to 20/02/2026
    Location: Cibernàrium-22@ - Carrer Roc Boronat, 117 - 127, BARCELONA
    Registration closed.

    Theme: Data / Live specialized training

    Trainer's person

    ISMAEL

    KALE MOYANO

      Personal Data Protection Law

    Personal Data Protection Law

    There is a new version of Personal Information Protection law.
    Please, accept it before continuing the registration.

      You are registering

    MySQL Level 2: Advanced SQL - Oracle MySQL 8.0 Database Developer 1Z0-909 Certificate Preparation: Edition 1

    Attended session

    Mon 16/02/26 15:30-19:30h

    Cibernàrium-22@

    Carrer Roc Boronat, 117 - 127,

    BARCELONA

    Attended session

    Tue 17/02/26 15:30-19:30h

    Cibernàrium-22@

    Carrer Roc Boronat, 117 - 127,

    BARCELONA

    Attended session

    Wed 18/02/26 15:30-19:30h

    Cibernàrium-22@

    Carrer Roc Boronat, 117 - 127,

    BARCELONA

    Attended session

    Thu 19/02/26 15:30-19:30h

    Cibernàrium-22@

    Carrer Roc Boronat, 117 - 127,

    BARCELONA

    Attended session

    Fri 20/02/26 15:30-19:30h

    Cibernàrium-22@

    Carrer Roc Boronat, 117 - 127,

    BARCELONA

    Personal information

    Full Name:

    Screen Name: 20101

    Email: default@liferay.com

    I agree registration conditions