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:

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