SQL Query Fundamentals with PostgreSQL

4.78 GB | 19min 53s | mp4 | 1280X720 | 16:9
Genre:eLearning |Language:English

Files Included :
1 -Introduction.mp4 (13.88 MB)
1 -Module Primer.mp4 (6.41 MB)
2 -Quick Start Guide VSCode for Windows & MacOS.mp4 (65.61 MB)
3 -RDMS, Databases and SQL.mp4 (24.94 MB)
4 -Creating a PostgreSQL Database with Docker.mp4 (95.72 MB)
5 -Source Code Setup Guide.mp4 (36.02 MB)
1 -Module Primer.mp4 (9.62 MB)
10 -Unique Values.mp4 (68.69 MB)
11 -Creating Primary Keys.mp4 (68.02 MB)
12 -Creating Foreign Keys.mp4 (144.18 MB)
13 -On-Delete Behaviour.mp4 (88.38 MB)
14 -Defining Many-To-Many Relationships.mp4 (113.66 MB)
15 -Creating a One-to-One Relationship.mp4 (74.02 MB)
16 -Introducing Check Constraints.mp4 (105.4 MB)
17 -Defining Complete SQL Tables in a Single Statement.mp4 (131.74 MB)
18 -Connecting to a Database with pgAdmin.mp4 (71.03 MB)
19 -Creating and Administrating Database Tables with pgAdmin.mp4 (112.52 MB)
2 -Introducing the Database Schema and ERD.mp4 (53.94 MB)
3 -Connecting to the PostgreSQL Database.mp4 (84.17 MB)
4 -Creating and Managing Databases with SQL.mp4 (67.24 MB)
5 -Defining and Managing Tables with SQL.mp4 (123.74 MB)
6 -Common Data Types (Strings, Numbers, Boolean).mp4 (192.03 MB)
7 -Date and Time Fields.mp4 (60.94 MB)
8 -Required, Null and Blank Fields.mp4 (97.77 MB)
9 -Default Values.mp4 (72.08 MB)
1 -Module Primer.mp4 (8.17 MB)
10 -Deleting Data with Relationships.mp4 (107.83 MB)
11 -Load JSON Data into PostgreSQL.mp4 (158.4 MB)
12 -Load CSV Data into PostgreSQL.mp4 (97.29 MB)
13 -Backup and Restore a PostgreSQL Database.mp4 (105.2 MB)
14 -Persisting Data in a PostgreSQL Docker Container.mp4 (66.41 MB)
15 -Administrating Database Data with pgAdmin.mp4 (103.39 MB)
16 -Building a PostgreSQL Initialisation Script.mp4 (53.45 MB)
2 -Re-Creating the Database.mp4 (25.22 MB)
3 -Inserting Data into Tables.mp4 (103.01 MB)
4 -SQL Bulk Inserts.mp4 (25.03 MB)
5 -Updating Existing Records.mp4 (77.67 MB)
6 -Inserting Data with Foreign Keys.mp4 (49.59 MB)
7 -Handling One-to-One Inserts.mp4 (142.85 MB)
8 -Handling Many-to-Many Inserts.mp4 (101.84 MB)
9 -Deleting Records.mp4 (37.45 MB)
1 -Module Primer.mp4 (8.18 MB)
10 -Introducing Functions.mp4 (126.43 MB)
2 -Select Statement – Retrieving all columns vs specific column.mp4 (50.42 MB)
3 -Filtering Records with WHERE.mp4 (59.54 MB)
4 -Order by – Sorting Results (ASCDESC).mp4 (61.16 MB)
5 -Retrieving the First Record.mp4 (28.57 MB)
6 -Limit and Offset – Pagination Basics.mp4 (32.47 MB)
7 -Distinct – Removing Duplicate Values.mp4 (58.75 MB)
8 -Aliases – Renaming ColumnsTables for Readability.mp4 (45.49 MB)
9 -Introducing Views.mp4 (58.4 MB)
1 -Module Primer.mp4 (5.7 MB)
2 -Using Logical Operators AND, OR, and NOT.mp4 (57.4 MB)
3 -Using Comparison Operators.mp4 (53.06 MB)
4 -Using LIKE for Pattern Matching.mp4 (77.4 MB)
5 -Using IN and NOT IN for List Filtering.mp4 (43.6 MB)
6 -Using BETWEEN for Ranges.mp4 (52.23 MB)
1 -Module Primer.mp4 (6.73 MB)
2 -Understanding Joins in SQL.mp4 (18.29 MB)
3 -Inner Join for One-to-Many Relationships.mp4 (135.14 MB)
4 -Inner Join for One-to-One Relationships.mp4 (56.59 MB)
5 -Inner Join for Many-to-Many Relationships.mp4 (100.61 MB)
6 -Left Join for One-to-Many Relationships.mp4 (74.37 MB)
7 -Left Join with One-to-One Relationships.mp4 (31.12 MB)
8 -Left Join with Many-to-Many Relationships.mp4 (117.96 MB)
9 -Full Outer Join.mp4 (30.27 MB)
1 -Module Primer.mp4 (4.88 MB)
2 -Counting Records with Count.mp4 (47.22 MB)
3 -Summing Values with Sum.mp4 (60.03 MB)
4 -Calculating Averages with AVG.mp4 (16.07 MB)
5 -Using Group By to Aggregate Data.mp4 (92.53 MB)
6 -Filtering Aggregated Results with Having.mp4 (21.95 MB)
7 -Finding Min and Max Values.mp4 (21.23 MB)]
Screenshot

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm