Advanced MySQL - Preparation for 1Z0-909 MySQL 8.0 Database Developer Oracle Certification
Advanced MySQL - Preparation for 1Z0-909 MySQL 8.0 Database Developer Oracle Certification
Learn how to improve database performance using advanced SQL techniques. You'll learn how to optimize queries, indexes, and stored procedures for efficient databases. Additionally, we prepare you for the official 1Z0-909 MySQL 8.0 Database Developer Oracle Certified Professional Certification.
Specific goals | Temary
OBJECTIVES
- Creating tables and queries for optimal performance
- Mastering the use of indexes and execution plans to speed up queries
- Optimizing stored procedures for specific tasks
- Mastering transactions and concurrency controls
- Applying performance tuning techniques to real-time databases
SYLLABUS
- Review of basic SQL techniques
- Advanced subqueries and joins
- Stored procedures and performance
- Transactions and concurrency
- Ongoing performance monitoring and tuning
- Practical cases 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 a payment. Barcelona Activa does not manage or facilitate the certification process, which is completely external to this institution.
RECOMMENDED SQL and MYSQL TRAINING ITINERARY
Level 0
Introduction to relational databases - Online
Level 1
Manage databases with MySQL
Level 2
Advanced MySQL - Preparation for 1Z0-909 Oracle certification
Editions
General information
>> This activity prepares students to obtain the official certificate 1Z0-909 MySQL 8.0 Database Developer from Oracle. This action is voluntary and requires a payment. Barcelona Activa does not manage or facilitate the certification process, which is completely external to this institution.
>> In case the format is virtual via streaming, it will be carried out through the free platform Microsoft Teams. Registered individuals will receive the invitation link and access instructions by email before the session starts.
>> Entry to the classroom will not be allowed after 15 minutes once the activity has started.
>> The language in which each session is conducted is informed in the description of each activity.
>> Any of the training actions of Cibernàrium may be recorded through an image capture system that aims to subsequently disseminate them through a medium or support within the scope of the mission of Barcelona Activa to contribute to economic promotion and employment. In the recording process, images of attendees may eventually be recorded. Registration for Cibernàrium activities implies authorization for Barcelona Activa to use these images for the aforementioned purpose.
Trainer's person
KALE MOYANO
Personal Data Protection Law
There is a new version of Personal Information Protection law.
Please, accept it before continuing the registration.
