Our Courses

موضوعات MySQL المتقدمة

في هذه الدورة التدريبية، ستبدأ في تجاوز عبارات SQL البسيطة في MySQL إلى مستوى متقدم في هندسة قواعد البيانات. عندما تكمل هذه الدورة التدريبية، ستتمكن من: - استخدام عبارات التحكم والمتغيرات في سياقات مختلفة في MySQL\n - تطوير الدوال والإجراءات المحددة من قبل المستخدم - تحسين استعلامات قاعدة بيانات MySQL - إظهار معرفة عملية بتعبيرات الجداول الشائعة ونوع بيانات JSON - فهم كيفية ووقت استخدام المشغلات والأحداث - استخدام الاستعلامات الفرعية وJOINS وطرق العرض والمعاملات لإجراء تحليل البيانات - استخدام تقنيات تحسين قاعدة البيانات مثل معاملات MySQL ستكتسب خبرة في مهارات قاعدة بيانات MySQL المتقدمة ال

• Course by
• Self Paced
• Arabic

Proyecto final para desarrolladores de back-end

El proyecto final le permite demostrar múltiples habilidades resolviendo un auténtico problema del mundo real. Pondrá a prueba sus habilidades en el desarrollo back-end de la pila completa en un escenario de la vida real mediante la composición de una aplicación web Django. Cada módulo incluye una breve recapitulación del contenido (y enlaces a este) que usted ha cubierto en cursos anteriores de este programa. Utilizará una codificación limpia y libre de errores para crear un servidor web Django con múltiples puntos finales de API y conectarlo a una base de datos MySQL.

• Course by
• Self Paced
• 17 hours
• Spanish

كيفيه انشاء API call باستخدام PHP and MYSQL

في نهاية المشروع ده هتقدر تنشئ API Call باستخدام PHP and MYSQL .

• Course by
• Self Paced
• 2 hours
• Arabic

مهندس Meta لقواعد البيانات

Want to get started in the world of database engineering? This program is taught by industry-recognized experts at Meta.

• Course by
• Self Paced
• Arabic

Relational Databases - MySQL - قواعد البيانات العلائقية

في هذه الدورة التدريبية القائمة على المشروع والتي تستغرق ساعة واحدة، ستتعلم كيفية استخدام لغة الاستعلام البنائية SQL للحصول على معلومات من قاعدة البيانات.

• Course by
• Self Paced
• 3 hours
• Arabic

La pila completa

A medida que se prepara para el desarrollo de Back-end, practique la combinación de múltiples habilidades para construir una aplicación Django de pila completa. Comenzará configurando un entorno para un proyecto práctico local y refactorizando los Front-end y los Back-end de una aplicación existente.

• Course by
• Self Paced
• 21 hours
• Spanish

Guided Project: Get Started with MySQL database

• Course by
• Self Paced
• English

Migrating to Cloud SQL from Amazon RDS for MySQL Using Database Migration Service

This is a self-paced lab that takes place in the Google Cloud console. In this lab, you migrate MySQL data from an Amazon RDS instance for MySQL to Cloud SQL for MySQL using a one-time Database Migration Service job and an IP allowlist for connectivity. After you create and run the migration job, you confirm that the data have been successfully migrated to your Cloud SQL for MySQL instance.

• Course by
• Self Paced
• 2 hours
• English

Simple Retrieval Queries in MySQL Workbench

In this beginning-level course you will use MySQL Workbench to write basic SQL queries that retrieve data from tables in a relational database.

• Course by
• Self Paced
• 3 hours
• English

Cloud SQL for MySQL: Qwik Start

This is a self-paced lab that takes place in the Google Cloud console. Create a Google Cloud SQL MySQL instance and perform SQL operations using Google Cloud Platform Console and mysql client. Watch this short video, Manage PostgreSQL and MySQL Databases Easily with Cloud SQL.

• Course by
• Self Paced
• 1 hour
• English

Introduction to Relational Database and SQL

In this guided project, you will get hands-on experience working with a relational database using MySQL Workbench from Oracle.

• Course by
• Self Paced
• 3 hours
• English

Aggregate Data in SQL using MySQL Workbench

In this project you will use MySQL Workbench to write SQL queries that aggregate (group) data. Incorporating aggregate functions like COUNT, SUM, and AVG, your SQL queries will group and summarize data. Data that is aggregated and presented in a logical format makes it a more valuable decision-making tool for users. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

