So far we have learned how to use PostgreSQL to create a SQL database, table, and insert data using the PostgreSQL console. In this episode, we're going to simplify things a little by using SQL files.
In this episode, we're going to learn how to insert data into our database using SQL's `INSERT` command.
In this tutorial, we're going to learn how to create a table using SQL and PostgreSQL.
In this tutorial, we're going to get set up with Amazon Web Services (AWS) Cloud9, create connect to our PostgreSQL database on Cloud9 and create a database.
If you prefer to use a graphical user interface (GUI), you can install pgAdmin. Installing pgAdmin is outside the scope of this tutorial because it is easy to install and there is great documentation online on how to install it.