Preview »

PostgreSQL Introduction

By Code Stop

Requirements: No programming experience, at least 12 years old

Duration: 5 hours and 35 minutes

Standards: K-12 Computer Science Framework Core Concepts and Practices * Algorithms and Programming - Collaborating Around Computing - Recognizing and Defining Computational Problems - Developing and Using Abstractions - Creating Computational Artifacts - Testing and Refining Computational Artifacts

An Introduction to PostgreSQL

Querying and accessing data is one of the most essential skills that a developer should possess. This course is designed for beginning programmers who want to take their first steps in database interaction and for experienced programmers who need a refresher on the most essential concepts.

About this course

An Introduction to PostgreSQL is a series of interactive lessons that helps you learn the essential concepts about SQL in general and PostgreSQL in particular. You will be solving problems that challenge you to retrieve, group, filter, merge, and compare data. You will learn how to manipulate databases, tables, columns and rows. At the end of this course, you will be able to master the most essential SQL database manipulation skills and get a good sense of how PostgreSQL works.

About PostgreSQL

A database is a set of structured data in a computer. PostgreSQL is a database system that is used to create, read, update, and delete databases.

About psql

The course An Introduction to PostgreSQL uses psql as its command-line client. The command-line client is the interface between you and the database. It provides feedback for successfully executed queries and commands. It also provides feedback when there are errors in the query or command that you execute. There are other command-line client for PostgreSQL, aside from psql. For consistency, all the lessons in this course uses psql.

Course Outline

  • SELECT FROM
    The SELECT statement allows you to retrieve data from a database. The process of retrieving data is called querying. In this lesson, you will query specific tables within a database using the SELECT statement. You will also learn how to retrieve data from specific columns within a table.
    50 minutes
    INSERT INTO
    After learning how to query a database, you will learn how to add rows into a table using the INSERT INTO statement.
    55 minutes
    SELECT WHERE
    The WHERE clause lets you add filters to your query. In this lesson, you will learn how to retrieve specific datasets from a table to make your query results more manageable. You will use different logical and comparison operators to make your queries more effective.
    55 minutes
    UPDATE
    You can change existing data using the UPDATE statement. In this lesson, you will learn how to insert rows into a table. You will also learn how to add a WHERE clause into the UPDATE statement. A WHERE clause allows you to set the conditions that will determine which columns will be affected by the UPDATE statement.
    45 minutes
    DELETE
    In this lesson, you will learn how to delete specific rows using the DELETE and WHERE statements.
    50 minutes
    CREATE TABLE
    So far, you have been working on tables with existing data. This time, you will learn to create your very own table. You will also practice the skills that you have learned from the previous lessons by querying and altering your own table.
    45 minutes
    Practical Exercises
    Practice the skills that you have learned from the previous lessons by creating your own table, adding new records to it, and querying and altering the records in the table.
    35 minutes