دوراتنا

Database Creation and Modeling using MYSQL Workbench

In this 1-hour long project-based course, you will be able to identify and fully comprehend the basics of the MYSQL workbench and create a new connection to the local server. you will also learn how to create a new database and drop it, create new tables, and delete them. Moreover, You will be able to rename columns of a table, connect tables with each other, and add data to tables.

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

Data Science Math Skills

Data science courses contain math—no avoiding that! This course is designed to teach learners the basic math you will need in order to be successful in almost any data science math course and was created for learners who have basic math skills but may not have taken algebra or pre-calculus. Data Science Math Skills introduces the core math that data science is built upon, with no extra complexity, introducing unfamiliar ideas and math symbols one-at-a-time.

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

Guided Project: Get Started with MySQL database

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

Datastream MySQL to BigQuery

This is a self-paced lab that takes place in the Google Cloud console. Learn to migrate MySQL Databases to BigQuery using Datastream and Dataflow. Datastream is a serverless and easy-to-use Change Data Capture (CDC) an…

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

Deploy a Complete Wordpress Video Blog in Microsoft Azure

In this one-hour project, you will learn how to use Microsoft Azure Cloud Platform and compute services like Azure Web Apps, Azure Storage Accounts, and Azure Database for MySQL to host and deploy a Video Blog WordPress Website. WordPress is a world-class content management platform to create websites, blogs, e-learning systems, and others. Once you're done with this project, you will be able to deploy a Video Blog WordPress website using Azure compute services in any Azure region you want with just a few steps.

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

Data Manipulation and Management using MYSQL Workbench

By the end of this project, you will be able to manage data efficiently in a specific database using MYSQL Workbench. You will be able to select data from tables from your database and use keywords in select statements such as LIMIT and Top. You will be able to update the data and filter them using where statements, and also apply conditions with different ways and keywords such as like, and, or, and between.

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

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

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

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

Database and Multi-Cloud Assessment with StratoZone

This is a self-paced lab that takes place in the Google Cloud console. Collect database information from Oracle, MySQL, PostgreSQL and Microsoft SQL, import data generated from AWS/Azure account into StratoZone for analysis.

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

MySQL Tutorial

Enhance your web development skills by starting with the W3Schools MySQL tutorial. MySQL is a widely-used, open-source relational database management system that is suitable for both small and large applications. The self-paced course includes text-based modules, interactive examples, and exercises to test your understanding as you progress. W3schools is the world's leading web developer learning site, and its tutorials have been used by millions of learners worldwide.

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

Online Data Migration to BigQuery using Striim

This is a self-paced lab that takes place in the Google Cloud console. Continuous Data Replication from Cloud SQL for MySQL to BigQuery using Striim

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

Database Clients

Explore how to write database driven applications in Python by creating various types of clients that connect to MySQL databases using Python code and Python-related MySQL features and tools.

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

Manage Data for an Online Grocer Using MySQL Workbench

In this project, you’ll help Greenspot Grocer, an online grocery store, prepare for rapid growth and planned expansion.

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

Sort and Filter Data in SQL using MySQL Workbench

In this project you will use MySQL Workbench to write SQL queries that retrieve, sort, and filter data from tables in a relational database. Adding filtering to a query ensures that only the data needed is displayed in the query result. Sorting is applied to arrange the rows in that query result into an order that is meaningful to the data’s user. Adding code to an SQL query to filter and sort data generates a query result that makes data analysis easier for users, enabling more effective decision-making. Note: This course works best for learners who are based in the North America region.

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

Data Management in Python: Build a Login System for your App

This guided project, Data Management in Python: Build a Login System for your App, will help an intermediate Python programmer looking to use a MySQL database in Python for simple data input and querying.
In this project, you will learn how to use MySQL to create a database table, utilize the MySQL driver to connect a Python application to a database, demonstrate the ability to test a MySQL database existence using Python, demonstrate the ability to query data from a MySQL database using Python, and demonstrate the ability to insert data into a MySQL database using Python.

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

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

Meta Back-End Developer

Ready to gain new skills and the tools developers use to create websites and web applications? This certificate, designed by the software engineering experts at Meta—the creators of Facebook and Instagram, will prepare you for an entry-level career as a back-end developer. In this program, you’ll learn: Python Syntax—the most popular choice for machine learning, data science and artificial intelligence. In-demand programming skills and how to confidently use code to solve problems. Linux commands and Git repositories to implement version control.

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

Analyze Data in a Model Car Database with MySQL Workbench

In this project, you’ll perform exploratory data analysis for Mint Classics Company, a retailer of model cars. The company is looking to close one of its storage facilities. Your objective is to recommend inventory reduction strategies that won’t negatively impact customer service. Using MySQL Workbench, you’ll familiarize yourself with the sample database, run SQL queries to identify factors affecting storage space and propose inventory reduction approaches.

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

Complex Retrieval Queries in MySQL Workbench

In this intermediate-level course you will use MySQL Workbench to expand your basic SQL query-writing skills with more complex examples and activities. In hands-on activities in MySQL Workbench, you will write and execute SQL queries that retrieve data from multiple tables. In addition, you will generate queries that summarize data and perform calculations. Nested queries and SQL scripting rounds out the course content.

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

Meta Database Engineer

Want to get started in the world of database engineering? This program is taught by industry-recognized experts at Meta. You’ll learn the key skills required to create, manage and manipulate databases, as well as industry-standard programming languages and software such as SQL, Python, and Django used for supporting outstanding websites and apps like Facebook, Instagram and more. In this program, you’ll learn: Core techniques and methods to structure and manage databases. Advanced techniques to write database driven applications and advanced data modeling concepts.

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

Create a Database with the Modeling Tool in MySQL Workbench

In this project you will use the Modeling and Design Tool in MySQL Workbench to design and create a multiple-table relational database. As a DBMS (database management system), MySQL is used by many organizations for managing a variety of types and sizes of databases. MySQL Workbench acts as an integrated development environment allowing users to work with relational databases using a visual user interface rather than the command line.

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

MySQL with Information Technology

In this project you will explore how MySQL fits into information systems. You will become familiar with MySQL features as you explore database management system options and participate in hands-on exercises using MySQL Workbench to create and populate a table in a MySQL relational database. 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
• 3 ساعات
• الإنجليزية

Excel to MySQL: Analytic Techniques for Business

Formulate data questions, explore and visualize large datasets, and inform strategic decisions. In this Specialization, you’ll learn to frame business challenges as data questions. You’ll use powerful tools and methods such as Excel, Tableau, and MySQL to analyze data, create forecasts and models, design visualizations, and communicate your insights.

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

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

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

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