Back to Catalog

Create Tables and Load Data in PostgreSQL using pgAdmin

BeginnerGuided Project

In this project, you will learn how to create tables and load data in the PostgreSQL database service using the pgAdmin graphical user interface (GUI) tool.

Language

  • English

Topic

  • Computer Science & Information Technology

Enrollment Count

  • 684

Offered By

  • IBM

Platform

  • SkillsNetwork

Last Update

  • April 15, 2025
About this Guided Project

About This Guided Project

In this project, you will learn how to create tables and load data in the PostgreSQL database service using the pgAdmin graphical user interface (GUI) tool.



Objectives

After completing this project, you will be able to use pgAdmin with PostgreSQL to:
  • Create a database
  • Create tables
  • Load data into tables manually using the pgAdmin GUI
  • Load data into tables using a text/script file

Requirements

To complete this project you will need the PostgreSQL relational database service which will be available as part of the IBM Skills Network Labs (SN Labs) Cloud IDE. SN Labs is a virtual lab environment used in this project



Frequently Asked Questions

Do I need to install any software to participate in this project?


Everything you need to complete this project will be provided to you via the Skills Network Labs and it will all be available via a standard web browser.



What web browser should I use?


The Skills Network Labs platform works best with current versions of Chrome, Edge, Firefox, Internet Explorer, or Safari.


Instructors

Sandip Saha Joy

Cognitive Data Scientist

An aspiring data scientist who enjoys connecting the dots: be it ideas from different disciplines, people from different teams, or applications from different industries. Have an academic background in computing science and strong technical skills in computer vision, machine learning and data science.

Read more