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:

SQL and Databases: Advanced

Advanced

The median completion time for this course is 6.1 hours.

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