Srinimf

Master Data Engineering Vocabulary for Client Interviews

Sep 7, 2025

·

AWS

How to Search Oracle Database for Column

Here is a helpful SQL query to find a Table name in the database for a column. Useful for error fixing or bug fixing. Read More ⇢
7 Need to Know Python pdb Debugger Commands

Here are the seven top python pdb commands. Helpful to use these commands at the pdb command line. Each one is explained with the result. Read More ⇢
How to get DATE Only From DATETIME Column

Here is an SQL query to get only Date from the Datetime column. This is tested in Oracle. Also, added SQL query to get both Date and Time. Read More ⇢
Understand Flashback Table in Oracle to Recover Deleted Data

Flashback table is an advanced concept in Oracle. With which you can recover data till a specific point in time. Here are the basic architecture and handy SQL queries that you need. Read More ⇢
How to Slice a String [Substring] in Python

String slicing examples in python. The methods are positive, negative slicing, with single and double colon operators. Read More ⇢
7 Daily Use Python String Functions

In Python, string manipulation methods include find, validate, concatenate, change case, split, replace, and strip. Read More ⇢
How to Use Merge Statement in SQL Query: Best Examples

In SQL, MERGE is the latest statement. You can include all UPDATE, INSERT and DELETE statement in single query. Major RDBMS databases support this statement. Read More ⇢
EBS Block Storage in AWS The Real Usage

Block storage volumes are persistent. These have a relationship to the EC2 instance. Here is the usage of EBS storage in AWS. Read More ⇢
How to Monitor AWS RDS Service

AWS operations team will monitor RDS services. Here are a few ideas on monitoring the RDS service. Helpful for AWS engineers. Read More ⇢