PostgreSQL: Getting Started

In this course we will go over basics of PostgreSQL, often called the world's most advanced open source database.
Course info
Rating
(332)
Level
Beginner
Updated
Jan 26, 2015
Duration
1h 52m
Table of contents
Installation and Configuration
PostgreSQL: Creating and Accessing Database Tables
PostgreSQL: Data Operations - Select, Update, Delete
PostgreSQL: Database Joins Retrieving Data From Multiple Tables
PostgreSQL: Summary
Description
Course info
Rating
(332)
Level
Beginner
Updated
Jan 26, 2015
Duration
1h 52m
Description

PostgreSQL is commonly known as Postgres and is is often referred to as a the world's most advanced open source database. In this course, we will go over the basics of the PostgreSQL. We will cover topics ranging from installations, to writing basic queries and retrieving data from tables. We will also explore the logic of join, and a few best practices.

About the author
About the author

Pinal Dave is a Pluralsight Developer Evangelist.

More from the author
Getting Started with MariaDB
Beginner
2h 23m
Nov 2, 2018
Monitoring MySQL with Performance Schema
Intermediate
1h 59m
Apr 28, 2017
More courses by Pinal Dave
Section Introduction Transcripts
Section Introduction Transcripts

Installation and Configuration
Hi. This is Pinal Dave, and welcome to the course of PostgreSQL: Getting Started. This is the very first module, and in this module we will introduce PostgreSQL and learn about various resources related to PostgreSQL. Before we end this module we will install and configure PostgreSQL. Trust me. Installation of PostgreSQL is an extremely easy process. Well, let's start talking about PostgreSQL.

PostgreSQL: Creating and Accessing Database Tables
Hi. This is Pinal Dave, and in this module we will discuss about creating and accessing database tables in Postgres. In the last module we learned a brief history of Postgres. Right after that we installed and configured Postgres. Additionally, we also wrote our very first SELECT statement. And in this module we are going to learn about how to create database and database tables. We will also learn how to populate data in table, as well as we will see various options to restore database. We will understand this module with the help of a simple real-world scenario. Let's understand that in the next clip.

PostgreSQL: Data Operations - Select, Update, Delete
Hi. This is Pinal Dave, and welcome to Postgres: Data Operations SELECT, UPDATE, and DELETE. In the last module we restored sample database to Postgres. Right after that with the help of pgAdmin III we created table schema. We also exported data from database table and imported it in another table. In this module we are going to take our understanding of Postgres to the next level. We will first understand the basic structure of the SELECT statement, and right after that we will see how we can use the basic structure of the SELECT statement to update, as well as insert data in database tables. We will also see how to delete data from database table. For this we will use again real-world scenarios. The scenario is very simple. We will use the same individuals which we use in the previous module. We have Rahul and Mike. Rahul is senior database administrator, and Mike is junior database administrator. Between them we will recreate various scenarios from the real world. Let's start with our very first scenario.

PostgreSQL: Database Joins Retrieving Data From Multiple Tables
Hi. This is Pinal Dave, and welcome to the module of Postgres: Database Joins. In this module we will be focusing on retrieving data from multiple tables. In the last module we explored the basics of the SELECT statement. Right after that we understood how to update and insert data into a table. Right after that we learned how to delete data from a table. Well, SELECT, UPDATE, INSERT, and DELETE are basic fundamental operations of SQL. In this module we are going to learn how to retrieve data from multiple tables. For that first we have to understand the basics of Join. We will be learning various different kinds of joins in this module. First we will explore Inner Join, and right after that we will understand Outer Join. There are three different kinds of Outer Join, Left Outer Join, Right Outer Join, and Full Outer Join. Once we understand Inner and Outer Join, we will further understand Cross Join, which is commonly known as Cartesian Join. Well, just like all other modules we will be learning all these concepts with the help of real-world scenarios. This time the scenario is a little bit different from what we have seen in previous modules. Let's understand that in the next clip.