SQL Episodes

Categories
Kode47

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.


Kode47

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.


Kode47

Creating Our First SQL Table

In this tutorial, we're going to learn how to create a table using SQL and PostgreSQL.


Kode47

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.


Kode47

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.