Kode47


Kode47
#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.

Produced by Kudzai Nyandoro on Friday, 02 Nov 2018


Kode47
#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.

Produced by Kudzai Nyandoro on Wednesday, 31 Oct 2018


Kode47
#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.

Produced by Kudzai Nyandoro on Wednesday, 31 Oct 2018


Kode47
#13 | Cloud9 Workspace 101 | 11:47

Getting familiar with the Cloud9 workspace, terminal, and Ace editor.

Produced by Kudzai Nyandoro on Saturday, 27 Oct 2018


Kode47
#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.

Produced by Kudzai Nyandoro on Friday, 26 Oct 2018


Kode47
#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.

Produced by Kudzai Nyandoro on Thursday, 25 Oct 2018


Kode47
#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).

Produced by Kudzai Nyandoro on Thursday, 25 Oct 2018


Kode47
#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.

Produced by Kudzai Nyandoro on Wednesday, 24 Oct 2018


Kode47
#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.

Produced by Kudzai Nyandoro on Thursday, 18 Oct 2018


Kode47
#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.

Produced by Kudzai Nyandoro on Friday, 12 Oct 2018