Srini

DB2 5 Effective Ways to Tune SQL Queries

DB2 SQL query performance tuning ideas. Here’re the ways that you can use.

SQL Query How to get Datediff in MySQL

Here’s SQL Query you can get Year from two DATEs. You can achieve this with DATEDIFF() function in MySQL.

Linux How To Understand These BOOT, START, SHUTDOWN

Here are ideas on how to use STOP, START, SHUTDOWN, BOOT mindfully on internal processes of Linux operating systems.

How to Define Various VSAM Clusters with IDCAMS

IDCAMS DEFINE Utility you can use to define VSAM files. Here are the parameters to consider while creating them.

How to Join 3 Tables—Without Join Keyword

Sample SQL Query to Join three tables with WHERE clause. It is Tricky SQL query helpful for interviews.

SQL Query: How to Use LOCATE and Substring Correctly

Here are SQL queries to use the SUBSTRING function along with LOCATE function. LOCATE gives position, and SUBSTRING uses that for the start position.

6 Beginner’s Python Interview Questions

Here are the python technical interview questions helpful for your next interview.

Python Logic to use tell() and seek()

In Python, both tell and seek functions help you get the data from a file. How to use these explained on how to use in your current project.

11 Kafka Admin Interview Questions

You can learn interview questions for the Kafka administrator role here. The questions covered prime points of the Kafka server.

Understanding SQL Set Operators: UNION, INTERSECT, MINUS

Here are top rules of set operators in SQL with examples

How to Install HBase Properly

HBase is a NoSQL database in the Hadoop framework. Correct installation needed to work with HBase database. These are steps for quick installation without errors.

How to Use CAST Function: 5 Tricky SQL Queries

Cast function the real purpose is to convert data types. This post tells you best examples, rules, and how to use in Data analytics.