Results for "format"
18 / 184 posts
Find column in the whole database in sql server
To find a specific column in the whole database in SQL Server, you can query the information schema views. Here's a query you can use: SELECT table_name, c…
How to find table column information by using SQL query
Comprehensive Guide to Fetching Table and Column Metadata with SQL Server Stored Procedures When working with databases, understanding the structure of tab…
How to get first date From month and Finyear
If we have Finyear and month then we create a date for examples: DECLARE @finyear CHAR(5) = '202425'; DECLARE @month smallint = 5; --Get Year DECLARE @year…
How to Read and Write file into DataFrame by using Pyspark
# dataframe reader API.... spark.read.format("") \ .option("key":"value") \ .schema(schemavariable) \ .load() # dataframe write API...... spark.write.mode(…
DAX (Data Analysis Expressions) Operators and Data Type in Power BI
Here's the list of DAX operators in a table format: Arithmetic Operators Operator Description Example + Addition = + - Subtraction = - * Multiplication = *…
SYS and INFORMATION_SCHEMA
sys In Microsoft SQL Server, the sys schema is a special schema that contains system views and stored procedures that provide metadata about the SQL Server…
Spark Transformations, Actions and Lazy Evaluation and DAG.
Apache Spark RDD supports two types of Operations: Transformations Actions A Transformation is a function that produces new RDD from the existing RDDs but …
DateTime in Python
In Python, the datetime module provides classes for manipulating dates and times. It offers several functions and methods to create, manipulate, and format…
Seaborn
Seaborn is a powerful and easy-to-use data visualization library in Python built on top of Matplotlib. It's great for creating attractive and informative s…
What are System Tables, File Tables, External Tables and Graph Tables in SQL Server
1. System Tables Definition : System tables are internal tables used by SQL Server to store information about the database and server itself. These are met…
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…
Data Pipeline and ETL (Extract, Transform, Load) Process/Tool and ELT
The ETL (Extract, Transform, Load) process/tool to collect, clean, and store data in a structured format. Extract (निकालना): सबसे पहले, डेटा को विभिन्न स्र…
Understanding show() in PySpark
In PySpark, the .show() function is used to display DataFrame content in a tabular format. Syntax of show() DataFrame.show(n=20, truncate=True, vertical=Fa…
withColumn() in Pyspark
PySpark withColumn() is a transformation function of DataFrame which is used to change the value, convert the datatype of an existing column, create a new …
Python String format()/f-string Method
Python में format() / f-string method का उपयोग Strings में वैल्यूज़ को dynamic तरीके से insert करने के लिए किया जाता है। यह एक बहुत ही powerful और readable…
Working with JSON Data in Python (Using APIs and Built-in JSON Module)
इस टॉपिक में हम Python में JSON (JavaScript Object Notation) के साथ कैसे काम करते हैं, ये सीखते हैं। JSON एक डेटा फॉर्मेट है जो डेटा को store और transfer क…
JSON Data – Complete Conceptual Guide (SQL Server Perspective)
🔹 JSON kya hota hai? (Quick recap) JSON (JavaScript Object Notation) ek lightweight text format hota hai data exchange ke liye. Example: { "empId…
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…