MySQL Training in Mexico City

This instructor-led, live training in Mexico City (online or onsite) is aimed at advanced-level developers who wish to learn and use MySQL and database technologies for building web applications.

By the end of this training, participants will be able to:

• Write SQL queries to retrieve, filter, sort, and aggregate data.
• Perform data manipulation operations such as inserting, updating, and deleting data.
• Implement advanced SQL concepts such as subqueries, derived tables, and conditional logic.
• Integrate MySQL with popular programming languages and execute queries from application code.

This SQL training program is designed for individuals seeking to acquire the essential skills required to extract, analyze, and report on data from any database. Participants will learn:

• how to formulate SQL queries
• the concept of relational databases and how to utilize them
• the nature of relations and how to establish them
• data structure fundamentals
• distinctions among SQL dialects (Oracle, T-SQL, ANSI)
• hands-on skills for constructing queries

While this course focuses on generic ANSI SQL, the knowledge gained is applicable to any relational database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL, and others.

Target Audience: IT professionals aiming to become DBAs or database support specialists for MySQL on Linux and Windows platforms.

Format: 40% theory/lectures, 60% practical hands-on labs

The MariaDB Administration training course is designed for individuals seeking to manage the MariaDB database server. This comprehensive program covers all essential responsibilities of a database administrator.

Participants will gain a deep understanding of how the MariaDB Database operates, explore the available tools and their applications, and learn to secure and configure the MariaDB Database Server effectively. Throughout the training, you will master user account management and understand the mechanics of the MariaDB Access Privilege System. Additionally, you will acquire skills in database maintenance, backup and recovery procedures, and crash recovery techniques.

In this instructor-led live training held in Mexico City, participants will learn how to install, configure, and manage MariaDB for high availability and performance. Other topics include backup and recovery, security, and clustering.

This course is designed for database administrators.

It explores high-availability solutions utilizing Galera Cluster.

You will gain foundational knowledge of Galera technology, along with advanced insights and practical expertise in configuring, optimizing, and managing a Galera Cluster.

The MySQL Administration training program is designed for individuals seeking to master the administration of MySQL database servers. This comprehensive course encompasses all essential responsibilities of a database administrator.

Participants will gain a thorough understanding of MySQL’s architecture, the available tools, and their practical applications. The curriculum covers securing and configuring the MySQL server, managing user accounts, and navigating the MySQL Access Privilege System. Additionally, attendees will learn how to maintain database integrity, execute backups and recoveries, and perform crash recovery operations.