دوراتنا

Working with Subqueries in SQL

Welcome to this project-based course, Working with Subqueries in SQL. In this project, you will learn how to use SQL subqueries extensively to query tables in a database. By the end of this 2-and-a-half-hour-long project, you will be able to use subqueries in the WHERE clause, FROM clause, and the SELECT clause to retrieve the desired result from a database. In this project, we will move systematically by first introducing the use of subqueries in the WHERE clause. Then, we will use subqueries in the FROM and SELECT clause by writing slightly complex queries for real-life applications.

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

Migrate to Cloud SQL for PostgreSQL using Database Migration Service

This is a self-paced lab that takes place in the Google Cloud console. In this lab, you migrate a stand-alone PostgreSQL database (running on a virtual machine) to Cloud SQL for PostgreSQL using a continuous Database Migration Service job and VPC peering for connectivity.

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

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

Performing Data Definition and Manipulation in SQL

In this 2-hour long project-based course, you will learn how to use SQL data definition statements for various data definition tasks and how to use SQL data manipulation statements for data manipulation tasks such as updating records in a table. In addition, you will learn how to upload a CSV file into a database using PostgreSQL.

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

Cloud SQL for PostgreSQL: Qwik Start

This is a self-paced lab that takes place in the Google Cloud console. Create a Google Cloud SQL PostgreSQL instance. Perform SQL operations using the GCP Console and the psql client.

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

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

SQL Mathematical Functions

Welcome to this project-based course, SQL Mathematical Functions. In this project, you will learn how to use SQL Mathematical Functions to manipulate tables in a database. By the end of this 2-hour-long project, you will be able to use different Mathematical Functions to retrieve the desired result from a database. In this project, you will learn how to use SQL Mathematical Functions like CEIL(), FLOOR(), RANDOM(), SETSEED(), ROUND(), TRUNC(), SQRT(), CBRT(), and POWER() to manipulate data in the employees database.

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

Using SQL String Functions to Clean Data

Welcome to this project-based course on Using SQL String Functions to Clean Data. In this project, you will learn how to perform data cleaning and manipulation using SQL string functions like LENGTH, UPPER & LOWER, REPLACE, TRIM, SUBSTRING, CONCAT, STRING_AGG, and COALESCE.

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

SQL Date Time Functions

Welcome to this project-based course, SQL Date Time Functions. In this project, you will learn how to use SQL Date Time Functions to manipulate tables with data datatypes in a database.

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

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

JSON and Natural Language Processing in PostgreSQL

Within this course, you’ll learn about how PostgreSQL creates and uses inverted indexes for JSON and natural language content. We will use various sources of data for our databases, including access to an online API and spidering its data and storing the data in a JSON column in PostgreSQL. Students will explore how full-text inverted indexes are structured. Students will build their own inverted indexes and then make use of PostgreSQL built-in capabilities to support full-text indexes.

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

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

PostgreSQL for Everybody

Across these four courses, you’ll learn how to use the PostgreSQL database and explore topics ranging from database design to database architecture and deployment. You’ll also compare and contrast SQL and NoSQL approaches to database design. The skills in this course will be useful to learners doing data mining or application development.

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

Database Design and Basic SQL in PostgreSQL

This first course in PostgreSQL for Everybody explores the use of SQL in the PostgreSQL environment and introduces SQL techniques and commands. This course also explores data modeling and database relationships, while introducing hands-on assignments to work within PostgreSQL.

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

Using Ruby on Rails with Cloud SQL for PostgreSQL on Cloud Run

This is a self-paced lab that takes place in the Google Cloud console. In this lab, you'll learn how to deploy a new Ruby on Rails application using Google Cloud SQL for PostgreSQL on Cloud Run.

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

Database Architecture, Scale, and NoSQL with Elasticsearch

In this final course, you will explore database architecture, PostgreSQL, and various scalable deployment configurations. You will see how PostgreSQL implements basic CRUD operations and indexes, and review how transactions and the ACID (Atomicity, Consistency, Isolation, Durability) requirements are implemented. You’ll learn to use Elasticsearch NoSQL, which is a common NoSQL database and a supplement to a relational database to high-speed search and indexing.

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

حماية قاعدة البيانات من هجمات ال Injections باستخدام Java

فى نهاية المشروع هتقدر تعمل PostgreSQL Database مبسطة باستخدام Java., خلال المشروع ، هنتعامل مع ال Database عن طريق Java Application و هتستخدم parameterized queries لأجل حماية ال Database من هجمات الSQL Injections . و اخيرا هنحمي الDatabase بطرق متعددة ومعروفة في عالم الSoftware Development . المشروع مستواه متوسط لالDevelopers و الSoftware Engineers اللي شغالين في مجال الtech ومهتمين بتحسين مهاراتهم في Java في مجال ال Software Development و مهتمين بال Backend Systems اللي Secure و محصنة ضد الهجمات
هنستخدم Java لامكانيات والطرق المتعددة لحماية ال Queries من ال Injection Attacks

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

Getting Started with Data Warehousing and BI Analytics

Kickstart your Data Warehousing and Business Intelligence (BI) Analytics journey with this self-paced course. You will learn how to design, deploy, load, manage, and query data warehouses and data marts. You will also work with BI tools to analyze data in these repositories.

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

Connect an App to a Cloud SQL for PostgreSQL Instance

This is a self-paced lab that takes place in the Google Cloud console. In this lab you will create a Kubernetes cluster and deploy a simple application to that cluster. Then, connect the application to the supplied Cloud SQL for PostgreSQL database instance and confirm that it is able to write to and read from it.

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

How to Implement Multitenancy in Django

In this 1-hour 30 minutes long project-based course, you will learn how to implement multitenancy in Django.
You will learn about multitenancy and postgresql database. You will also learn to create a multitenant API in Django and finally learn how to test multitenant architecture using postman tool.
For this project, You should have basic knowledge of Django and creating simple API in Django. you should also know about how to use postman tool to test API.

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

Design and Build a Data Warehouse for Business Intelligence Implementation

The capstone course, Design and Build a Data Warehouse for Business Intelligence Implementation, features a real-world case study that integrates your learning across all courses in the specialization.

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

Guided Project: Create & Load tables in PostgreSQL database

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

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

Database Architecture, Scale, and NoSQL with Elasticsearch

In this fourth and final course in PostgreSQL for Everybody, learners will explore database architectures, CRUD operations and how ACID requirements are implemented in PostgreSQL. Learners will compare how to scale SQL and NoSQL database services and build NoSQL applications using ElasticSearch.

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

JSON and Natural Language Processing in PostgreSQL

In this third course in PostgreSQL for Everybody, learners will learn how PostgreSQL creates and uses JSON and natural language content. Learners will explore using multiple sources of data and how text is structured within PostgreSQL.

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