<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Apurva pokale on Medium]]></title>
        <description><![CDATA[Stories by Apurva pokale on Medium]]></description>
        <link>https://medium.com/@apurvapokale9358?source=rss-de92aed4b5cb------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*mSW8JdBsi6tNayZb</url>
            <title>Stories by Apurva pokale on Medium</title>
            <link>https://medium.com/@apurvapokale9358?source=rss-de92aed4b5cb------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 14:12:46 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@apurvapokale9358/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Basics of excel]]></title>
            <link>https://medium.com/@apurvapokale9358/basics-of-excel-90e4842149df?source=rss-de92aed4b5cb------2</link>
            <guid isPermaLink="false">https://medium.com/p/90e4842149df</guid>
            <dc:creator><![CDATA[Apurva pokale]]></dc:creator>
            <pubDate>Wed, 16 Apr 2025 09:13:56 GMT</pubDate>
            <atom:updated>2025-04-16T09:13:56.972Z</atom:updated>
            <content:encoded><![CDATA[<p>Hey guys!<br> From today onwards, I’m starting a blog series on <strong>Excel</strong>, where I’ll cover everything — from <strong>basic to advanced</strong>, every <strong>formula</strong>, <strong>function</strong>, and <strong>feature</strong> you’ll need to master Excel like a pro. So let’s begin!</p><h4>📌 What is Excel?</h4><p><strong>Excel</strong> is spreadsheet software that helps you <strong>organize raw data</strong> into a readable format and manipulate it using <strong>calculations</strong> and <strong>formulas</strong>.</p><h4>🧾 What is a Spreadsheet?</h4><p>A <strong>spreadsheet</strong> in Excel is a <strong>single sheet or page</strong> where you can enter, organize, and analyze data using <strong>rows</strong> and <strong>columns</strong>.</p><p>Each <strong>cell</strong> is the intersection of a row and a column. The <strong>cell address</strong> is shown in the top-left box — like <strong>A1</strong>, where “A” is the column and “1” is the row.</p><h4>➕ Basic Formula Rule</h4><p>To perform any calculation in Excel, always start your formula with the <strong>equals sign (=)</strong>.</p><h4>🔢 How to Count Rows and Columns</h4><p>To find how many <strong>rows</strong> are there in a column (say Column A):</p><pre>=ROWS(A:A)</pre><p>To count how many <strong>columns</strong> are there in a row (say Row 1):</p><pre>=COLUMNS(1:1)</pre><h4>Data Types in Excel</h4><p>There are <strong>three main data types</strong> in Excel:</p><ul><li><strong>Text</strong></li><li><strong>Numerical</strong></li><li><strong>Date/Calendar</strong></li></ul><h4>✅ Understanding COUNT vs COUNTA</h4><p>Let’s say you have the following values in cells <strong>A1:A4</strong>:</p><p>1</p><p>2</p><p>3</p><p>&quot;A”</p><p>Using: =COUNTA(A1:A4) → Result: <strong>4</strong> (counts everything: numbers + text)</p><ul><li>Using: =COUNT(A1:A4) → Result: <strong>3</strong> (counts only numbers)</li></ul><h4>📊 Sample Table</h4><p>Let’s say we have this table (from cell <strong>A1:D6</strong>):</p><pre> A         B          C         D<br>Sr.No     Name       Gender    Place<br> 1         Neelam      F        Mumbai<br> 2         Raj         M        Pune<br> 3         Sonali      F        Delhi<br> 4         Prince      M        Mumbai<br> 5         Revti       F        Pune</pre><h4>👩 How to Count Number of Females?</h4><p>Use the COUNTIF function</p><pre>=COUNTIF(C2:C6, &quot;F&quot;)</pre><p>🟢 Result: <strong>3</strong></p><h4>🧮 How to Count Females from Mumbai?</h4><p>Use the COUNTIFS function (for multiple criteria):</p><pre>=COUNTIFS(C2:C6, &quot;F&quot;, D2:D6, &quot;Mumbai&quot;)</pre><p>🟢 Result: <strong>1</strong></p><h4>🎯 That’s a Wrap for Today!</h4><p>In this first blog, we covered:</p><ul><li>What is Excel and a spreadsheet</li><li>Cell basics</li><li>Counting rows &amp; columns</li><li>Data types</li><li>Difference between COUNT and COUNTA</li><li>COUNTIF and COUNTIFS examples</li></ul><p>If you have any questions, feel free to reach out at <strong>apurvapokale9358@gmail.com</strong> 💬</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=90e4842149df" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Arithmetic Operator and Special operator]]></title>
            <link>https://medium.com/@apurvapokale9358/arithmetic-operator-and-special-operator-880116067add?source=rss-de92aed4b5cb------2</link>
            <guid isPermaLink="false">https://medium.com/p/880116067add</guid>
            <dc:creator><![CDATA[Apurva pokale]]></dc:creator>
            <pubDate>Wed, 16 Apr 2025 06:46:05 GMT</pubDate>
            <atom:updated>2025-04-16T06:46:05.457Z</atom:updated>
            <content:encoded><![CDATA[<p>Hey guys! 👋<br> In the previous blog, we covered the <strong>basics of SQL</strong> and some of the most <strong>important commands</strong>. From today onwards, we’re diving into a more <strong>advanced</strong> and <strong>exciting</strong> part of SQL. Are you ready for this journey? Let’s go! 🚀</p><p><strong>⚙️ Operators in SQL</strong></p><p>First, a quick reminder:<br> 👉 SQL doesn’t understand the % symbol <em>outside</em> of specific contexts like the LIKE clause. So use it wisely!</p><p>Now, let’s explore <strong>SQL operators</strong>. Operators are used to perform operations on values (called operands). Let’s begin with <strong>logical operators</strong>: AND, OR, and NOT.</p><h4>✅ 1. AND Operator</h4><p>The AND operator returns results <strong>only if all the conditions</strong> are true.</p><p>🧪 Example:</p><pre>CREATE TABLE department (<br>  department_id INT PRIMARY KEY,<br>  department_name VARCHAR(50),<br>  department_salary INT<br>);</pre><pre>INSERT INTO department VALUES<br>(1, &#39;INSURANCE&#39;, 40000),<br>(2, &#39;FINANCE&#39;, 55000),<br>(3, &#39;IT&#39;, 58000);</pre><pre>SELECT * FROM department<br>WHERE department_name = &#39;IT&#39; AND department_salary &gt; 50000;</pre><p>🟢 <strong>Result:</strong><br> 3, &#39;IT&#39;, 58000<br> → Because <strong>both</strong> conditions are satisfied.</p><h4>✅ 2. OR Operator</h4><p>The OR operator returns results if <strong>any one</strong> of the conditions is true.</p><p>🧪 Example:</p><pre>SELECT * FROM department<br>WHERE department_name = &#39;IT&#39; OR department_salary &gt; 50000;</pre><p>🟢 <strong>Result:</strong><br> 2, &#39;FINANCE&#39;, 55000<br> 3, &#39;IT&#39;, 58000<br> → At least <strong>one</strong> condition is true for both.</p><h4>✅ 3. NOT Operator</h4><p>The NOT operator is used to <strong>negate</strong> a condition.</p><p>🧪 Example:</p><pre>SELECT * FROM department<br>WHERE NOT department_name = &#39;IT&#39; AND department_salary &gt; 50000;</pre><p>🟢 <strong>Result:</strong><br> 2, &#39;FINANCE&#39;, 55000<br> → Because &#39;IT&#39; is excluded and salary is greater than 50,000.</p><p>🧩 Special Operators: IN &amp; BETWEEN</p><h4>✅ IN Operator</h4><p>Used <strong>instead of multiple OR conditions</strong>.</p><pre>SELECT * FROM department<br>WHERE department_salary IN (55000, 58000);</pre><p>🟢 <strong>Result:</strong><br> 2, &#39;FINANCE&#39;, 55000<br> 3, &#39;IT&#39;, 58000</p><h4>✅ BETWEEN Operator</h4><p>Used to check if a value is <strong>within a range</strong>.</p><pre>SELECT * FROM department<br>WHERE department_salary BETWEEN 55000 AND 58000;</pre><p>🟢 <strong>Result:</strong><br> 2, &#39;FINANCE&#39;, 55000<br> 3, &#39;IT&#39;, 58000</p><h4>Bonus: COALESCE Function</h4><p>The COALESCE function returns the <strong>first non-null</strong> value from a list.</p><p>🧪 Example:</p><pre>SELECT COALESCE(NULL, 21, 3);</pre><p>🟢 <strong>Result:</strong> 21<br> → Because it’s the first non-null value.</p><p>I hope you found this helpful! If you have any queries, feel free to reach out:<br> 📧 <strong>apurvapokale9358@gmail.com</strong></p><p>Let’s keep learning together! 🙌</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=880116067add" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Exploring SQL Commands: DELETE vs DROP vs TRUNCATE, TCL & DQL]]></title>
            <link>https://medium.com/@apurvapokale9358/exploring-sql-commands-delete-vs-drop-vs-truncate-tcl-dql-d43b5b21b370?source=rss-de92aed4b5cb------2</link>
            <guid isPermaLink="false">https://medium.com/p/d43b5b21b370</guid>
            <dc:creator><![CDATA[Apurva pokale]]></dc:creator>
            <pubDate>Mon, 14 Apr 2025 09:34:49 GMT</pubDate>
            <atom:updated>2025-04-14T09:34:49.307Z</atom:updated>
            <content:encoded><![CDATA[<h4>Hey guys!<br> In the previous blog, we explored <strong>DDL</strong> and <strong>DML</strong> commands in detail. Today, let’s move forward and understand some other important SQL commands.</h4><h4>🔍 Difference Between DELETE, DROP, and TRUNCATE</h4><p><strong>DELETE</strong>: Deletes records <strong>row-wise</strong> from a table. You can use a WHERE clause to delete specific rows.</p><p><strong>TRUNCATE</strong>: Removes <strong>all rows</strong> from a table, but <strong>retains the structure</strong> for future use. It’s <strong>faster</strong> than DELETE because it doesn’t log each deleted row.</p><p><strong>DROP</strong>: Completely deletes the <strong>entire table</strong>, including its structure.</p><blockquote><em>🔑 Always remember: </em><em>TRUNCATE is faster than </em><em>DELETE, and </em><em>DROP removes the table itself.</em></blockquote><h4>🧩 Understanding TCL — Transaction Control Language</h4><p>There are <strong>three major TCL commands</strong>:</p><ol><li><strong>COMMIT</strong> — Saves all changes made by the transaction.</li><li><strong>ROLLBACK</strong> — Undoes changes made by the current transaction.</li><li><strong>SAVEPOINT</strong> — Sets a point within a transaction that you can roll back to.</li></ol><p>A <strong>transaction</strong> in SQL is a sequence of operations executed as a single unit of work. The purpose of transactions is to maintain <strong>data integrity</strong>, even in the case of system failures or errors.</p><blockquote><em>⚠️ Important: When working with TCL commands, </em><strong><em>you need to turn off auto commit</em></strong><em>. If auto commit is enabled, every query runs and gets stored in the database immediately, leaving no room for rollback.</em></blockquote><blockquote>When auto commit is <strong>disabled</strong>, the queries first get stored in a <strong>buffer</strong>. You can then decide whether to commit or roll them back.</blockquote><h3>🧪 Let’s Try It with an Example</h3><pre>-- Create a table<br>CREATE TABLE employee (<br>  employee_id INT PRIMARY KEY,<br>  employee_name VARCHAR(50),<br>  employee_age INT CHECK (employee_age &gt; 18)<br>);</pre><pre>-- Insert values into the table<br>INSERT INTO employee VALUES<br>(1, &#39;A&#39;, 19),<br>(2, &#39;B&#39;, 23),<br>(3, &#39;C&#39;, 27);</pre><pre>-- Turn off auto commit (syntax depends on your environment)<br>SET auto_commit = 0;</pre><pre>-- Start a transaction<br>START TRANSACTION;</pre><pre>-- Update operation<br>UPDATE employee <br>SET employee_age = 28 <br>WHERE employee_id = 1;</pre><pre>SAVEPOINT update;</pre><pre>COMMIT;  -- Saves the update</pre><pre>-- Delete operation<br>DELETE FROM employee <br>WHERE employee_id = 2;</pre><pre>SAVEPOINT delete;</pre><pre>ROLLBACK TO delete;  -- Undo the delete</pre><p>✅ After running the above queries:</p><ul><li>The update will be saved because we used COMMIT.</li></ul><p>The delete will be undone because we rolled back to the delete savepoint.</p><h4>📋 DQL — Data Query Language</h4><p><strong>DQL</strong> is used to <strong>retrieve data</strong> from the database. The most commonly used command is:</p><pre>SELECT * FROM employee;</pre><p>This command will return <strong>all the data</strong> from the employee table.</p><blockquote><em>⚠️ Note: Using </em><em>SELECT * frequently can slow down performance, especially on large tables. It&#39;s better to specify only the columns you need.</em></blockquote><blockquote>Thank you for reading this blog! If you have any queries, feel free to reach out to me at: <strong>apurvapokale9358@gmail.com</strong></blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d43b5b21b370" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[SQL Commands Explained with Queries and Results]]></title>
            <link>https://medium.com/@apurvapokale9358/sql-commands-explained-with-queries-and-results-7141cc7ee0f3?source=rss-de92aed4b5cb------2</link>
            <guid isPermaLink="false">https://medium.com/p/7141cc7ee0f3</guid>
            <dc:creator><![CDATA[Apurva pokale]]></dc:creator>
            <pubDate>Wed, 09 Apr 2025 10:37:17 GMT</pubDate>
            <atom:updated>2025-04-09T10:39:04.760Z</atom:updated>
            <content:encoded><![CDATA[<p>Hello everyone!<br> Welcome to today’s blog. In this post, we will explore the different types of SQL commands with examples and correct query syntax.</p><h4>SQL commands are categorized into five main types:</h4><p>1. DDL (Data Definition Language)</p><p>2. DML (Data Manipulation Language)</p><p>3. TCL (Transaction Control Language)</p><p>4. DCL (Data Control Language)</p><p>5. DQL (Data Query Language)</p><h3>*DDL (Data Definition Language)</h3><p>DDL commands deal with the structure of the table — creating, altering, and deleting tables.</p><h4>Common DDL Commands:</h4><ul><li>CREATE</li><li>ALTER</li><li>DROP</li><li>TRUNCATE</li></ul><h4>Example: Creating a Table</h4><pre>CREATE TABLE students (<br>   student_id INT PRIMARY KEY,<br>   student_name VARCHAR(50),<br>   student_age INT<br>);<br><br></pre><h4>Alter Command</h4><p>The ALTER command is used to make changes in the structure of an existing table. You can add, drop, modify, or rename columns.</p><h4>1) Add Column</h4><pre>ALTER TABLE students<br>ADD COLUMN gender ENUM(&#39;M&#39;, &#39;F&#39;);</pre><blockquote><em>Note: While adding a new column, it is mandatory to specify the data type.</em></blockquote><h4>2) Drop Column</h4><pre>ALTER TABLE students<br>DROP COLUMN gender;</pre><blockquote><em>Note: No need to mention the data type while dropping a column.</em></blockquote><h4>3) Modify Column Data Type</h4><pre>ALTER TABLE students<br>MODIFY COLUMN student_name CHAR(10);</pre><h4>4) Rename Table</h4><pre>RENAME TABLE students TO students_info;</pre><h4>Check the Result</h4><pre>SELECT * FROM students_info;</pre><h4>*DML (Data Manipulation Language)</h4><p>DM commands are used to manipulate data within the tables.</p><h4>1) Insert Values into the Table</h4><pre>INSERT INTO students_info VALUES<br>(1, &#39;Apurva&#39;, 25),<br>(2, &#39;Rashmi&#39;, 21),<br>(3, &#39;Tanvi&#39;, 22);</pre><h4>2) Update Values in the Table</h4><pre>UPDATE students_info<br>SET student_age = 24<br>WHERE student_id = 3;</pre><h4>3) Delete Values from the Table</h4><pre>DELETE FROM students_info<br>WHERE student_id = 1;</pre><h4>Final Output</h4><pre>SELECT * FROM students_info;</pre><h4>Conclusion</h4><p>Thank you so much for reading today’s blog!</p><p>We have learned about DDL and DML commands in SQL along with correct syntax and practical examples.</p><p>If you have any doubts or queries, feel free to reach out to me — I would love to help!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7141cc7ee0f3" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[SQL Learning — Day 2 ]]></title>
            <link>https://medium.com/@apurvapokale9358/sql-learning-day-2-073c7beb471e?source=rss-de92aed4b5cb------2</link>
            <guid isPermaLink="false">https://medium.com/p/073c7beb471e</guid>
            <dc:creator><![CDATA[Apurva pokale]]></dc:creator>
            <pubDate>Tue, 08 Apr 2025 07:41:18 GMT</pubDate>
            <atom:updated>2025-04-08T07:41:18.739Z</atom:updated>
            <content:encoded><![CDATA[<h3>SQL Learning — Day 2 🚀</h3><h3>Comments, Constraints &amp; Table Creation in SQL</h3><p>Hey guys! 👋</p><p>Yesterday, we learned the basics of SQL — so today let’s move one step ahead and discuss:</p><ul><li>Comments 📝</li><li>Constraints 🚫</li><li>Table Creation 🏗️</li></ul><p>This will help you to understand how we control and organize our data in SQL databases.</p><h4>📝 What are Comments in SQL?</h4><p>Comments are <em>non-executable</em> statements in SQL. They are written just for our reference to make code easier to understand.</p><h4>Types of Comments:</h4><p>➡️ <em>Single-line Comment</em> — Use # or --</p><pre># This is a single line comment  <br>-- Create Table Example</pre><p><em>Multi-line Comment</em> — Use /* */</p><pre>sql/*  <br>Data Types in SQL:  <br>- Numerical  <br>- String  <br>- Fractional  <br>- Enum  <br>- Date  <br>- Images/Videos  <br>*/</pre><h3>🚫 What are Constraints in SQL?</h3><p>Constraints are restrictions or rules applied on a column to maintain accuracy, consistency, and data integrity.</p><p>They help avoid errors in data entry.</p><h4>Types of Constraints:</h4><p>*NOT NULL ❌: Means Can’t leave column empty purpose of it is data must be provided</p><ul><li>UNIQUE 🔑: Means No duplicate values in column and purpose is to prevents data repetition</li><li>CHECK ✅: Means Condition based purpose is to apply specific conditions</li><li>DEFAULT ✍️: Means Auto-write values purpose is to provides default values</li><li>PRIMARY KEY 🎯: Means Unique + Not Null purpose is to uniquely identifies each record</li><li>FOREIGN KEY 🔗: Means connects Tables and purpose is to links two tables together</li></ul><h4>🔍 Example Explanation:</h4><h4>1. PRIMARY KEY = UNIQUE + NOT NULL</h4><p>Used when a column should have unique values and can’t be empty.</p><h4>2. CHECK Constraint</h4><p>Used when you want to set conditions on data entry.</p><h3>How to Create a Table in SQL?</h3><p>While creating a table, we mention:</p><ul><li>Column Name</li><li>Data Type</li><li>Constraints (if needed)</li></ul><p>Example Syntax:</p><pre>sCREATE TABLE students(  <br>  student_id INT PRIMARY KEY,  <br>  student_name VARCHAR(50),  <br>  student_age INT CHECK (student_age &gt; 6)  <br>);</pre><h4>Example of Creating Table with Constraints:</h4><pre>CREATE TABLE students(  <br>  student_id INT PRIMARY KEY,  <br>  student_name VARCHAR(50),  <br>  student_age INT CHECK (student_age &gt; 6)  <br>);</pre><h4>🎯 Composite Primary Key:</h4><p>If you want more than one column to be treated as a primary key, then we use Composite Primary Key.</p><p>Example:</p><pre>REATE TABLE employee(  <br>  employee_id INT,  <br>  employee_name VARCHAR(50),  <br>  employee_age INT CHECK(employee_age &gt; 18),  <br>  department_id INT,  <br>  CONSTRAINT PRIMARY KEY(employee_id, department_id)  <br>);</pre><h3>Foreign Key — Connecting Tables:</h3><p>Used to create a relationship between two tables.</p><p>Example:</p><pre>CREATE TABLE employee_performance(  <br>  performance_id INT PRIMARY KEY,  <br>  key_parameter VARCHAR(50),  <br>  employee_id INT,  <br>  FOREIGN KEY(employee_id) REFERENCES employee(employee_id)  <br>);</pre><h4>Thank you for reading this blog!</h4><p>If you have any queries or doubts, feel free to connect with me at:<br> 📧 apurvapokale9358@gmail.com</p><p>Happy Learning! 💻✨<br> Keep practicing SQL daily and stay consistent! 🚀</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=073c7beb471e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Basics of SQL, Databases and Data Types]]></title>
            <link>https://medium.com/@apurvapokale9358/basics-of-sql-databases-and-data-types-ece84782cadd?source=rss-de92aed4b5cb------2</link>
            <guid isPermaLink="false">https://medium.com/p/ece84782cadd</guid>
            <dc:creator><![CDATA[Apurva pokale]]></dc:creator>
            <pubDate>Mon, 07 Apr 2025 08:27:06 GMT</pubDate>
            <atom:updated>2025-04-07T08:27:06.727Z</atom:updated>
            <content:encoded><![CDATA[<h3>What is SQL?</h3><p>SQL (Structured Query Language) is used to communicate with relational databases.</p><p>Now, a common question that might come to your mind is — <em>What is a Database?</em></p><h3>Database</h3><p>A database is a place where information is stored in the form of tables (rows &amp; columns).</p><p>There are two main types of databases:</p><ul><li>DBMS (Database Management System)</li><li>RDBMS (Relational Database Management System)</li></ul><p>Let’s understand the difference between them</p><p>*DBMS Stores data in the form of files whereas RDBMS Stores data in the form of tables.</p><p>*In DBMS No strict relationship between data whereas RDBMS Maintains strict relationships between data using <em>Primary Key</em> and <em>Foreign Key.</em></p><p>*In DBMS no data integrity Ensures whereas in RDBMS data integrity maintain using <em>Constraints.</em></p><h3>Data Types in SQL</h3><p>There are 6 commonly used data types in SQL:</p><ol><li>Numerical</li><li>String</li><li>Fractional</li><li>Enum</li><li>Date</li><li>Images/Video</li></ol><h4>1) Numerical Data Type</h4><p>Numerical data types in SQL are used to store numbers in a database table.</p><p><em>Example:<br> Prices, Quantity, Age, Salary, or any other numeric value.</em></p><h4>2) String Data Type</h4><p>String data types are used to store text or characters like names, addresses, emails, city names, or any combination of letters, numbers, or symbols.</p><p>There are two types of string data types:</p><p>VARCHAR(n): Variable size storage. For example, VARCHAR(10) — if you store Hi, it will occupy space for only 2 letters.</p><p>CHAR(n):Fixed size storage. For example, CHAR(10) — if you store Hi, it will occupy space for 10 letters (remaining filled with spaces).</p><h4>3) Fractional Data Type</h4><p>Fractional data types are used to store numbers with decimal points.</p><p><em>Example:<br> Prices, Weight, Height, Percentage, or any value that is not a whole number like </em><em>10.25, </em><em>99.99, </em><em>45.1234.</em></p><h4>4) Enum Data Type</h4><p>ENUM is a special data type in SQL used to store a fixed or predefined set of values.</p><p>It means — you can only insert values from the given list.</p><p><em>Example:<br> Suppose you want to store the status of an order:</em></p><ul><li>Pending</li><li>Completed</li><li>Cancelled</li></ul><p>Nothing other than these values can be inserted.</p><h4>5) Date Data Type</h4><p>DATE data type is used to store calendar dates in SQL.</p><p><em>Format: </em><em>YYYY-MM-DD</em></p><p><em>Example: </em><em>2025-04-07</em></p><h4>6) Images/Videos</h4><p>Images and Videos can be stored in SQL using the BLOB (Binary Large Object) data type.</p><p><em>Note:<br> It’s a good practice to store file paths or URLs in the database and store the actual media files in the server or cloud storage.</em></p><h4>Final Words</h4><p>Thank you for reading this blog. I hope you found it helpful in understanding the basics of SQL, Databases, and Data Types.</p><p>If you have any questions or queries, feel free to connect with me:<br> 📧 apurvapokale9358@gmail.com</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ece84782cadd" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>