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.
Getting familiar with the Cloud9 workspace, terminal, and Ace editor.
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.
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).
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.
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.
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.