COURSE

SQL and Databases: Advanced

Learn how to work with PostgreSQL, customize databases using indexing and how to improve database performance.

PostgreSQL, issues related to database performance including indexing and multi-column indexing.

By the end of this course, you'll be able to:

  • Work with PostgreSQL.
  • Understand how database indexes work.
  • Implement database indexes to speed up SQL queries.
sql-databases-advanced

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

Learn SQL and Databases

Using PostgreSQL

Learn the basics of PostGreSQL and how to use it with Python.

Command Line PostgreSQL

Learn how to work with PostgreSQL from the command line.

Project: PostgreSQL Installation

Learn how to install PostgreSQL and the Psycopg2 library.

Introduction to Indexing

Learn about how SQLite accesses data and how to use indexed to speed this up.

Multi-Column Indexing

Learn how to take advantage of indexing when querying multiple columns.