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

Course Info:

SQL and Databases: Advanced

Advanced

The average completion time for this course is 10-hours.

This course requires a basic subscription. This course includes four paid 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

Share On Facebook
Share On Twitter
Share On Linkedin
Share On Reddit