#16 | SQL Files With PostgreSQL | 12:33
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.
#15 | Inserting Data Into Our Database | 5:31
In this episode, we're going to learn how to insert data into our database using SQL's `INSERT` command.
#14 | Creating Our First SQL Table | 9:55
In this tutorial, we're going to learn how to create a table using SQL and PostgreSQL.
#13 | Cloud9 Workspace 101 | 11:47
Getting familiar with the Cloud9 workspace, terminal, and Ace editor.
#12 | Introduction to AWS Cloud9 | 9:04
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.
#11 | PgAmin Introduction | 8:53
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.
#10 | Create a Database | 6:55
A database is a collection of information that is electronically stored in a particular way for easy access. PostgreSQL is a database management system (DBMS), a tool used for retrieving information from the database using Structured Query Language (SQL).
#9 | GitHub Remote Repository | 11:31
In this episode, we're going to create our first local version control repository for our SQL projects and then connect it to a remote repository on GitHub.
#8 | Version Control Set Up | 10:11
Version control enables developers to record changes made to scripts, files, and folders while developing applications. After saving her work, the developer can then revert back to previous versions if and when the need arises. While developing applications, the developer, might have a compelling reason to revert to an older version of her code. This is where version control comes to the rescue.
#7 | PostgreSQL Database | 8:50
PostgreSQL is a powerful open-source object-relational database management systems (ORDBMS) that comes packed with many features and it is free to use. This is an introductory screen for anyone who is interested in learning about the Structured Query Language using PostgreSQL.