- Blog
- Blog
- Homepage
- Homepage
-
Python and SQL Interview Questions at KPMG: A Handy Checklist
The content comprises potential interview questions and related responses for a Python and SQL developer role at KPMG, covering topics like database operations, Python data structures, and CSV file handling in Pandas.
-
Python Strings: Center Vs Join Methods
Python’s center method aligns a string within a specified width, while the join method concatenates strings using a specified delimiter.
-
SQL Like Statement with CHAR and VARCHAR: Top Differences
The post explains the differences in using the SQL Like statement with Char and Varchar, particularly regarding trailing spaces.
-
CGI: PySpark Interview Questions Revealed
The content provides PySpark interview questions regarding RDDs, Dataframes, comparison with Pandas, and operations like removing duplicates, merging dataframes with same and different Schema.
-
Reading and Write Array Data: Python Files Challenges
The article provides advice on handling challenges when reading and writing array data to files in Python, covering factors such as file format, data type, size, error handling, serialization, performance, security, documentation, versioning, and testing.
-
SQL Date Functions: to_date Vs. to_char
SQL date formatting can be done using “to_date” and “to_char” functions, allowing various custom outputs.
-
How to Create Unique Identifier: Oracle SQL
The article explains how SQL sequences generate unique numeric values, primarily for primary keys, enhancing database performance, with examples and syntax breakdown.
-
Python String Space Removal: 3 Efficient Methods
The post details three Python approaches for removing spaces in strings: using a for loop, map() with lambda, and list comprehension.
-
Enhance Competitiveness with DevOps Tools, Testing, and Deployment
DevOps emphasizes collaboration between development and operations teams, utilizing tools like JENKINS and Docker for efficient project delivery.
-
VSAM Alternate Index: A Comprehensive Guide
The text answers common questions about VSAM alternate index, explaining its creation, updates, benefits, and use in data retrieval.
-
DB2 Buffer Pools: A Comprehensive Look
DB2 Buffer Pools are logical memory, used to speed up SQL queries, enhance database performance and control CPU resources usage.
-
Counting of String Elements: 2 Ways to Achieve in Python
The post explains two Python methods to count string elements – using itertools and groupby, and for loops.
Srinimf 