• Course by
• Self Paced
• 2 hours
• English

Migrating MySQL User Data When Running Database Migration Service Jobs

This is a self-paced lab that takes place in the Google Cloud console. In this lab, you learn how to migrate MySQL user data when running Database Migration Service jobs. First, you identify the existing MySQL users and update DEFINER to INVOKER for database objects on the source instance. Next, you create and save a Database Migration Service job. Then, before running the migration job, you create the necessary users on the destination database instance.

• Course by
• Self Paced
• 2 hours
• English

Scripting with Python and SQL for Data Engineering

In this third course of the Python, Bash and SQL Essentials for Data Engineering Specialization, you will explore techniques to work effectively with Python and SQL. We will go through useful data structures in Python scripting and connect to databases like MySQL. Additionally, you will learn how to use a modern text editor to connect and run SQL queries against a real database, performing operations to load and extract data. Finally, you will use extracted data from websites using scraping techniques.

• Course by
• Self Paced
• 18 hours
• English

Cloud SQL with Terraform

This is a self-paced lab that takes place in the Google Cloud console. In this hands-on lab you will learn to create Cloud SQL instances with Terraform, then set up the Cloud SQL Proxy, testing the connection with both MySQL and PostgreSQL clients.

• Course by
• Self Paced
• 1 hour
• English

SQL Joins

In this 1-hour long project-based course, you will learn how to utilize MySQL joins in your queries. By the end of this project, you will create a number of examples that will develop your learning around joins in SQL. This course will enable you to take your beginner knowledge of SQL to the next level by enabling you to utilize joins. Thus, being able to develop more complex queries. This course will provide students with the knowledge behind different joins that are available in MySQL language such as inner join, outer join, and left join.

• Course by
• Self Paced
• 3 hours
• English

Working with MySQL DB instance using AWS RDS

In this 1-hour long project-based course, you will learn how to create, connect & delete a MySQL DB instance using AWS RDS.

• Course by
• Self Paced
• 2 hours
• English

Relational Database Administration (DBA)

This course helps you develop the foundational skills required to perform the role of a Database Administrator (DBA) including designing, implementing, securing, maintaining, troubleshooting and automating databases such as MySQL, PostgreSQL and Db2.

• Course by
• Self Paced
• 35
• English

Building a Company's database using MySQL and SQL

By the end of this project, you will create a database for a company using MYSQL and SQL commands.

• Course by
• Self Paced
• 2 hours
• English

Build and Execute MySQL, PostgreSQL, and SQLServer to Data Catalog Connectors

This is a self-paced lab that takes place in the Google Cloud console. In this lab you will explore existing datasets with Data Catalog and mine the table and column metadata for insights.

• Course by
• Self Paced
• 1 hour
• English

Create a Python Application using MySQL

Data plays a crucial role in application development.

• Course by
• Self Paced
• 3 hours
• English

Introduction to Databases for Back-End Development

Back-end developers write applications that end-users use to interact with databases. Some common tasks that end-users carry out using these applications include storing, searching, extracting and manipulating data. Therefore, it’s essential that all back-end developers possess strong knowledge and experience with how databases work. In this course, you’ll receive an introduction to databases and explore the different ways in which they can be used to store and manage data. You’ll also learn to distinguish between different types of database management systems.

• Course by
• Self Paced
• 27 hours
• English

Combine Multiple Pieces of Data in SQL

In this project, you will use MySQL Workbench to write SQL queries that concatenate or combine multiple data values.

• Course by
• Self Paced
• 3 hours
• English

How to Use SQL with Large Datasets

By the end of this project, you will use SQL to manage a large COVID-19 dataset using MySQL Workbench.

• Course by
• Self Paced
• 3 hours
• English

Data Engineering Capstone Project

Showcase your skills in this Data Engineering project! In this course you will apply a variety of data engineering skills and techniques you have learned as part of the previous courses in the IBM Data Engineering Professional Certificate. You will demonstrate your knowledge of Data Engineering by assuming the role of a Junior Data Engineer who has recently joined an organization and be presented with a real-world use case that requires architecting and implementing a data analytics platform. In this Capstone project you will complete numerous hands-on labs.

• Course by
• 13 hours
• English