<?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 Leo Naing on Medium]]></title>
        <description><![CDATA[Stories by Leo Naing on Medium]]></description>
        <link>https://medium.com/@Leo_Naing?source=rss-629fb075591a------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*Hv0znqUbpdcnoZYFmO3clQ.jpeg</url>
            <title>Stories by Leo Naing on Medium</title>
            <link>https://medium.com/@Leo_Naing?source=rss-629fb075591a------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 23:41:57 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@Leo_Naing/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[Turn Your Dreams Into Reality With SMART Goals (ENG)]]></title>
            <link>https://medium.com/@Leo_Naing/turn-your-dreams-into-reality-with-smart-goals-7850ccbfa697?source=rss-629fb075591a------2</link>
            <guid isPermaLink="false">https://medium.com/p/7850ccbfa697</guid>
            <category><![CDATA[goal-setting]]></category>
            <category><![CDATA[smart-goals]]></category>
            <category><![CDATA[success]]></category>
            <category><![CDATA[english]]></category>
            <dc:creator><![CDATA[Leo Naing]]></dc:creator>
            <pubDate>Fri, 16 Aug 2024 03:37:38 GMT</pubDate>
            <atom:updated>2024-08-18T06:17:54.326Z</atom:updated>
            <content:encoded><![CDATA[<h4>Things to Know About SMART Goals</h4><p>Hello everyone! Today, I want to share with you what I know about setting SMART goals, which can help you become more successful in life. What do you want to achieve in life? Do you want to be healthier, wealthier, or happier? Whatever it is, a SMART goal can help you reach your aspirations.</p><figure><img alt="" src="https://cdn-images-1.medium.com/proxy/0*2TQyjxTVRxpeplgg" /><figcaption>SMART Goal crd to original owner</figcaption></figure><blockquote><strong>What is a SMART Goal?</strong></blockquote><p>A SMART Goal is one that combines five key elements: Specific, Measurable, Achievable, Relevant, and Time-bound.</p><ul><li><strong>Specific</strong>: The first thing to do is to be clear about what you want to achieve. For example, instead of saying, “<strong>I want to improve my health</strong>,” it’s more specific to say, “<strong>I will exercise three times a week this month</strong>.”</li><li><strong>Measurable</strong>: Next, you need to define how much progress you want to make. For example, instead of saying, “<strong>I want to lose weight</strong>,” it’s better to say, “<strong>I will lose 3 pounds.</strong>”</li><li><strong>Achievable</strong>: Your goal should be something you can realistically accomplish. Setting achievable goals boosts your confidence and helps you stay motivated. For instance, instead of setting a goal like “<strong>I will become fluent in five languages within a year,</strong>” you might set a more realistic goal like “<strong>I will learn 50 or 100 new Japanese vocabulary words daily.</strong>”</li><li><strong>Relevant</strong>: Your goal should align with what you truly want in life.</li><li><strong>Time</strong>-<strong>bound</strong>: Lastly, set a timeframe to achieve your goal. For example, “<strong>by the end of this year</strong>” or “<strong>within this month</strong>.”</li></ul><blockquote><strong>How to Set a SMART Goal</strong></blockquote><ol><li>Write down what you want to achieve.</li><li>Check if your goal meets the Specific, Measurable, Achievable, Relevant, and Time-bound criteria.</li><li>If it doesn’t, adjust your goal accordingly.</li><li>Once you’ve set your goal, take the necessary steps to achieve it.</li></ol><blockquote><strong>Real-Life Example Using SMART Goal</strong></blockquote><p>Let’s say there’s someone named Kyaw Kyaw who is overweight. His friends tease him by calling him “fatty,” and he doesn’t like it. So, Kyaw Kyaw decides to use a SMART Goal to change his situation. He writes in his notebook, “I will exercise for 30 minutes, three times a week, and lose 3 pounds this month.”</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/667/1*tVC0iS_3GstDx2D9VUJJgA.png" /></figure><blockquote><strong>I will exercise for 30 minutes, three times a week, and lose 3 pounds this month.</strong></blockquote><p>In this goal:</p><ul><li><strong>Specific</strong>: He specifies the type and duration of exercise.</li><li><strong>Measurable</strong>: He sets a target to lose 3 pounds.</li><li><strong>Achievable</strong>: Exercising three times a week is realistic.</li><li><strong>Relevant</strong>: Losing weight to improve health aligns with his aspirations.</li><li><strong>Time</strong>-<strong>bound</strong>: He sets a timeframe of one month.</li></ul><p>Conclusion<br>In summary, SMART Goal is a powerful tool to help you achieve greater success in life. I hope today’s discussion about SMART Goals will be useful to you. Like Kyaw Kyaw, I encourage you to set your own SMART Goal and see the difference it makes in your life.</p><p><strong>Thank you for reading!</strong> 🙏 If you enjoyed this post and found it helpful, don’t forget to clap, comment, and share it with your network.</p><p>🔔 <strong>Stay updated!</strong> Follow me on <a href="https://medium.com/@NaingDataGuru"><strong>Medium</strong></a> for more insightful content, and make sure to subscribe so you will never miss upcoming posts.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7850ccbfa697" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Turn Your Dreams With SMART Goal (MM)]]></title>
            <link>https://medium.com/@Leo_Naing/turn-your-dreams-with-smart-goal-9b81d0861d96?source=rss-629fb075591a------2</link>
            <guid isPermaLink="false">https://medium.com/p/9b81d0861d96</guid>
            <category><![CDATA[smart-goals]]></category>
            <category><![CDATA[success]]></category>
            <category><![CDATA[goal-setting]]></category>
            <category><![CDATA[burmese]]></category>
            <dc:creator><![CDATA[Leo Naing]]></dc:creator>
            <pubDate>Fri, 16 Aug 2024 03:36:37 GMT</pubDate>
            <atom:updated>2024-08-18T06:18:19.900Z</atom:updated>
            <content:encoded><![CDATA[<h4><strong>SMART Goal အကြောင်းသိကောင်းစရာ</strong></h4><p>အားလုံးပဲ မင်္ဂလာပါ။ ဒီနေ့ တော့ ကျွန်တော် ဘ၀ ကို ပိုမိုအောင်မြင်စေမဲ့ SMART Goal ချမှတ်နည်း အကြောင်းကို ကျွန်တော် သိ‌သလောက်‌လေး ပြောပြပါမယ်ခင်ဗျ။ စာဖတ်သူက ဘ၀ မှာ ဘာတွေ ရရှိချင်တာလဲ?၊ ပိုပြီးတော့ ကျန်းမာချင်တာလား?၊ ပိုပြီးချမ်းသာ ချင်တာလား?၊ ဒါမှမဟုတ်ပိုပြီးပျော်ရွှင်ချင်တာလားပေါ့? ဘာပဲဖြစ်ဖြစ် စာဖတ်သူရဲ့ရည်မှန်းချက် ကိုအောင်မြင်စေချင်ဖို့အတွက် SMART Goal ဆိုတဲ့ Goal က စာဖတ်သူကို ကူညီပေးနိုင်ပါတယ်။</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/860/0*2TQyjxTVRxpeplgg" /><figcaption>SMART Goal Crd to original owner</figcaption></figure><p><strong>SMART Goal ဆိုတာ က ဘာလဲ?</strong></p><p>SMART Goal ဆိုတာ <strong>Specific </strong>(တိကျမှု), <strong>Measurable </strong>(တိုင်းတာနိုင်သော), <strong>Achievable </strong>(လုပ်‌ဆောင်နိုင်), <strong>Relevant </strong>(သက်ဆိုင်), <strong>Time-bound </strong>(အချိန်ကန့်အသတ်) ဆိုတဲ့ အချက် ၅ ချက်ကို ပေါင်းစပ်ထားတဲ့ Goal တစ်ခုပေါ့။</p><ul><li><strong>Specific </strong>: ပထမဦးဆုံး လုပ်ရမဲ့ အရာက Specific ဆိုတဲ့ ကိုယ်ဘာကိုလုပ်မလဲ ဆိုတာ တိတိကျကျသတ်မှတ်ပါ။ ဥပမာ အားဖြင့် “<strong>ငါကျန်းမာရေး ပိုကောင်းအောင်လုပ်မယ်</strong>” ဆိုတာထက် “<strong>ဒီလအတွင်းမှာ အပတ်တိုင်း ၃ရက် လေ့ကျင့်ခန်း လုပ်တာက ပိုပြီးတော့ တိကျပါတယ်။</strong>”</li><li><strong>Measurable</strong>: နောက်တစ်ခုက တော့ Measurable ပါ။ သူကတော့ ကိုယ့် goal ကို ဘယ်လောက် ထိ သွား မလဲ ဆိုတာ သတ်မှတ်ရပါမယ်။ ဥပမာ “<strong>ငါကိုယ်အလေးချိန်လျှော့ချမယ်</strong>” ဆိုတာထက် “<strong>ငါကိုယ်အလေးချိန်ကို ၃ပေါင် ကျအောင် လျှော့မယ်</strong>” ဆိုပြီး သတ်မှတ်တာက ပိုပြီး ကောင်းတယ် ပေါ့နော်။</li><li><strong>Achievable</strong>: Achievable ဆိုတဲ့အတိုင်း ကိုယ့်ရဲ့ရည်မှန်းချက်က လုပ်ဆောင်နိုင် ၊ ဖြစ်နိုင် ရမယ် ပေါ့နော်။ ဘာလို့လဲ ဆိုတော့ လုပ်ဆောင်နိုင်တဲ့ ရည်မှန်းချက်က မိမိကိုယ်ကို စိတ်ဓာတ်မြှင့်တင် ပေးပြီး အောင်မြင်မှု ကို ရောက်ရှိ ဖို့ပိုပြီး ကူညီပေးနိုင် လို့ပါ။ ဥပမာ ပြောရမယ် ဆိုရင် “<strong>တစ်နှစ် အတွင်းမှာ ဘာသာစကား ၅မျိုး ကျွမ်းကျင်အောင် လုပ်မယ်</strong>” ဆိုတဲ့ GOAL က လုပ်‌ဆောင်နိုင် ဖြစ်နိုင်ချေ မရှိဘူးပေါ့နော် အက်လိုတွေးမဲ့ အစား “<strong>ငါတစ်နေ့ကို Japan စာ vocabulary အလုံး ၅၀ သို့မဟုတ် ၁၀၀ လေ့လာ မယ်</strong>” ဆိုတာကတော့ ပိုပြီးတော့ ဖြစ်နိုင်ချေရှိပါတယ်။</li><li><strong>Relevant</strong>: ဒါကတော့ ရိုးရှင်းပါတယ် စာဖတ်သူရဲ့ Goal က စာဖတ်သူ ဖြစ်ချင်တဲ့ ရည်းမှန်းချက်နဲ့ ကိုက်ညီ ဖို့လိုပါတယ်။</li><li><strong>Time-bound</strong>: နောက်ဆုံး တစ်ချက် အနေနဲ့ ကတော့ စာဖတ်သူရဲ့ Goal ကို ပြီးဖို့ အချိန်သတ်မှတ်ဖို့လိုပါတယ်။ ဥပမာ “<strong>ဒီနှစ်မကုန်ခင်</strong>&quot; ဒါမှမဟုတ် “<strong>ဒီလ အတွင်း</strong>&quot; စတဲ့ အချိန်‌တွေကို သတ်မှတ်နိုင်ပါတယ်။</li></ul><blockquote><strong>SMART Goal ချမှတ်နည်း</strong></blockquote><ol><li>ကိုယ်ဖြစ်ချင်တဲ့ ရည်မှန်းချက်ကို ရေးပါ။</li><li>အပေါ်ကပြောခဲ့တဲ့ Specific, Measurable, Achievable, Relevant, Time-bound ဆိုတဲ့ အချက်‌တွေနဲ့ ကိုက်ညီမှုရှိမရှိ ပြန်စစ်ပါ။</li><li>မကိုက်ညီမှု ရှိရင် ကိုယ့်ရည်မှန်းချက်ကို ပြန်လည် ပြင်ဆင်ပါ။</li><li>ရည်မှန်းချက်ကို သတ်မှတ် ပြီးပါက သတ်မှတ်ထားတဲ့ ရည်မှန်းချက်ကို ရောက်ရှိဖို့ အဆင့်ဆင့် လုပ်ပါ။</li></ol><blockquote><strong>Real Life Example Using SMART Goal</strong></blockquote><p>ကျော်ကျော်ဆိုတဲ့ လူ တယောက်ရှိတယ် ပေါ့နော် သူက အရမ်း၀ နေတဲ့ သူဖစ်နေတယ် ကျော်ကျော်ကို သူ့သူငယ်ချင်းတွေက ၀တုတ်ကြီး ဆိုပြီး စနေတယ်ပေါ့။ ကျော်ကျော်က လည်း သူ့ကို ၀တုတ်ကြီး‌လို့ စပြီးပြော‌နေတော့ သူ မကြိုက်ဘူးပေါ့</p><p>အက်တော့ ကျော်ကျော်က အိမ်မှာ သူရဲ့ notebook📒 ထဲမှာ သူ ဖြစ်ချင်တဲ့ ရည်မှန်းချက်ကို SMART Goal ကိုအသုံးချပြီး မှတ်လိုက်တယ်။ ကျော်ကျော် မှတ်လိုက်တဲ့ စာ‌သားလေးကတော့……</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/698/1*K2BQFkCDuBpEsDQT0Snw2A.png" /></figure><blockquote><strong>“ဒီလအတွင်းမှာ အပတ်စဉ် ၃ရက် တစ်ရက်ကို မိနစ်၃၀ လေ့ကျင့်ခန်းလုပ်ပြီး ကိုယ်အလေးချိန် ၃ပေါင်လျှော့ချမယ်။”</strong></blockquote><p>ဒီရည်မှန်းချက်မှာဆိုရင်….</p><ul><li><strong>Specific</strong>: ဘယ်လိုလေ့ကျင့်ခန်းမျိုး ဘယ်လောက်ကြာကြာ လုပ်မလဲ ဆိုတာ သတ်မှတ်ထားတယ်။</li><li><strong>Measurable</strong>: ကိုယ်အလေးချိန် ဘယ်လောက် လျှော့ချမယ် ဆိုတာ တိုင်းတာထားတယ်။</li><li><strong>Achieveable</strong>: အပတ်စဉ် ၃ရက် လေ့ကျင့်ခန်း လုပ်တာက လုပ်နိုင်ဖြစ်နိုင်တဲ့ အရာပါ။</li><li><strong>Relevant</strong>: ကိုယ်အလေးအချိန်လျှော့ ချပြီး ကျန်းမာရေးကောင်းအောင်လုပ်မယ် ဆိုတာ က ကျော်ကျော် ရည်မှန်းချက်နဲ့ ကိုက်ညီတယ်။</li><li><strong>Time</strong>-<strong>bound</strong>: ဒီလ အတွင်း ဆို တဲ့ အချိန်ကာလ ကို သတ်မှတ် ထားပါတယ်။</li></ul><p>အနှစ်ချုပ်အနေနဲ့ SMART Goal က ဘ၀ ကို ပိုမို အောင်မြင်စေဖို့ ကူညီနိုင်တဲ့ အကောင်းဆုံး လက်နက် တစ်ခုပါ။ ဒီနေ့ ပြောခဲ့တဲ့ SMART Goalက စာဖတ် သူတို့ အတွက် အသုံး၀င် မယ် လို့ ကျွန်တော် မျှော်လင့်ပါတယ် ခင်ဗျ။ အရှေ့မှာ ဥပမာပြောထားတဲ့ ကျော်ကျော် လိုမျိုး အတိုင်းပဲ စာဖတ်သူတို့လည်း ကိုယ်တိုင် SMART Goal တစ်ခု ချမှတ်ကြည့်ဖို့ တိုက်တွန်းပါတယ်ခင်ဗျ။</p><p><strong>Thank you for reading!</strong> 🙏 If you enjoyed this post and found it helpful, don’t forget to clap, comment, and share it with your network.</p><p>🔔 <strong>Stay updated!</strong> Follow me on <a href="https://medium.com/@NaingDataGuru"><strong>Medium</strong></a> for more insightful content, and make sure to subscribe so you will never miss upcoming posts.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=9b81d0861d96" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[What is Database Management System?]]></title>
            <link>https://medium.com/@Leo_Naing/what-is-database-management-system-dd2f90d3e672?source=rss-629fb075591a------2</link>
            <guid isPermaLink="false">https://medium.com/p/dd2f90d3e672</guid>
            <category><![CDATA[sql-command]]></category>
            <category><![CDATA[crud]]></category>
            <category><![CDATA[basic-sql]]></category>
            <category><![CDATA[database]]></category>
            <category><![CDATA[sql]]></category>
            <dc:creator><![CDATA[Leo Naing]]></dc:creator>
            <pubDate>Sat, 10 Aug 2024 04:21:12 GMT</pubDate>
            <atom:updated>2024-08-10T04:29:47.889Z</atom:updated>
            <content:encoded><![CDATA[<h4>Knowledge about Database, SQL and Basic SQL CRUD Commands by <a href="https://medium.com/u/629fb075591a">NaingDataGuru</a></h4><p>Before talking about SQL and some basic CRUD Commands,. At first, we are going to discuss: <strong>“What is Database?”</strong></p><blockquote><strong>Database</strong></blockquote><p>A database is a collection of data that can be easily accessed to get information. If we want to manage the data in the database, there is a system called “Database Management System” (DBMS).</p><p>There are two types of database management system:</p><ol><li>Relational Database Management System</li><li>Non-Relational Database Management System</li></ol><blockquote><strong>Relational Database Management System (RDBMS)</strong></blockquote><p>It is a type of database management system that can organize data into one or more tables, with each table having rows and columns. This can happen in tabular form, as shown in the below image:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/686/1*ocdn8RK-00wuMB4Uzs3z2Q.png" /><figcaption>Relation Database Management System in Tabular Form</figcaption></figure><blockquote><strong>Non-Relational Database Management System</strong></blockquote><p>A non-relational database is a type of database that does not follow the table-based relational model used in relational databases. Instead, it stores data in a variety of formats, such as key-value pairs, documents, graphs, or wide-column stores.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/252/1*5JFsDuTUrxqq7xelw8cLTg.png" /><figcaption>Non-Relational Database Management System</figcaption></figure><p>This is about the database and its types so now you will gain some knowledges about database and its types. Let’s move to the main section…</p><blockquote><strong>SQL</strong></blockquote><p>SQL, also called “Structured Query Language,&quot; is a powerful tool that is used to manage databases. It allows users to perform various operations on data stored in a database, such as retrieving specific information, adding new data, updating existing data, and deleting data. By writing SQL queries, users can ask the database to perform specific tasks, like finding all customers with a certain last name or updating the prices of products.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Iowlj3dUad7U1TwH" /><figcaption>Photo by <a href="https://unsplash.com/@rubaitulazad?utm_source=medium&amp;utm_medium=referral">Rubaitul Azad</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><blockquote><strong>SQL CRUD Operations</strong></blockquote><p>SQL CRUD refers to the basic operations you can perform on a database: <strong>Create</strong>, <strong>Read</strong>, <strong>Update</strong>, and <strong>Delete</strong>. Here’s a simple explanation:</p><ol><li><strong>Create</strong>: This means adding new information to the database. Imagine you’re putting a new file into a filing cabinet.</li><li><strong>Read</strong>: This is looking up or retrieving information from the database, like opening a file to see what’s inside.</li><li><strong>Update</strong>: This involves changing existing information or data in the database. It’s like correcting or editing a file you already have.</li><li><strong>Delete</strong>: This is removing information from the database, similar to taking a file out of the cabinet and throwing it away.</li></ol><p>These four actions are essential for managing and working with data in any database system.</p><blockquote><strong>Create</strong></blockquote><p>In simple way, it is used for creating tables with SQL <strong><em>C</em></strong>reate Command. Here is the syntax and example as shown below:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/810/1*5WK02RyCfnu2a_hI2TE0bg.png" /><figcaption>SQL Create and Syntax and Example</figcaption></figure><p>Syntax Explanations:</p><p>If we type “<strong>CREATE TABLE Refrigerator</strong>” and run this command, it means that a table called “Refrigerator” will appear, as shown in the below image :D-</p><figure><img alt="Creating Refrigerator Table" src="https://cdn-images-1.medium.com/max/583/1*bc9sw8O0FAIFFWQCZ9yppw.png" /><figcaption>Creating Refrigerator Table</figcaption></figure><pre>CREATE TABLE Refrigerator (<br> ItemID     int,<br> ItemName   varchar,<br> Quantity   int,<br> Category   varchar<br>);</pre><p>After writing above SQL Create command, the program will know that you created a table called refrigerator and that refrigerator will contain columns such as “<strong>ItemID</strong>” and “<strong>Quantity</strong>” with integer (int) datatype , “<strong>ItemName</strong>” and “<strong>Category</strong>” with variable character (varchar) datatype.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/795/1*6OmIx6hqCIABHqiza8a_jA.png" /><figcaption>Columns and its datatypes in refrigerator table</figcaption></figure><p>So the output of the refrigerator table will be as shown in the below table:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/762/1*RdhQH9SKGqIK2s2L0aL_nA.png" /><figcaption>Refrigerator Table with columns</figcaption></figure><blockquote><strong>Insert</strong></blockquote><p>The Insert command in SQL is used to add new rows (records) into a table. It allows you to add or insert the values for each column in a table.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/782/1*QVwTG8zOE5HWy_4dvg1-fA.png" /><figcaption>SQL Insert Syntax and Example</figcaption></figure><pre>INSERT INTO Refrigerator (ItemID, ItemName, Quantity, Category)<br>VALUES ( 1, ’Milk’, 2, ’Diary’ );</pre><p>Based on above codes, to add data to the refrigerator table, you need to use the ‘<strong>INSERT INTO</strong>’ statement followed by the names of the columns. After that, you can insert your data using the ‘<strong>VALUES</strong>’ clause, ensuring that the data matches the specified data types and the corresponding column names. When we run above codes, the first item will be added to the refrigerator according to the below illustration:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/994/1*c-luYW5wV656jSb9kYaHzQ.png" /><figcaption>First Item added to the refrigerator</figcaption></figure><p>So the output of refrigerator table will become as shown in the below table:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*dhvFAUewdUbBSzRKijzSWQ.png" /><figcaption>After inserting data in the refrigerator table</figcaption></figure><p>You can also insert multiple data records like that 👇</p><pre>INSERT INTO Refrigerator (ItemID, ItemName, Quantity, Category)<br>VALUES ( 2, &#39;Apple&#39;, 6, &#39;Fruit&#39; ),<br>       ( 3, &#39;Chicken Breast, 1, &#39;Meat&#39;);</pre><p>After adding new data (records) in the refrigerator table:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*gpIx2rf3gzGVgkhjYfIRbg.png" /><figcaption>New records in refrigerator table</figcaption></figure><blockquote><strong>SELECT</strong></blockquote><p>The SQL “<strong>SELECT</strong>” command is like asking a database a question to get specific information.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/746/1*aiM7s7AxbwlCm8DFBBJwPA.png" /><figcaption>SQL SELECT syntax and example</figcaption></figure><pre>SELECT itemName, Category<br>FROM Refrigerator;</pre><p>Above the SQL Select codes, it is like selecting the items that you want from the claw machine. So “<strong>itemName</strong>” and “<strong>Category</strong>” are the columns that you want to select from the refrigerator table.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/500/1*neiXqs_eZe2iOxHp2q5BPA.png" /><figcaption>Selecting data from “itemName” and “Category” columns from the refrigerator table</figcaption></figure><p>So the output of using “<strong>SELECT”</strong> will be as shown below:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/381/1*ZJn1AXf7g4cKOB1ZQHgyyw.png" /><figcaption>The output of using SELECT</figcaption></figure><blockquote>Note: If you want to select complete table, you need to use “*”</blockquote><pre>SELECT *<br>FROM Refrigerator;</pre><p>It is like selecting all columns from the refrigerator table by using * and the output is as shown below:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/858/1*Wz2jNDECe66uMhOCZ6gXfA.png" /><figcaption>Using SELECT * FROM Refrigerator</figcaption></figure><blockquote><strong>Update</strong></blockquote><p>The SQL “<strong>Update</strong>” command is like making changes or edits to information or data that&#39;s already in a database.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/747/1*RyDxBaf3lwLJDiLGfSrASg.png" /><figcaption>SQL UPDATE syntax and example</figcaption></figure><pre>UPDATE Refrigerator <br>SET ItemName = ‘Cheese’ , Quantity = 3<br>WHERE ItemID = 1;</pre><ul><li>“<strong>UPDATE Refrigerator</strong>” : This tells the database you want to make changes to the data in the <strong>Refrigerator</strong> table.</li><li>“<strong>SET ItemName = ‘Cheese’ , Quantity = 3 </strong>”: This is where you specify the changes. You are updating the <strong>ItemName</strong> to be &#39;<strong>Cheese</strong>&#39; and the “<strong>Quantity</strong>” to be 3. So, you’re saying, &quot;Change the item’s name to &#39;<strong>Cheese</strong>&#39; and set the quantity to 3.&quot;</li><li>“<strong>WHERE ItemID =1 </strong>”: This part tells the database exactly which item you want to update. You are saying, &quot;Only update the item that has an “<strong>ItemID</strong>” of 1.&quot;</li></ul><p>In short, this code finds the item in the “<strong>Refrigerator</strong>” table that has an “<strong>ItemID</strong>” of 1, and it changes the name of that item to &quot;Cheese&quot; and the quantity to 3.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/523/1*CqrqoppVaP_N6JN05W3bwQ.png" /><figcaption>Updating the ItemName and Quantity’s data from refrigerator table where ItemID is 1</figcaption></figure><p>So the output of using “<strong>UPDATE”</strong> will be as shown below:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/838/1*LqtIvQ4ShNJ2sn1MfTNyNA.png" /><figcaption>Before Updating process VS After Updating process</figcaption></figure><blockquote><strong>Delete</strong></blockquote><p>The SQL “<strong>DELETE</strong>” command is like removing or throwing away data from a database.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/745/1*KaomFR-AcvtVlMqzM6Yyyg.png" /><figcaption>SQL DELETE syntax and example</figcaption></figure><pre>DELETE FROM Refrigerator<br>WHERE ItemID = 1;</pre><p>The above SQL DELETE code:</p><ol><li>“<strong>DELETE FROM Refrigerator</strong>”: Tells the database to remove data from the <strong>Refrigerator </strong>table.</li><li>“<strong>WHERE ItemID = 1</strong>”: specifies that only the row with <strong>ItemID</strong> equal to 1 should be deleted.</li></ol><p>So, this code finds the item in the refrigerator table with <strong>ItemID </strong>1 and removes that entire row from the table.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/677/1*nWNzlSiIokpWLUAIKoFCdA.png" /><figcaption>Deleting the row that where ItemID =1</figcaption></figure><p>So the output of using “<strong>DELETE”</strong> will be as shown below:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/827/1*JWLtabKQ0Z19znFviavJhg.png" /><figcaption>Before Deleting process VS After Deleting process</figcaption></figure><p><strong>Thank you for reading!</strong> 🙏 If you enjoyed this post and found it helpful, don’t forget to clap, comment, and share it with your network.</p><p>🔔 <strong>Stay updated!</strong> Follow me on <a href="https://medium.com/@NaingDataGuru"><strong>Medium</strong></a> for more insightful content, and make sure to subscribe so you will never miss upcoming posts.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=dd2f90d3e672" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>