COURSE

SQL and Databases: Advanced

In our SQL and Databases: Advanced course, you'll learn some advanced database concepts such as using indexes to speed up SQL queries.

At the start of this course, you will learn the basics of PostgreSQL, a popular and powerful open-source relational database designed to handle multiple connections at once. You will also learn how to work with PostgreSQL in conjunction with Python using the psycopg2 library, and how to work with PostgreSQL from the command line using psql.

When using psql, you will also learn how to create users and add permissions to control access to your Postgres database. Then you’ll learn how SQLite accesses data using the EXPLAIN clause and how you can take advantage of table indexes to speed up the access of data. Writing code in our interactive, browser-based environment, you’ll take advantage of indexing when querying multiple columns and how to use multi-column indexing to speed up certain queries.

After completing our SQL and Databases: Advanced course, you will feel confident working with PostgreSQL when using both the command line using psql and using Python using the psycopg2 library. You can also feel confident in being able to grasp advanced SQL concepts, and how to optimize your database to speed up the rate of data retrieval.

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.

START LEARNING

60+ FREE MISSIONS

By creating an account you agree to accept our terms of use and privacy policy.

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.