3.43 out of 5
3.43
7 reviews on Udemy

Joining Data and using Triggers in PostgreSQL

Learn how to extract data from multiple tables and create Triggers
Instructor:
Bluelime Learning Solutions
2,266 students enrolled
English [Auto-generated]
Install PostgreSQL
Connect to PostgreSQL Database
Create a Table
Populate a Table
Join data using Natural Join
Join data using Cross Join
Join data using Inner Join
Join data using Left Join
Join data using Full Outer Join
Create Triggers
Manage Triggers
Perform Basic CRUD OPeration

The PostgreSQL Joins clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using values common to each.

The main concept which is focusing on a join is that, two or more data sets, when joined, combined their columns into a new set of rows, including each of the columns requested from each of the data sets. All joins are standing on the foundation of Cartesian product. The Cartesian product is the set of all possible combinations between two data sets. A join creates a set of rows in a temporary table and works on two or more tables, and each table should at least one common field and must maintain a relation between the common fields. Join keeps the structure unchanged of the base tables.

Types of PostgreSQL JOIN

Cross Join
Inner Join
Left Outer Join
Right Outer Join
Full Outer Join

A PostgreSQL trigger is a function invoked automatically whenever an event associated with a table occurs. An event could be any of the following: INSERT, UPDATE, DELETE or TRUNCATE.

A trigger is a special user-defined function that binds to a table. To create a new trigger, you must define a trigger function first, and then bind this trigger function to a table. The difference between a trigger and a user-defined function is that a trigger is automatically invoked when an event occurs.

PostgreSQL provides two main types of triggers: row and statement level triggers. The differences between the two are how many times the trigger is invoked and at what time. For example, if you issue an UPDATE statement that affects 20 rows, the row level trigger will be invoked 20 times, while the statement level trigger will be invoked 1 time.

You can specify whether the trigger is invoked before or after an event. If the trigger is invoked before an event, it can skip the operation for the current row or even change the row being updated or inserted. In case the trigger is invoked after the event, all changes are available to the trigger.  
We will create and manage a basic trigger in this course.

Setting up PostgreSQL Database Environment

1
Introduction
2
What is PostgreSQL
3
PostgreSQL System Architeture
4
Some companies using PostgreSQL
5
Minimum System Requirements
6
Download PostgreSQL
7
Install PostgreSQL on Windows
8
Verifying installation
9
Installing PostgreSQL on MacOS
10
Connecting to PostgreSQL Database
11
Load sample database
12
Creating a new table
13
Populating a Table
14
Query a Table

PostgreSQL Database Objects

1
Server Service
2
Schema
3
Tablespace
4
Extensions

Joining Data

1
Introduction to Joins
2
Joining data with Natural Join
3
Joining Data with Cross Join
4
Joining Data with Inner Join
5
Joining Data with Left Join
6
Joining Data with Full Outer Join

Using Triggers

1
What are Triggers
2
Creating your first trigger part 1
3
Creating your first trigger part 2
4
Creating your first trigger part 3
5
Managing Triggers

Performing Basic CRUD Operations

1
Introduction to CRUD
2
Creating a database using PG4ADMIN
3
Creating a Table using PG4ADMIN
4
Using CREATE Table statement
5
Retrieving data with SELECT statement
6
Using Subquery
7
Using UPDATE statement
8
Using DELETE statement
9
Using INSERT statement
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.4
3.4 out of 5
7 Ratings

Detailed Rating

Stars 5
3
Stars 4
0
Stars 3
2
Stars 2
1
Stars 1
1
3a7f4924f8fec09442a8f2bee85dd933
30-Day Money-Back Guarantee

Includes

4 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion