SQL Files With PostgreSQL
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.
Inserting Data Into Our Database
In this episode, we're going to learn how to insert data into our database using SQL's `INSERT` command.
Creating Our First SQL Table
In this tutorial, we're going to learn how to create a table using SQL and PostgreSQL.
Introduction to AWS Cloud9
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.
PgAmin Introduction
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.