Our Courses

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
• 3 hours
• English

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 hours
• English

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 hours
• English

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 hour
• 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

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 hours
• English

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 hour
• 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 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 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

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 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

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
• English

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
• English

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 hour
• English

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 hours
• English

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

فى نهاية المشروع هتقدر تعمل PostgreSQL Database مبسطة باستخدام Java.

• Course by
• Self Paced
• 3 hours
• Arabic

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 hour
• English

Parametrize Queries to Protect Against Injections with Java

By the end of this project you will be able to build a simple PostgreSQL database, we will interact with this simple database by creating a simple Java application that will use parameterized queries so as to prevent SQL injection attacks by using various well known methods that are widely used in the industry to protect against SQL injection attacks.

• Course by
• Self Paced
• 3 hours
• English

SQL CASE Statements

Welcome to this project-based course, SQL CASE Statements. In this project, you will learn how to use SQL CASE statements to query tables in a database. By the end of this 2-hour long project, you will be able to write simple CASE statements to retrieve the desired result from a database. Then, we will move systematically to write more complex SQL CASE statements. Furthermore, we will see how to use the CASE clause together with aggregate functions, and SQL joins to get the desired result you want from tables in a database.

• Course by
• Self Paced
• 3 hours
• English

Datastream: PostgreSQL Replication to BigQuery

This is a self-paced lab that takes place in the Google Cloud console. In this lab you will replicate data from a PostgreSQL database to BigQuery.

• Course by
• Self Paced
• 1 hour
• English

Guided Project: Create & Load tables in PostgreSQL database

• Course by
• Self Paced
• 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

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
• English

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
• English