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.
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.
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.