MongoDB. Download. Install as Service on Windows. #shorts

#25 PostgreSQL – JSONB, contains operator to work with JSONB data. JSONB SQL. #shorts

Python – Two-Sum Algorithm: Find Pairs in Array with Target Sum

Lesson 1: Find Method – MongoDB. #shorts

Vid 14 – LAG() SQL Server. How to compare Current Period to a Previous Period. #shorts

Excel VBA #10 – How to pull data from PostgreSQL into Microsoft Excel using VBA. #shorts.

Postgresql – array_to_string function

Excel VBA #3 How do I connect to SQL Server using Microsoft Excel VBA? #shorts

Regular Expressions in PostgreSQL

C#:(#6) How to use the JsonProperty to change the Order Position when Serializing Class Object.

#14 JSON_build_object : PostgreSQL – JSON Object Creation Made Simple – Explained. #Shorts

#16 JSON_ARRAY_ELEMENT. PostgreSQL function to expand JSON array to a set of JSON values. #shorts

Step-by-step instructions to download and install ODBC driver for PostgreSQL on Windows 10.

#13 PostgreSQL – JSON – How to perform simple SELECT statements. #shorts

Lesson 23: C Programming – SizeOf – how many bytes does a variable or data type takes up. #shorts

Lesson 8: C Programming – Understand If-Else Statement, when condition is false. #shorts

#9 PostgreSQL – ARRAY – Make array elements unique using numeric values. #Shorts

#3 PostgreSQL – ARRAY_AGG, returns an array of values

Master PostgreSQL: Generate a Deck of Cards and Randomly Deal Any Hand Size with Just SQL.

Part 2: How to use PostgreSQL ARRAY DataType: update, remove, append prepend and array_cat.

PostgreSQL Coalesce Function – A solution for replacing NULL values with an alternative.

PostgreSQL – How to use CTE

CASCADE Foreign Keys in PostgreSQL, learn how the CASCADE behavior is enforced.

How to perform an upsert (insert or update) operation in PostgreSQL using the INSERT ON CONFLICT.

Part 1: How to use the PostgreSQL ARRAY Data type: search, insert, unnest, search by index.