Bulk Data Load in Redshift using Pentaho
Redshift database is a cloud based, data warehouse solution offered by Amazon. It provides storage system that stores petabytes of data in easy-to-access clu...
Posts by Year
2022
2021
Q&A for Python interview
Important topics in Q&A format is based on my experience. Feel free to update me in case of any observation or you want to add anything.
Automate airflow scheduler log cleanup
Airflow Airflow is a platform created by the community to programmatically author, schedule and monitor workflows.
Remote command execution over SSH using Python
SSH SSH or Secure Shell is a cryptographic network protocol for operating network services securely over an unsecured network.[1] Typical applications includ...
2020
Block diagram using Graphviz
Generate dynamic block diagram using graphviz in windows/linux.
Useful Linux command and Shell script sniplets
Useful linux command Set of common useful linux command with basic description and usage. ls - List directory contents ls Prints all non hidden...
Getting started with Grafana on WSL
Install Grafana on Ubuntu using WSL 2 and explore rich graph and chart in windows.
Getting started with AirFlow on WSL
Setup AirFlow on WSL, configure database, executors and create static and dynamic workflow.
Data analysis using pandas - Tips and Techniques
pandas is a fast, powerful, flexible and easy to use open source data analysis and manipulation tool, built on top of the Python programming language.
MySQL on Oracle Always free compute instance
Install MySQL on Oracle always free compute instance and connect from MySQL workbench installed on windows.
Getting started with MySQL in WSL 2
How to install MySQL in Ubuntu 20.04 in WSL 2
Learning Python
Learn Python and transform your career as Python developer. Follow this post and keep learning.
Scrape Linkedin Post Content
Scrape linkedin.com post using Python Linkedin is for professional networking. it is also used by employers for posting jobs. There are cases where recruite...
OneClick Resume Uploader
OneClick Resume Uploader Updating profile daily increases the probablity of getting noticed by recruiters on job portal. Using OneClick resume upload hack, ...
2019
Oracle Database Administration Topics
Useful points related to Oracle Database Administration How to take export back of oracle database schema? Schema can be exported using expdp command. ...
Git setup and command
What is Git? Git is a distributed version-control system for tracking changes in source code during software development.It is designed for coordinating work...
Performance Tuning!
Introduction Performance tuning is a set of approach to optimize the database operations. Tuning is done at many level, depending upon the nature of iss...
Flask CRUD
Flask CRUD Demo Application Flask Flask is a lightweight WSGI web application framework. It is designed to make getting started quick and easy, with the abi...
Oracle Sql and Pl/Sql topics as Q&A
Important topics in Q&A format is based on my experience. Feel free to update me in case of any observation or you want to add anything. This post is spe...
Scrape web using Scrapy FrameWork
Scrape Naukri.com job using Scrapy Scrapy An open source and collaborative framework for extracting the data you need from websites. Using scrapy you can s...
Flask Restful Api
Flask Restful Api Flask-RESTful is an extension for flask that adds supports for quickly building REST APIs. In this example, restful api is exposed for vi...