SQL Query Fundamentals with PostgreSQL

[kingers]

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

Files Included :
1 -Introduction.mp4 (13.88 MB)
1 -2 - source code.zip (717 B)
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 -3 - source code.zip (18.56 KB)
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 -4 - source code.zip (34.47 KB)
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 -5 - source code.zip (17.62 KB)
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 -6 - source code.zip (14.98 KB)
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 -7 - source code.zip (17.94 KB)
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 -8 - source code.zip (16.64 KB)
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

AusFile

https://ausfile.com/vf6obv4fzqn3
https://ausfile.com/ruk1hx69l6ri
https://ausfile.com/prq1qgf72m8m
https://ausfile.com/p4ewv6phx5ki
https://ausfile.com/df2cgmizwdqr
https://ausfile.com/r8n482ktgi3q

RapidGator

https://rapidgator.net/file/5f2cce809df7c452dde805789be4b447/
https://rapidgator.net/file/159f9da49787f3dbf6dd9814f0c043a1/
https://rapidgator.net/file/764e0c6a9ac3426a4f5053bf3a7c9918/
https://rapidgator.net/file/3dc033f13dd2cdd346976e20e965527a/
https://rapidgator.net/file/7d3ebe44bd754f07a6bd3597ee2e2aeb/
https://rapidgator.net/file/859105a24ec4bc1d573363902aa54799/