Course description
Guided Project: Create & Load tables in PostgreSQL database
PostgreSQL, with over 35 years of development, is a popular open-source object-relational database system. Its website boasts of millions of users. Developers use PostgreSQL to build applications, store and protect data, and manage data. pgAdmin is a graphical user interface (GUI) tool that enables users to administer PostgreSQL databases without using the command line.
In this hands-on guided project, you will learn how to use the pgAdmin GUI tool with PostgreSQL. You will gain practical skills such as how to create a database, how to create tables, and how to load data into tables manually and automatically with script files. By the end of this hands-on guided project, you will understand the fundamentals of pgAdmin and PostgreSQL and be able to create databases and tables on your own.
Your lab provides access to a Cloud based IDE that has all of the required software, including PostgreSQL, installed. All you need is a recent version of a modern web browser to complete this project.
Upcoming start dates
Suitability - Who should attend?
Prerequisites
For this project, you will need:
- Access to a web browser
- A working Internet connection
Outcome / Qualification etc.
What you'll learn
After completing this hands-on guided project, you’ll be able to:
- Create a database using pgAdmin with PostgreSQL
- Create tables
- Load data into tables manually using the pgAdmin GUI
- Load data into tables using a text/script file
Course delivery details
This course is offered through IBM, a partner institute of EdX.
1 hours per week