Srinimf’s Top 2021 Blog Posts

Here are the top performed and most viewed blog posts in 2021. The topics are SQL, Python, VSAM and AWS.

How to Use Multiple Like Conditions in SQL

Here is an example on how to use multiple LIKE conditions in WHERE clause of SQL.

SQL where clause fetches records quickly when you give conditions correctly. The conditions should be indexed table columns. And, many a time, you need to filter records using like conditions.

SQL Query Examples on Multiple WHERE Conditions

Multiple conditions, how to give in the SQL WHERE Clause, I have covered in this post. Those are IN, LT, GT, =, AND, OR, and CASE. It takes more CPU time, If the WHERE condition is not proper, to fetch rows – since more rows.

15 Top AWS IAM Service Interview Questions

The identity and access management (IAM) service provide access for users (Entities). Below are the useful interview questions so that you can understand the IAM service quickly.

COBOL VSAM Files READ with START Logic

Here’s sample COBOL program that shows how to use READ, WRITE and READ NEXT statements. The READ statement is to get record randomly. The READ NEXT to read VSAM file till end of the file

https://srinimf.com/2012/02/19/1207/

12 Tricky Python Coding Interview Questions

Among the leading computer programming languages, Python takes the first place. In this post, I am sharing the 12 Python frequently asked Coding Interview Questions on the basics of Python Language.

Related posts

  • How to Use GitHub Copilot in VS Code for Faster Coding

    How to Use GitHub Copilot in VS Code for Faster Coding

    GitHub Copilot enhances Visual Studio Code by providing real-time code completions, comment-driven generation, debugging, refactoring, documentation, and conversational assistance. Setup requires VS Code, a GitHub account, and Copilot access. Install both Copilot extensions, authenticate through GitHub, and use shortcuts, chat commands, and clear prompts. Always review generated code for security, performance, and accuracy.

  • How to Find Databricks Job Status, Owner, and Active Runs Fast

    How to Find Databricks Job Status, Owner, and Active Runs Fast

    Need to audit Databricks workflows? Step-by-step guide to tracking job creators, service principal run identities, and current execution status in Databricks.

  • 30 SQL Practice Queries with Solutions — Run Them Live

    30 SQL Practice Queries with Solutions — Run Them Live

    Practice 30 SQL queries with solutions, from SELECT and JOINs to subqueries and window functions. Run SQL queries live in an interactive SQL Playground.