SQL Basics and common topics, practice using Postgresql

Sql Basics Catchup

Postgresql - Hands on with complex sql queries solving step by step

Learning Complex Sql Query using Postgresql

Received an award of £100 Amazon voucher! - Sky Star Award Feb 2025

Sky Award - Feb 2025

Experimenting with Node.js - Part 01

Experimenting with Node.js - Part 02

Experimenting with Node.js - Sending Email using the html template

ETL from Google Cloud Storage (Avro - daily, hourly) files to Bigquery using Airflow (Google Cloud Composer)

Syncing Between GCS Buckets in Google Cloud using Composer (Airflow)

Demo: ETL from GCS to BigQuery using Composer(Airflow)

BigQuery - Creating Primary Key/Foreign Key in Terraform

Async - Millions of API extract using Python - ETL (Local to Bigquery) 

Scala, Python, and Java are all popular programming languages, each with its own strengths and weaknesses. The choice between them depends on factors such as project requirements, ecosystem, performance needs, and personal preference.

Which is Best Programming Language? Java vs Scala vs Python

Apache Airflow instructions for setting up Apache Airflow with Postgresql, Celery and Rabbitmq on macOS

Part 2: Apache Aiflow setup with Postgresql, Celery and Rabbitmq (MacOs, Apple)

Apache Airflow instructions for setting up Apache Airflow on macOS

Part 1: Apache Aiflow setup (MacOs, Apple)

Kafka Concepts and other related entities

Easy way to setup spark and jupyter in the local

Docker - Setup Spark, Jupyter binding local folder in hostmachine

Docker Concepts -  What is docker? and other related entities.

Docker Practical Example

Mkdocs for quick static website generator

Docker Commands - Cheatsheet

PoC for sending alerts and notifications to slack channel using python

Send alerts and messages to Slack channel using Python Code

Interesting scenario while working on the UPSERT Logic and Star Schema - ETL Batch Load?

How to handle string or blank in the Integer column?

Proof of Concept to demo the encryption and decryption of AWS S3 files using AWS KMS

AWS - S3 files - Encryption - Decryption using AWS KMS

The email template gives us an idea about the error before moving to the cloud watch logs and reduces our time in searching error log stream.

AWS - Error Alert Notifications using SNS, Lambda, SES

data types, data platforms that stores, manages, process and deliver.

Case Study - All about Data

Concepts - Context Manager in Python

Concepts - Coroutine in Python

Concepts - Decorators in Python

Concepts - Descriptor in Python

Learning Abstract Base Class (ABC) in python

Concepts - Abstract Class and methods in Python

Case Study - Sql vs NoSQL - ACID, CAP, BASE Model

Tips to learn a new technology quickly and deeply. Easy way to achieve it. Avoid skimming

All Posts

Sql Basics Catchup

Learning Complex Sql Query using Postgresql