MISSION 114

Using PostgreSQL

Learn the basics of PostgreSQL, and how to use it from Python.

Objectives

  • Learn the basics of PostgreSQL.
  • Learn to create and manipulate tables in PostgreSQL.

Mission Outline

1. SQLite vs PostgreSQL
2. PostgreSQL overview
3. Psycopg2
4. Creating a table
5. SQL Transactions
6. Autocommitting
7. Executing queries
8. Creating a database
9. Deleting a database
10. Next steps
11. 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