دوراتنا

MySQL تكنولوجيا المعلومات مع

فى نهاية هذا المشروع ، سوف تكون قادرًا على تحديد وفهم أساسيات workbench MYSQL وإنشاء اتصال بالserver المحلي. خلال المشروع هتقدر تنشئ قاعدة بيانات جديدة ومسحها وتضيف جداول جديدة وحذفها. علاوة على ذلك ، ستتمكن من تسمية أعمدة الجدول فى الناتج. وأخيرًا هتقدر أعمدة وتطبيق بعض الميزات على الأعمدة باستخدام بعض الكلمات الرئيسية مثل PRIMARY KEY و و AUTO_INCREMENT وWHERE وAS وتحديث الجداول ببيانات جديدة..
هذا المشروع للمبتدئين في مجال تصميم قواعد البيانات. هيساعدك فى أساسيات إنشاء قاعدة البيانات . هتشوف أمثلة و هيبقى عندك الفرصة لتجربة كل اللى اتعلمته على هيئة اختبارات و مهام صغيرة.

• Course by
• Self Paced
• 3 ساعات
• عربي

مطوّر الواجهة الخلفية من Meta

Ready to gain new skills and the tools developers use to create websites and web applications?

• Course by
• Self Paced
• عربي

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

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

• Course by
• Self Paced
• 2 ساعات
• عربي

تعليم مبادئ ال SQL Syntax

في نهاية المشروع ده هتقدر تبني
Database باستخدام ال SQL Queries. ، خلال المشروع ده، هتكون قادر تملي ال Database بالمعلومات و تعمل Tables جوا ال Database وهتكون قادر تستخدم ال SQL Aggregate Functionsعلي ال Tables.، وأخيرا ، هتقدر نكتب ال SQL Queries Using Conditions وهتكون قادر ت match ال strings باستخدام ال Wildcards.

• Course by
• Self Paced
• 3 ساعات
• عربي

تطوير الويب الكامل

بينما تستعد لوظيفتك في مجال تطوير الواجهة الخلفية، يمكنك التدرب على الجمع بين مهارات متعددة لإنشاء تطبيق Django متكامل. ستبدأ بإعداد بيئة لمشروع عملي محلي، وإعادة بناء الواجهات الأمامية والخلفية لتطبيق موجود.

• Course by
• Self Paced
• عربي

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

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

• Course by
• Self Paced
• 3 ساعات
• عربي

Guided Project: Get Started with MySQL database

• Course by
• الإنجليزية

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. You will be able to create databases and tables, form relationships between the tables , write SQL commands to manipulate your data, write SQL functions to perform mathematical operations on your data and write regular expressions.
This project will help you get your hands on the Structured query language which is the language used to communicate with databases and how to form entity relationships between tables.

• Course by
• Self Paced
• 2 ساعات
• الإنجليزية

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 ساعات
• الإنجليزية

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 ساعات
• الإنجليزية

Set up your dev environment for LAMP web developers on Linux

By the end of this project, you will set up your development environment for LAMP web developers on Linux.
Often, a dynamic web application consists of many different technologies and programming languages. Creating a web application with Linux, Apache (or NGINX), MySQL (or MariaDB), and PHP is usually referred to as a LAMP stack of technologies. In this project we will focus on installation and setup, rather that the code itself. This will allow you to use the same scaffolding approach for your future LAMP applications.

• Course by
• Self Paced
• 3 ساعات
• الإنجليزية

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 ساعات
• الإنجليزية

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 ساعات
• الإنجليزية

Learn PHP Database Connectivity

In this 1.5-hours long project-based course, you will (Learn PHP database connectivity , Build Web pages with
back-end database).
You will learn PHP database connectivity functions , how to connect into a back-end database, how to insert data into a database and modify them with PHP scripts.
You will learn to work with XAMPP server and MySQL as a back-end database and by the end of this project you will be able to create professional web apps with back-end database.

• Course by
• Self Paced
• 2 ساعات
• الإنجليزية

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 ساعات
• الإنجليزية

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 ساعات
• الإنجليزية

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 ساعات
• الإنجليزية

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
• الإنجليزية

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 ساعات
• الإنجليزية

Create a Python Application using MySQL

Data plays a crucial role in application development. It plays such a crucial role that there are people called Database Administrators that specialize in just organizing the data. The traditional database used to be, and often still is, a relational database. MySQL is one of the most popular relational databases and is backed by the Oracle corporation as well. This provides the developer with a variety of online resources.

• Course by
• Self Paced
• 3 ساعات
• الإنجليزية

Data Warehousing with Oracle: Design a Database

This Guided Project Data Warehousing with Oracle: Design a Database for Business Intelligence is for learners who have database administration and data warehousing experience but want to learn more about designing databases and models for business intelligence. In this 1.5-hour long project-based course, you will learn how to evaluate the guiding principles of data warehousing, summarize data from multiple sources, and apply data warehouse business intelligence tools. To achieve this, we will work through the guided steps using Oracle MySQL Workbench.

• Course by
• Self Paced
• 3 ساعات
• الإنجليزية

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 ساعات
• الإنجليزية

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. Since a database is typically designed to store pieces of data at the atomic level, it is often necessary to put pieces back together to make data more useful to a user. A good example of that would be concatenating a customer’s first name and last name to produce a mailing label.

• Course by
• Self Paced
• 3 ساعات
• الإنجليزية

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.
MySQL is a widely used relational database and can be used with large datasets if it is managed appropriately. This may include using the proper database engine, indexing the database, creating summary tables, and using proper database queries.

• Course by
• Self Paced
• 3 ساعات
• الإنجليزية

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 ساعات
• الإنجليزية