MISSION 115

Command Line PostgreSQL

Learn how to work with PostgreSQL from the command line.

Objectives

  • Learn how to work with PostgreSQL from the command line.
  • Learn how to create a user and add permissions.

Mission Outline

1. The psql tool
2. Running SQL queries
3. Special PostgreSQL commands
4. Switching databases
5. Creating users
6. Adding permissions
7. Removing permissions
8. Superusers
9. Takeaways

sql-databases-advanced

Course Info:

Advanced

The median completion time for this course is 6.1 hours. View Details

This course requires a basic subscription. This course includes four missions and one installation tutorial.  It is the 13th course in the Data Analyst in Python path and Data Scientist in Python path.

START LEARNING FREE

Take a Look Inside