Advanced SQL for Data Analysis
In our Advanced SQL for Data Analysis 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 Advanced SQL for Data Analysis 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:
Learn SQL and Databases
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.
Learn how to take advantage of indexing when querying multiple columns.