- Blog
- Blog
- Homepage
- Homepage
-
2 Top SQL Queries to Update Table: Subquery and Join
The content explains using update SQL query with tables EMP1 and EMP2 to update records in multiple tables concurrently.
-
Connecting Python to Oracle Database: 4 Neat Approaches
Provides four methods (cx_Oracle, pyodbc, pyoracle, sqlalchemy) to establish Python to Oracle database connectivity, enabling data analysis.
-
Python Interview Questions and Answers: Recently Asked in CGI
The post discusses Python interview questions and answers for intermediate-level positions, covering topics like list comprehension, file handling and counting duplicates in Python, similarities and differences between Python and PySpark, parallel processing, and techniques to read large files in Pandas.
-
Exploring the Power of Vectorization in Numpy: A Comprehensive Guide
NumPy’s vectorization allows efficient handling of complex calculations with large datasets in Python by eliminating traditional loops.
-
A Sample Bash Script: Reading, Transforming and Writing to Files
The content describes a Bash script using ‘sed’ command to modify input file data and write output to multiple files.
-
Black Box Vs. White Box Testing: The Key Differences
Black box testing evaluates software functionality without assessing internal structures, while white box testing inspects the application’s internal workings.
-
Creating a View in DB2: Step-by-Step Guide
Here are examples of how to create Views in DB2 SQL. Also explained rules and purpose of views.
-
Free Space in VSAM: KSDS Internal Architecture
A Key Sequenced Data Set (KSDS) improves data management and access performance through indexed components and free space utilization.
-
VSAM Files: Exclusive Merits and Demerits
VSAM files offer high performance and data accessibility but require expertise, testing, and can limit scalability.
-
DB2: Unlock the Rules for Efficient Creating Indexes
Indexes in the database speed up the pulling of rows. Here are the top rules for when to create and when not to create.
-
How to Create Code Pipeline in AWS
AWS CodePipeline aids in automating software delivery by building, testing, and deploying applications efficiently and consistently.
-
25 Essential CICS Interview Questions
This post provides extensive CICS interview questions and answers, focusing on key commands, programming techniques, and system structures.
Srinimf 