Offered By: IBM
Getting Started with PostgreSQL command line
In this project, you will use the PostgreSQL command line interface (CLI) to a create database and to restore the structure and contents of tables. Then you will learn how to explore and query tables. Finally, you will learn how to dump/backup tables from a database.
Continue readingGuided Project
891 EnrolledAt a Glance
In this project, you will use the PostgreSQL command line interface (CLI) to a create database and to restore the structure and contents of tables. Then you will learn how to explore and query tables. Finally, you will learn how to dump/backup tables from a database.
About This Guided Project
In this project, you will use the PostgreSQL command line interface (CLI) to a create database and to restore the structure and contents of tables. Then you will learn how to explore and query tables. Finally, you will learn how to dump/backup tables from a database.
Objectives
After completing this project, you will be able to use the PostgreSQL command line to:
- Create a database
- Restore the structure and data of a table
- Explore and query tables
- Dump/backup tables from a database
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.
Level
Beginner
Language
English
Course Code
GPXX0725EN