Results for "programming"
21 / 184 posts
What is SQL and what is it used for?
SQL stands for Structured Query Language , and it is a standard programming language used for managing and manipulating data within relational databases. S…
How to use Magic (virtual) table INSERTED and DELETED in SQL server
Magic Tables are virtual tables that are automatically created and maintained by SQL Server for each data modification operation performed on a table. They…
Normalization in Databases
Normalization in a database is the process of organizing the data to reduce redundancy and improve data integrity. The main goal of normalization is to bre…
Triggers in SQL server
A trigger in SQL is a special type of stored procedure that runs automatically when certain actions happen in a table or view . A trigger cannot be explici…
XML Data – Complete Conceptual Guide (SQL Server Perspective)
How insert data on table from XML in SQL server, example: There are two method for insert data in table from XML. DECLARE @XMLInput VARCHAR(MAX); SET @XMLI…
Schema and Handling Corrupt data in PySpark
A schema in PySpark (and generally in data processing) defines the structure of a DataFrame, including the names and data types of each column. It serves a…
CLASSES in Python
ऑब्जेक्ट ओरिएंटेड प्रोग्रामिंग (Object-Oriented Programming या OOP) एक तरीका है प्रोग्राम लिखने का, जिसमें हम क्लास (class) और ऑब्जेक्ट (object) का इस्तेमा…
Split full name into first name and last name in SQL
Split full name into first name and last name : SELECT EmployeeName, CASE WHEN CHARINDEX(' ', EmployeeName) > 0 -- Check if there is a space (indicating…
Pivoting and Unpivoting Data in SQL
Pivoting Data : Pivoting is the process of converting rows of data into columns, effectively changing the orientation of your data. It's useful when you ha…
Store Error Logs In SQL
Create Table for Error log: CREATE TABLE [dbo].[ErrorLog]( [ErrorLogID] [int] IDENTITY(1,1) NOT NULL, [ErrorTime] [datetime] …
What is a SQL Statement and types of SQL statements
A SQL (Structured Query Language) statement is a query or command used to perform various operations on data stored in a relational database. SQL statement…
What is Functions and Difference between Functions and Stored Procedures in SQL Server
What is a Function in sql : A function is a set of SQL Statements that perform a specific task. Basically, it is a set of SQL statements that accept only i…
Functions and Modules in Python
def Grreting(name): print("Hello, " + name + "! Welcome to Python programming.") def main(): user_name = input("Please enter your name: ") Grreting(user_na…
Matrices
Definition A matrix is a rectangular array of numbers , symbols, or expressions arranged in rows and columns. Types of Matrices Square Matrix : A matrix wi…
Basics of Pandas
Pandas is the most popular open-source library in the Python programming language and pandas is widely used for data science/data analysis and machine lear…
Making API Calls in Python
APIs (Application Programming Interfaces) are the bridges that allow different software systems to communicate with each other. pip install requests import…
What is Blocking in SQL, How to solve blocking, and Kill Session
What is Blocking in SQL? Blocking occurs in SQL Server when one query or transaction holds a lock on a resource (like a row or table) and prevents other qu…
Understanding Cursors in +SQL Server: A Complete Guide
When working with databases, most SQL operations are designed to handle large sets of data at once. However, there are cases where you may need to process …
Common Table Expressions (CTEs) in SQL
The Employee Hierarchy Problem Imagine you are working with an employee database where each employee might report to a manager. Here's a sample table struc…
Data Import from text/CSV file in SQL Server
Step-by-Step Explanation 1. Checking and Dropping Existing Temporary Tables Before creating the temporary tables, the script ensures that any previously ex…
Map, Filter, and Reduce in Python
Programming me kabhi kabhi aisa hota hai ki tumhe list ke saare elements pe ek kaam karna ho , ya phir kuch elements ko condition ke hisaab se nikalna ho ,…