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.
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
- Lectures 0
- Quizzes 0
- Duration 1 week
- Skill level All levels
- Language English
- Students 0
- Assessments Yes