Joining Data and using Triggers in PostgreSQL

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Setting up PostgreSQL Database Environment
• 1 -Introduction.en_GB.vtt (2.0 KB)
• 1 -Introduction.mp4 (7.3 MB)
• 10 -Connecting to PostgreSQL Database.en_GB.vtt (6.5 KB)
• 10 -Connecting to PostgreSQL Database.mp4 (22.7 MB)
• 11 -Load sample database.en_GB.vtt (8.5 KB)
• 11 -Load sample database.mp4 (51.4 MB)
• 12 -Creating a new table.en_GB.vtt (6.2 KB)
• 12 -Creating a new table.mp4 (38.8 MB)
• 13 -Populating a Table.en_GB.vtt (7.2 KB)
• 13 -Populating a Table.mp4 (52.0 MB)
• 14 -Query a Table.en_GB.vtt (6.0 KB)
• 14 -Query a Table.mp4 (40.1 MB)
• 2 -What is PostgreSQL.en_GB.vtt (3.1 KB)
• 2 -What is PostgreSQL.mp4 (13.9 MB)
• 2163.dat (7.8 KB)
• 2165.dat (0.5 KB)
• 2167.dat (325.3 KB)
• 2168.dat (146.0 KB)
• 2169.dat (25.7 KB)
• 2171.dat (45.7 KB)
• 2173.dat (21.3 KB)
• 2175.dat (3.5 KB)
• 2177.dat (55.8 KB)
• 2179.dat (137.1 KB)
• 2181.dat (0.3 KB)
• 2183.dat (701.8 KB)
• 2185.dat (1.2 MB)
• 2187.dat (0.3 KB)
• 2189.dat (0.1 KB)
• 3 - Overview of PostgreSQL.html (5.0 KB)
• 3 -PostgreSQL System Architeture.en_GB.vtt (3.8 KB)
• 3 -PostgreSQL System Architeture.mp4 (21.7 MB)
• 4 -Some companies using PostgreSQL.en_GB.vtt (5.5 KB)
• 4 -Some companies using PostgreSQL.mp4 (25.4 MB)
• 5 -Minimum System Requirements.en_GB.vtt (2.8 KB)
• 5 -Minimum System Requirements.mp4 (18.8 MB)
• 6 -Download PostgreSQL.en_GB.vtt (3.4 KB)
• 6 -Download PostgreSQL.mp4 (29.2 MB)
• 7 -Install PostgreSQL on Windows.en_GB.vtt (4.4 KB)
• 7 -Install PostgreSQL on Windows.mp4 (16.3 MB)
• 8 -Verifying installation.en_GB.vtt (4.0 KB)
• 8 -Verifying installation.mp4 (19.5 MB)
• 9 -Installing PostgreSQL on MacOS.en_GB.vtt (3.2 KB)
• 9 -Installing PostgreSQL on MacOS.mp4 (23.8 MB)
• restore.sql (48.4 KB)
• toc.dat (52.7 KB)
2 - PostgreSQL Database Objects
• 1 -Server Service.en_GB.vtt (4.3 KB)
• 1 -Server Service.mp4 (20.5 MB)
• 2 -Schema.en_GB.vtt (3.2 KB)
• 2 -Schema.mp4 (13.5 MB)
• 3 -Tablespace.en_GB.vtt (2.8 KB)
• 3 -Tablespace.mp4 (12.2 MB)
• 4 -Extensions.en_GB.vtt (4.0 KB)
• 4 -Extensions.mp4 (20.1 MB)
3 - Joining Data
• 1 -Introduction to Joins.en_GB.vtt (0.8 KB)
• 1 -Introduction to Joins.mp4 (4.6 MB)
• 2 -Joining data with Natural Join.en_GB.vtt (8.2 KB)
• 2 -Joining data with Natural Join.mp4 (73.8 MB)
• 3 -Joining Data with Cross Join.en_GB.vtt (5.9 KB)
• 3 -Joining Data with Cross Join.mp4 (39.8 MB)
• 4 -Joining Data with Inner Join.en_GB.vtt (10.3 KB)
• 4 -Joining Data with Inner Join.mp4 (62.9 MB)
• 5 -Joining Data with Left Join.en_GB.vtt (10.5 KB)
• 5 -Joining Data with Left Join.mp4 (62.9 MB)
• 6 -Joining Data with Full Outer Join.en_GB.vtt (8.8 KB)
• 6 -Joining Data with Full Outer Join.mp4 (55.9 MB)
4 - Using Triggers
• 1 -What are Triggers.en_GB.vtt (7.0 KB)
• 1 -What are Triggers.mp4 (27.8 MB)
• 2 -Creating your first trigger part 1.en_GB.vtt (10.5 KB)
• 2 -Creating your first trigger part 1.mp4 (55.7 MB)
• 3 -Creating your first trigger part 2.en_GB.vtt (8.0 KB)
• 3 -Creating your first trigger part 2.mp4 (50.6 MB)
• 4 -Creating your first trigger part 3.en_GB.vtt (13.8 KB)
• 4 -Creating your first trigger part 3.mp4 (83.2 MB)
• 5 -Managing Triggers.en_GB.vtt (5.5 KB)
• 5 -Managing Triggers.mp4 (21.4 MB)
5 - Performing Basic CRUD Operations
• 1 -Introduction to CRUD.en_GB.vtt (0.7 KB)
• 1 -Introduction to CRUD.mp4 (2.4 MB)
• 2 -Creating a database using PG4ADMIN.en_GB.vtt (5.3 KB)
• 2 -Creating a database using PG4ADMIN.mp4 (28.5 MB)
• 3 -Creating a Table using PG4ADMIN.en_GB.vtt (7.3 KB)
• 3 -Creating a Table using PG4ADMIN.mp4 (42.5 MB)
• 4 -Using CREATE Table statement.en_GB.vtt (7.2 KB)
• 4 -Using CREATE Table statement.mp4 (43.6 MB)
• 5 -Retrieving data with SELECT statement.en_GB.vtt (4.9 KB)
• 5 -Retrieving data with SELECT statement.mp4 (20.4 MB)
• 6 -Using Subquery.en_GB.vtt (7.1 KB)
• 6 -Using Subquery.mp4 (48.7 MB)
• 7 -Using UPDATE statement.en_GB.vtt (7.5 KB)
• 7 -Using UPDATE statement.mp4 (42.2 MB)
• 8 -Using DELETE statement.en_GB.vtt (4.8 KB)
• 8 -Using DELETE statement.mp4 (29.7 MB)
• 9 -Using INSERT statement.en_GB.vtt (8.4 KB)
• 9 -Using INSERT statement.mp4 (50.1 MB)
6 - Best Practices and Performance Optimization
• 1 - Best Practices for Joining Data.html (4.0 KB)
• 1 - Debugging and Troubleshooting Triggers.html (4.4 KB)
• 1 - Optimizing Trigger Performance.html (4.5 KB)
• Bonus Resources.txt (0.1 KB)