Results for "min"
44 / 184 posts
SQL Server Configuration Manager
Introduction Jab hum Microsoft SQL Server install karte hain , tab kuch important tools automatically install ho jate hain. Unme se ek bahut important tool…
SQL Server System Databases
Introduction SQL Server me jab hum kaam karte hain, to generally hum tables, queries aur user databases par focus karte hain. Lekin ek hidden backbone hota…
TempDB in SQL Server
Introduction SQL Server me ek aisa database hai jo har query, har process aur almost har operation me involve hota hai. Ye ek temporary w…
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…
Slowly Changing Dimensions (SCD)
Data Warehouse me ek bahut important concept hota hai: 👉 Slowly Changing Dimensions (SCD) Jab hum dimensional modeling karte hain, hum assume karte hain k…
Master Database in SQL Server
Introduction SQL Server me agar koi ek database sabse zyada critical hai, to wo hai: Master Database Ye SQL Server ka core brain hai. Agar master database …
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…
Spark SQL useful command
Spark SQL provides a variety of commands for managing databases, tables, and performing SQL operations. CREATE DATABASE IF NOT EXISTS demo; SHOW DATABASES;…
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…
What is Big Data
Big Data refers to extremely large datasets that are too complex and voluminous to be processed and analyzed using traditional data processing tools and te…
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…
What are Data warehouse, Data Lake ,data mining and DataMart and MetaData
Why a Data Warehouse? (Data Warehouse ki zarurat kyu hoti hai?) Aaj ke time me companies ka data multiple sources me store hota hai, jaise: • SQL Server da…
⭐ Star Schema vs ❄ Snowflake Schema – Data Warehouse Modeling
⭐ Star Schema Kya Hota Hai? Star Schema ek simple aur sabse popular data warehouse model hai. Isme: Beech me hoti hai 👉 Fact Table Uske around hoti hain �…
OLTP vs OLAP: A Beginner's Guide
What is OLTP? OLTP stands for Online Transaction Processing . It is a type of database system designed to handle a large number of short, quick operations,…
What is the KDD (Knowledge Discovery in Databases)
In today's world, data is everywhere. Businesses, healthcare, banking, and even social media generate vast amounts of data every second. But raw data alone…
PySpark Built-in Functions
These functions are commonly used with groupBy() , agg() , or select() to compute things like sum, average, max, min, count, etc. PySpark functions come fr…
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 ,…
Statistics in SQL Server
Statistics SQL Server ke “mind” jaise hote hain. Ye SQL Server ko batate hain ki table me data kis tarah se distribute hai — jaise kitne values unique hain…
Data Warehouse and Data Mining Syllabus
Yeh Data Warehouse and Data Mining ka complete syllabus list format me diya hai, bina explanation ke — sirf topics list: PART 1: Data Warehouse Syllabus Li…
In-Memory Databases (Data Warehouse Context)
🔹 In-Memory Database kya hoti hai? In-memory database wo database hoti hai jisme: 👉 Data hard disk par store nahi hota 👉 Data directly RAM (memory) me s…
What Are OLAP Cubes
When we work with a Data Warehouse, one common goal is fast reporting and analysis . Business users don’t want to wait 30 seconds for a dashboard to load. …
What is Operational Data Storage (ODS)?
Data Warehouse padhte time ek topic aata hai jo thoda confusing hota hai: 👉 ODS (Operational Data Storage) Bahut log confuse ho jate hain: “Ye Data Wareho…
What Is Dimensional Modeling in Data Warehouse?
Before going deep into Star Schema and Fact Tables, pehle ek basic sawal: Dimensional Modeling hota kya hai? Dimensional Modeling ek technique hai jo Data …
Natural Key vs Surrogate Key in Data Warehouse
Dimensional Modeling me ek important topic hota hai: 👉 Natural Key 👉 Surrogate Key Dono primary key ke type hain, lekin inka purpose aur usage alag hota …
Indexes in Data Warehouse
Database Me Data Kaise Store Hota Hai? Table ke rows disk par randomly store hote hain. Example: Row Customer_ID Sales 1 8 100 2 5 200 3 4 300 4 8 150 Agar…
Row-Based vs Column-Based (Columnar) Storage
Database me table hume: Rows aur columns ke form me dikhti hai. Lekin internally data store hone ka tareeka alag hota hai. Do main storage types hote hain:…
What is MPP (Massively Parallel Processing)
Aaj ke time me: ✔ Data bahut fast grow ho raha hai ✔ Users bahut zyada queries run kar rahe hain ✔ Reports real-time chahiye Traditional database model is …
SQL Server Administration – Management Tools Overview
Is section me hum mainly SQL Server ke management tools aur system databases ko samjhenge. SQL Server Management Tools Jab aap Microsoft SQL Server install…