<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Nirmalya Mondal</title>
    <description>The latest articles on DEV Community by Nirmalya Mondal (@nirmalyax).</description>
    <link>https://dev.to/nirmalyax</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F1190961%2F5c0c2596-a1f7-4062-9de8-29a11af961a1.jpeg</url>
      <title>DEV Community: Nirmalya Mondal</title>
      <link>https://dev.to/nirmalyax</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/nirmalyax"/>
    <language>en</language>
    <item>
      <title>🎉 Hacktoberfest &amp; Durga Puja: A Bengali's October of Celebration 🌸</title>
      <dc:creator>Nirmalya Mondal</dc:creator>
      <pubDate>Wed, 16 Oct 2024 12:08:09 +0000</pubDate>
      <link>https://dev.to/nirmalyax/hacktoberfest-durga-puja-a-bengalis-october-of-celebration-4fi0</link>
      <guid>https://dev.to/nirmalyax/hacktoberfest-durga-puja-a-bengalis-october-of-celebration-4fi0</guid>
      <description>&lt;p&gt;&lt;code&gt;This is a submission for the [2024 Hacktoberfest Writing Challenge](https://dev.to/challenges/hacktoberfest): Contributor Experience&lt;/code&gt;&lt;/p&gt;

&lt;p&gt;October is my favorite month of the year, and being a Bengali, it’s easy to see why! 🥳 It’s Durga Puja time — the most awaited festival filled with joy, community, and traditions. But now, October brings me another reason to celebrate — &lt;strong&gt;Hacktoberfest&lt;/strong&gt;! 🎊 For me, Hacktoberfest is the festival of open-source, a time when tech enthusiasts like me come together to make a difference.&lt;/p&gt;

&lt;h2&gt;
  
  
  🎯 Why I Participated
&lt;/h2&gt;

&lt;p&gt;Having joined Hacktoberfest back in 2023, this annual event has become something I eagerly look forward to. It's not just about contributing code but about being part of a global movement! 🌍 Participating allows me to sharpen my skills, give back to the projects I love, and collaborate with talented people from around the world.&lt;/p&gt;

&lt;h2&gt;
  
  
  💻 Projects I Worked On
&lt;/h2&gt;

&lt;p&gt;In 2024, I completed all four PRs, and I couldn’t be prouder! Here’s a glimpse of what I worked on:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;React Projects&lt;/strong&gt; ⚛️&lt;br&gt;&lt;br&gt;
I’m a big fan of React, and this year I wanted to dive even deeper. I contributed to a variety of projects, adding features, squashing bugs, and improving the UI. It was great knowing that my contributions made some user interfaces faster and more accessible.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Docker Contributions&lt;/strong&gt; 🐳&lt;br&gt;&lt;br&gt;
As a DevOps enthusiast, Docker has been my go-to tool for managing containers. This year, I focused on optimizing Docker images, enhancing CI/CD workflows, and polishing up Docker-related documentation. It was particularly satisfying to contribute to projects where I could apply both my coding and DevOps expertise.&lt;/p&gt;&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  💡 What I Learned
&lt;/h2&gt;

&lt;p&gt;Every year, Hacktoberfest teaches me something new, and this year was no exception. Here are a few key takeaways:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;React Performance&lt;/strong&gt;: I learned several techniques to optimize React components for better performance, which is crucial for building scalable front-end applications.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Docker Efficiency&lt;/strong&gt;: My contributions in Docker led me to discover ways to reduce image sizes and improve build speeds — essential skills in DevOps.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Collaboration&lt;/strong&gt;: Open-source is all about community, and the maintainers I interacted with were incredibly helpful. I improved my communication and collaboration skills by discussing issues, reviewing code, and brainstorming solutions with contributors from around the world. 🌐&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  🧡 October: A Month of Festivals
&lt;/h2&gt;

&lt;p&gt;For me, October is not just about Durga Puja, but also about Hacktoberfest! The sense of community, excitement, and joy that both bring into my life is unmatched. Just as I eagerly await the beautiful idol of Goddess Durga each year, I now look forward to my contributions being part of a much larger picture in the world of open source. 🚀&lt;/p&gt;

&lt;h2&gt;
  
  
  🌟 Final Thoughts
&lt;/h2&gt;

&lt;p&gt;Hacktoberfest 2024 was a blast! 🎉 Completing all four PRs this year, especially in React and Docker, gave me a deep sense of accomplishment. Whether it's adding a new feature or improving documentation, every contribution is a small but meaningful step in the open-source journey. 👏&lt;/p&gt;

&lt;p&gt;As October comes to an end, I can’t help but look forward to Hacktoberfest 2025. I can’t wait to dive back into the open-source world and make an even bigger impact. Until then, here’s to continuous learning and building — for both Durga Puja and Hacktoberfest! 🛠️🙏&lt;/p&gt;

</description>
      <category>devchallenge</category>
      <category>hacktoberfest</category>
      <category>opensource</category>
    </item>
    <item>
      <title>Basic MySQL Queries: A Comprehensive Guide</title>
      <dc:creator>Nirmalya Mondal</dc:creator>
      <pubDate>Fri, 23 Aug 2024 18:52:09 +0000</pubDate>
      <link>https://dev.to/nirmalyax/basic-mysql-queries-a-comprehensive-guide-5cjb</link>
      <guid>https://dev.to/nirmalyax/basic-mysql-queries-a-comprehensive-guide-5cjb</guid>
      <description>&lt;h2&gt;
  
  
  &lt;em&gt;&lt;em&gt;Author: Nirmalya Mondal&lt;/em&gt;&lt;a href="https://nirmalyax.dev/" rel="noopener noreferrer"&gt;&lt;/a&gt;&lt;/em&gt;
&lt;/h2&gt;

&lt;h3&gt;
  
  
  Introduction
&lt;/h3&gt;

&lt;p&gt;MySQL is one of the most popular relational database management systems (RDBMS) used for web applications and other data-driven applications. Whether you’re a beginner or someone looking to brush up on your MySQL skills, understanding the basic queries is essential. This blog will walk you through some fundamental MySQL queries that you can use for database operations, table manipulations, and data management.&lt;/p&gt;

&lt;h3&gt;
  
  
  1. Database Operations
&lt;/h3&gt;

&lt;h4&gt;
  
  
  &lt;strong&gt;Create Database&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;To start with, you need a database where you will store your tables and data. Creating a database is straightforward:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;CREATE&lt;/span&gt; &lt;span class="k"&gt;DATABASE&lt;/span&gt; &lt;span class="n"&gt;my_database&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;Select Database&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Once you have created the database, use the following query to select it:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="n"&gt;USE&lt;/span&gt; &lt;span class="n"&gt;my_database&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;Drop Database&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;If you need to delete a database, use the following command:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;DROP&lt;/span&gt; &lt;span class="k"&gt;DATABASE&lt;/span&gt; &lt;span class="n"&gt;my_database&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h3&gt;
  
  
  2. Table Operations
&lt;/h3&gt;

&lt;h4&gt;
  
  
  &lt;strong&gt;Create Table&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Tables are where your data is stored. You can create a table with specific columns as follows:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;CREATE&lt;/span&gt; &lt;span class="k"&gt;TABLE&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;
    &lt;span class="n"&gt;id&lt;/span&gt; &lt;span class="nb"&gt;INT&lt;/span&gt; &lt;span class="n"&gt;AUTO_INCREMENT&lt;/span&gt; &lt;span class="k"&gt;PRIMARY&lt;/span&gt; &lt;span class="k"&gt;KEY&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="n"&gt;name&lt;/span&gt; &lt;span class="nb"&gt;VARCHAR&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;100&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
    &lt;span class="n"&gt;email&lt;/span&gt; &lt;span class="nb"&gt;VARCHAR&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;100&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
    &lt;span class="n"&gt;age&lt;/span&gt; &lt;span class="nb"&gt;INT&lt;/span&gt;
&lt;span class="p"&gt;);&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;Show Tables&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;To see all the tables in your selected database:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SHOW&lt;/span&gt; &lt;span class="n"&gt;TABLES&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;Describe Table Structure&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;If you want to know the structure of a table, you can describe it:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;DESCRIBE&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;Alter Table&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;If you need to modify a table by adding or changing columns:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Add a Column&lt;/strong&gt;
&lt;/li&gt;
&lt;/ul&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;  &lt;span class="k"&gt;ALTER&lt;/span&gt; &lt;span class="k"&gt;TABLE&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt; &lt;span class="k"&gt;ADD&lt;/span&gt; &lt;span class="n"&gt;phone&lt;/span&gt; &lt;span class="nb"&gt;VARCHAR&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;15&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Modify a Column&lt;/strong&gt;
&lt;/li&gt;
&lt;/ul&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;  &lt;span class="k"&gt;ALTER&lt;/span&gt; &lt;span class="k"&gt;TABLE&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt; &lt;span class="k"&gt;MODIFY&lt;/span&gt; &lt;span class="n"&gt;age&lt;/span&gt; &lt;span class="nb"&gt;TINYINT&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;Drop Table&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;To delete a table:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;DROP&lt;/span&gt; &lt;span class="k"&gt;TABLE&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h3&gt;
  
  
  3. Data Operations
&lt;/h3&gt;

&lt;h4&gt;
  
  
  &lt;strong&gt;Insert Data&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;To add data to a table:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;INSERT&lt;/span&gt; &lt;span class="k"&gt;INTO&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;name&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;email&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;age&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;VALUES&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s1"&gt;'John Doe'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s1"&gt;'john@example.com'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;25&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;Select Data&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Retrieve data from a table:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="n"&gt;name&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;email&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt; &lt;span class="k"&gt;WHERE&lt;/span&gt; &lt;span class="n"&gt;age&lt;/span&gt; &lt;span class="o"&gt;&amp;gt;&lt;/span&gt; &lt;span class="mi"&gt;20&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;Select All Data&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;To retrieve all data from a table:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="o"&gt;*&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;Update Data&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;To update data in a table:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;UPDATE&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt; &lt;span class="k"&gt;SET&lt;/span&gt; &lt;span class="n"&gt;age&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="mi"&gt;26&lt;/span&gt; &lt;span class="k"&gt;WHERE&lt;/span&gt; &lt;span class="n"&gt;name&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="s1"&gt;'John Doe'&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;Delete Data&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;To remove data from a table:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;DELETE&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt; &lt;span class="k"&gt;WHERE&lt;/span&gt; &lt;span class="n"&gt;name&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="s1"&gt;'John Doe'&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h3&gt;
  
  
  4. Conditional Queries
&lt;/h3&gt;

&lt;h4&gt;
  
  
  &lt;strong&gt;WHERE Clause&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Use the &lt;code&gt;WHERE&lt;/code&gt; clause to filter records based on specific conditions:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="o"&gt;*&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt; &lt;span class="k"&gt;WHERE&lt;/span&gt; &lt;span class="n"&gt;age&lt;/span&gt; &lt;span class="o"&gt;&amp;gt;&lt;/span&gt; &lt;span class="mi"&gt;20&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;AND/OR Conditions&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Combine multiple conditions using &lt;code&gt;AND&lt;/code&gt; or &lt;code&gt;OR&lt;/code&gt;:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="o"&gt;*&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt; &lt;span class="k"&gt;WHERE&lt;/span&gt; &lt;span class="n"&gt;age&lt;/span&gt; &lt;span class="o"&gt;&amp;gt;&lt;/span&gt; &lt;span class="mi"&gt;20&lt;/span&gt; &lt;span class="k"&gt;AND&lt;/span&gt; &lt;span class="n"&gt;name&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="s1"&gt;'John Doe'&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;IN Clause&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Select data based on a list of values:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="o"&gt;*&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt; &lt;span class="k"&gt;WHERE&lt;/span&gt; &lt;span class="n"&gt;age&lt;/span&gt; &lt;span class="k"&gt;IN&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;20&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;25&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;30&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;BETWEEN Clause&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Filter data within a range:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="o"&gt;*&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt; &lt;span class="k"&gt;WHERE&lt;/span&gt; &lt;span class="n"&gt;age&lt;/span&gt; &lt;span class="k"&gt;BETWEEN&lt;/span&gt; &lt;span class="mi"&gt;20&lt;/span&gt; &lt;span class="k"&gt;AND&lt;/span&gt; &lt;span class="mi"&gt;30&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;LIKE Clause&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Search for patterns using the &lt;code&gt;LIKE&lt;/code&gt; clause:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="o"&gt;*&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt; &lt;span class="k"&gt;WHERE&lt;/span&gt; &lt;span class="n"&gt;name&lt;/span&gt; &lt;span class="k"&gt;LIKE&lt;/span&gt; &lt;span class="s1"&gt;'J%'&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;IS NULL / IS NOT NULL&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Filter records with &lt;code&gt;NULL&lt;/code&gt; or &lt;code&gt;NOT NULL&lt;/code&gt; values:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="o"&gt;*&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt; &lt;span class="k"&gt;WHERE&lt;/span&gt; &lt;span class="n"&gt;email&lt;/span&gt; &lt;span class="k"&gt;IS&lt;/span&gt; &lt;span class="k"&gt;NULL&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h3&gt;
  
  
  5. Aggregate Functions
&lt;/h3&gt;

&lt;h4&gt;
  
  
  &lt;strong&gt;COUNT&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Count the number of rows:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="k"&gt;COUNT&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="o"&gt;*&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;SUM&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Calculate the sum of a column:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="k"&gt;SUM&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;age&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;AVG&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Find the average value of a column:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="k"&gt;AVG&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;age&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;MAX and MIN&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Find the maximum or minimum value of a column:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="k"&gt;MAX&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;age&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;





&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="k"&gt;MIN&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;age&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h3&gt;
  
  
  6. Grouping and Sorting
&lt;/h3&gt;

&lt;h4&gt;
  
  
  &lt;strong&gt;GROUP BY&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Group data based on one or more columns:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="n"&gt;age&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="k"&gt;COUNT&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="o"&gt;*&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt; &lt;span class="k"&gt;GROUP&lt;/span&gt; &lt;span class="k"&gt;BY&lt;/span&gt; &lt;span class="n"&gt;age&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;HAVING&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Filter grouped data:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="n"&gt;age&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="k"&gt;COUNT&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="o"&gt;*&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt; &lt;span class="k"&gt;GROUP&lt;/span&gt; &lt;span class="k"&gt;BY&lt;/span&gt; &lt;span class="n"&gt;age&lt;/span&gt; &lt;span class="k"&gt;HAVING&lt;/span&gt; &lt;span class="k"&gt;COUNT&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="o"&gt;*&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="o"&gt;&amp;gt;&lt;/span&gt; &lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;ORDER BY&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Sort data in ascending or descending order:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="o"&gt;*&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt; &lt;span class="k"&gt;ORDER&lt;/span&gt; &lt;span class="k"&gt;BY&lt;/span&gt; &lt;span class="n"&gt;age&lt;/span&gt; &lt;span class="k"&gt;DESC&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h3&gt;
  
  
  7. Join Operations
&lt;/h3&gt;

&lt;h4&gt;
  
  
  &lt;strong&gt;Inner Join&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Fetch data from multiple tables where the condition is met in both:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;name&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;orders&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;order_date&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;
&lt;span class="k"&gt;INNER&lt;/span&gt; &lt;span class="k"&gt;JOIN&lt;/span&gt; &lt;span class="n"&gt;orders&lt;/span&gt; &lt;span class="k"&gt;ON&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;id&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;orders&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;user_id&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;Left Join&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Fetch data from the left table and matching rows from the right table:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;name&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;orders&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;order_date&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;
&lt;span class="k"&gt;LEFT&lt;/span&gt; &lt;span class="k"&gt;JOIN&lt;/span&gt; &lt;span class="n"&gt;orders&lt;/span&gt; &lt;span class="k"&gt;ON&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;id&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;orders&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;user_id&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;Right Join&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Fetch data from the right table and matching rows from the left table:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;name&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;orders&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;order_date&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;
&lt;span class="k"&gt;RIGHT&lt;/span&gt; &lt;span class="k"&gt;JOIN&lt;/span&gt; &lt;span class="n"&gt;orders&lt;/span&gt; &lt;span class="k"&gt;ON&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;id&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;orders&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;user_id&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h3&gt;
  
  
  8. Subqueries
&lt;/h3&gt;

&lt;h4&gt;
  
  
  &lt;strong&gt;Subquery in WHERE&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Use a subquery to filter results:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="n"&gt;name&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt; &lt;span class="k"&gt;WHERE&lt;/span&gt; &lt;span class="n"&gt;id&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="n"&gt;user_id&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;orders&lt;/span&gt; &lt;span class="k"&gt;WHERE&lt;/span&gt; &lt;span class="n"&gt;order_id&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;Subquery in SELECT&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Use a subquery to calculate values:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="n"&gt;name&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="k"&gt;COUNT&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="o"&gt;*&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;orders&lt;/span&gt; &lt;span class="k"&gt;WHERE&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;id&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;orders&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;user_id&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;AS&lt;/span&gt; &lt;span class="n"&gt;order_count&lt;/span&gt;
&lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h3&gt;
  
  
  9. Views
&lt;/h3&gt;

&lt;h4&gt;
  
  
  &lt;strong&gt;Create View&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Create a virtual table based on a query:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;CREATE&lt;/span&gt; &lt;span class="k"&gt;VIEW&lt;/span&gt; &lt;span class="n"&gt;user_orders&lt;/span&gt; &lt;span class="k"&gt;AS&lt;/span&gt;
&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;name&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;orders&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;order_date&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;
&lt;span class="k"&gt;INNER&lt;/span&gt; &lt;span class="k"&gt;JOIN&lt;/span&gt; &lt;span class="n"&gt;orders&lt;/span&gt; &lt;span class="k"&gt;ON&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;id&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;orders&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;user_id&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;Drop View&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Delete a view:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;DROP&lt;/span&gt; &lt;span class="k"&gt;VIEW&lt;/span&gt; &lt;span class="n"&gt;user_orders&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h3&gt;
  
  
  10. Indexing
&lt;/h3&gt;

&lt;h4&gt;
  
  
  &lt;strong&gt;Create Index&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Improve query performance by creating an index:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;CREATE&lt;/span&gt; &lt;span class="k"&gt;INDEX&lt;/span&gt; &lt;span class="n"&gt;idx_name&lt;/span&gt; &lt;span class="k"&gt;ON&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;name&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  &lt;strong&gt;Drop Index&lt;/strong&gt;
&lt;/h4&gt;

&lt;p&gt;Remove an index:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;DROP&lt;/span&gt; &lt;span class="k"&gt;INDEX&lt;/span&gt; &lt;span class="n"&gt;idx_name&lt;/span&gt; &lt;span class="k"&gt;ON&lt;/span&gt; &lt;span class="n"&gt;users&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h3&gt;
  
  
  Conclusion
&lt;/h3&gt;

&lt;p&gt;Understanding these basic MySQL queries is essential for anyone working with relational databases. Whether you are managing data, optimizing queries, or ensuring data integrity, these commands form the foundation of your MySQL skills. By mastering them, you'll be well-equipped to handle most database-related tasks with ease.&lt;/p&gt;

</description>
      <category>sql</category>
      <category>mysql</category>
      <category>database</category>
      <category>microsoft</category>
    </item>
    <item>
      <title>Scaling Your AWS Infrastructure with Load Balancers, Auto Scaling, and CloudWatch.</title>
      <dc:creator>Nirmalya Mondal</dc:creator>
      <pubDate>Mon, 29 Apr 2024 12:49:19 +0000</pubDate>
      <link>https://dev.to/nirmalyax/scaling-your-aws-infrastructure-with-load-balancers-auto-scaling-and-cloudwatch-2kkf</link>
      <guid>https://dev.to/nirmalyax/scaling-your-aws-infrastructure-with-load-balancers-auto-scaling-and-cloudwatch-2kkf</guid>
      <description>&lt;p&gt;In the world of cloud computing, scalability and high availability are crucial for ensuring your applications can handle fluctuating traffic demands and remain resilient to failures. Amazon Web Services (AWS) provides a suite of services that work together to achieve these goals, including Elastic Load Balancing, Auto Scaling, and CloudWatch.&lt;/p&gt;

&lt;h2&gt;
  
  
  Elastic Load Balancing
&lt;/h2&gt;

&lt;p&gt;Elastic Load Balancing (ELB) is a service that automatically distributes incoming traffic across multiple EC2 instances. By distributing the load across a group of instances, ELB enhances the fault tolerance of your applications, ensuring that if one instance fails, traffic is automatically rerouted to the remaining healthy instances.&lt;/p&gt;

&lt;p&gt;ELB supports three types of load balancers:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Application Load Balancer&lt;/strong&gt;: Ideal for load balancing HTTP and HTTPS traffic, it can route traffic based on advanced routing rules, such as URL paths and host-based routing.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Network Load Balancer&lt;/strong&gt;: Designed for load balancing TCP, UDP, and TLS traffic, it offers exceptional performance and low latency.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Classic Load Balancer&lt;/strong&gt;: The legacy load balancer that routes traffic based on application or network level information.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Auto Scaling
&lt;/h2&gt;

&lt;p&gt;Auto Scaling is a service that automatically adjusts the number of EC2 instances in your application based on defined conditions, such as CPU utilization, network traffic, or custom metrics. By automatically scaling your resources up or down, Auto Scaling ensures that you have the right amount of compute capacity to handle your application's workload while optimizing costs.&lt;/p&gt;

&lt;p&gt;Auto Scaling groups are the core component of Auto Scaling, where you define the desired capacity, minimum and maximum number of instances, and scaling policies. These policies determine when and how instances should be launched or terminated based on the defined metrics.&lt;/p&gt;

&lt;h2&gt;
  
  
  CloudWatch
&lt;/h2&gt;

&lt;p&gt;CloudWatch is a monitoring and observability service that collects and tracks metrics, logs, and events from your AWS resources and applications. It provides visibility into resource utilization, application performance, and operational health.&lt;/p&gt;

&lt;p&gt;In the context of Auto Scaling, CloudWatch plays a crucial role by providing the metrics that trigger scaling events. You can define CloudWatch alarms based on specific metrics, such as CPU utilization or network traffic, and use these alarms to trigger Auto Scaling policies.&lt;/p&gt;

&lt;h2&gt;
  
  
  Putting it All Together
&lt;/h2&gt;

&lt;p&gt;By combining these services, you can build a highly scalable and resilient infrastructure for your applications:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Deploy your application across multiple EC2 instances in an Auto Scaling group.&lt;/li&gt;
&lt;li&gt;Configure an Elastic Load Balancer to distribute traffic across these instances.&lt;/li&gt;
&lt;li&gt;Set up CloudWatch alarms to monitor specific metrics, such as CPU utilization or request counts.&lt;/li&gt;
&lt;li&gt;Define Auto Scaling policies that scale out (add instances) when the CloudWatch alarms indicate high load, and scale in (remove instances) when the load decreases.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;This architecture ensures that your application can handle traffic spikes by automatically launching additional instances, while also reducing costs by terminating unnecessary instances during periods of low demand.&lt;/p&gt;

&lt;p&gt;Additionally, CloudWatch can be used to monitor various aspects of your infrastructure, including ELB metrics, Auto Scaling group metrics, and custom application metrics, providing you with comprehensive visibility into your system's performance and health.&lt;/p&gt;

&lt;p&gt;By leveraging these powerful AWS services, you can build a highly scalable, fault-tolerant, and cost-effective infrastructure that can adapt to changing demands, ensuring your applications remain available and responsive to your users.&lt;/p&gt;

&lt;h2&gt;
  
  
  Architecture Diagram
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;+---------------+
|     Client    |
+---------------+
        |
+---------------+
| Elastic Load  |
|   Balancer    |
+---------------+
        |
+---------------+
|  Auto Scaling |
|     Group     |
+---------------+
|   EC2    |   EC2    |   EC2    |
|Instance  |  Instance |  Instance|
+---------------+---------------+
        |
+---------------+
|   CloudWatch  |
|    Alarms     |
+---------------+
        |
+---------------+
|   Auto Scaling|
|    Policies   |
+---------------+
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Flulpih3uuxi5xt4x05xy.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Flulpih3uuxi5xt4x05xy.png" alt="architecture" width="800" height="631"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;The architecture diagram illustrates the interactions between the different AWS services:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Clients send requests to the Elastic Load Balancer.&lt;/li&gt;
&lt;li&gt;The Elastic Load Balancer distributes incoming traffic across the EC2 instances in the Auto Scaling group.&lt;/li&gt;
&lt;li&gt;CloudWatch monitors various metrics from the EC2 instances, such as CPU utilization or request counts.&lt;/li&gt;
&lt;li&gt;When CloudWatch alarms are triggered based on the defined thresholds, Auto Scaling policies are invoked.&lt;/li&gt;
&lt;li&gt;Auto Scaling policies either launch or terminate EC2 instances within the Auto Scaling group to adjust the capacity based on the current demand.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;This continuous cycle of monitoring, scaling, and load balancing ensures that your application can handle varying traffic loads while maintaining high availability and optimizing resource utilization.&lt;/p&gt;

</description>
    </item>
    <item>
      <title>Scaling Your AWS Infrastructure with Load Balancers, Auto Scaling, and CloudWatch.</title>
      <dc:creator>Nirmalya Mondal</dc:creator>
      <pubDate>Mon, 29 Apr 2024 12:49:13 +0000</pubDate>
      <link>https://dev.to/nirmalyax/scaling-your-aws-infrastructure-with-load-balancers-auto-scaling-and-cloudwatch-9l</link>
      <guid>https://dev.to/nirmalyax/scaling-your-aws-infrastructure-with-load-balancers-auto-scaling-and-cloudwatch-9l</guid>
      <description>&lt;p&gt;In the world of cloud computing, scalability and high availability are crucial for ensuring your applications can handle fluctuating traffic demands and remain resilient to failures. Amazon Web Services (AWS) provides a suite of services that work together to achieve these goals, including Elastic Load Balancing, Auto Scaling, and CloudWatch.&lt;/p&gt;

&lt;h2&gt;
  
  
  Elastic Load Balancing
&lt;/h2&gt;

&lt;p&gt;Elastic Load Balancing (ELB) is a service that automatically distributes incoming traffic across multiple EC2 instances. By distributing the load across a group of instances, ELB enhances the fault tolerance of your applications, ensuring that if one instance fails, traffic is automatically rerouted to the remaining healthy instances.&lt;/p&gt;

&lt;p&gt;ELB supports three types of load balancers:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Application Load Balancer&lt;/strong&gt;: Ideal for load balancing HTTP and HTTPS traffic, it can route traffic based on advanced routing rules, such as URL paths and host-based routing.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Network Load Balancer&lt;/strong&gt;: Designed for load balancing TCP, UDP, and TLS traffic, it offers exceptional performance and low latency.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Classic Load Balancer&lt;/strong&gt;: The legacy load balancer that routes traffic based on application or network level information.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Auto Scaling
&lt;/h2&gt;

&lt;p&gt;Auto Scaling is a service that automatically adjusts the number of EC2 instances in your application based on defined conditions, such as CPU utilization, network traffic, or custom metrics. By automatically scaling your resources up or down, Auto Scaling ensures that you have the right amount of compute capacity to handle your application's workload while optimizing costs.&lt;/p&gt;

&lt;p&gt;Auto Scaling groups are the core component of Auto Scaling, where you define the desired capacity, minimum and maximum number of instances, and scaling policies. These policies determine when and how instances should be launched or terminated based on the defined metrics.&lt;/p&gt;

&lt;h2&gt;
  
  
  CloudWatch
&lt;/h2&gt;

&lt;p&gt;CloudWatch is a monitoring and observability service that collects and tracks metrics, logs, and events from your AWS resources and applications. It provides visibility into resource utilization, application performance, and operational health.&lt;/p&gt;

&lt;p&gt;In the context of Auto Scaling, CloudWatch plays a crucial role by providing the metrics that trigger scaling events. You can define CloudWatch alarms based on specific metrics, such as CPU utilization or network traffic, and use these alarms to trigger Auto Scaling policies.&lt;/p&gt;

&lt;h2&gt;
  
  
  Putting it All Together
&lt;/h2&gt;

&lt;p&gt;By combining these services, you can build a highly scalable and resilient infrastructure for your applications:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Deploy your application across multiple EC2 instances in an Auto Scaling group.&lt;/li&gt;
&lt;li&gt;Configure an Elastic Load Balancer to distribute traffic across these instances.&lt;/li&gt;
&lt;li&gt;Set up CloudWatch alarms to monitor specific metrics, such as CPU utilization or request counts.&lt;/li&gt;
&lt;li&gt;Define Auto Scaling policies that scale out (add instances) when the CloudWatch alarms indicate high load, and scale in (remove instances) when the load decreases.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;This architecture ensures that your application can handle traffic spikes by automatically launching additional instances, while also reducing costs by terminating unnecessary instances during periods of low demand.&lt;/p&gt;

&lt;p&gt;Additionally, CloudWatch can be used to monitor various aspects of your infrastructure, including ELB metrics, Auto Scaling group metrics, and custom application metrics, providing you with comprehensive visibility into your system's performance and health.&lt;/p&gt;

&lt;p&gt;By leveraging these powerful AWS services, you can build a highly scalable, fault-tolerant, and cost-effective infrastructure that can adapt to changing demands, ensuring your applications remain available and responsive to your users.&lt;/p&gt;

&lt;h2&gt;
  
  
  Architecture Diagram
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;+---------------+
|     Client    |
+---------------+
        |
+---------------+
| Elastic Load  |
|   Balancer    |
+---------------+
        |
+---------------+
|  Auto Scaling |
|     Group     |
+---------------+
|   EC2    |   EC2    |   EC2    |
|Instance  |  Instance |  Instance|
+---------------+---------------+
        |
+---------------+
|   CloudWatch  |
|    Alarms     |
+---------------+
        |
+---------------+
|   Auto Scaling|
|    Policies   |
+---------------+
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Flulpih3uuxi5xt4x05xy.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Flulpih3uuxi5xt4x05xy.png" alt="architecture" width="800" height="631"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;The architecture diagram illustrates the interactions between the different AWS services:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Clients send requests to the Elastic Load Balancer.&lt;/li&gt;
&lt;li&gt;The Elastic Load Balancer distributes incoming traffic across the EC2 instances in the Auto Scaling group.&lt;/li&gt;
&lt;li&gt;CloudWatch monitors various metrics from the EC2 instances, such as CPU utilization or request counts.&lt;/li&gt;
&lt;li&gt;When CloudWatch alarms are triggered based on the defined thresholds, Auto Scaling policies are invoked.&lt;/li&gt;
&lt;li&gt;Auto Scaling policies either launch or terminate EC2 instances within the Auto Scaling group to adjust the capacity based on the current demand.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;This continuous cycle of monitoring, scaling, and load balancing ensures that your application can handle varying traffic loads while maintaining high availability and optimizing resource utilization.&lt;/p&gt;

</description>
      <category>aws</category>
      <category>cloud</category>
      <category>devops</category>
    </item>
    <item>
      <title>Mastering Git: Cheatsheets, Commands, and Interview Prep</title>
      <dc:creator>Nirmalya Mondal</dc:creator>
      <pubDate>Sat, 27 Apr 2024 06:39:55 +0000</pubDate>
      <link>https://dev.to/nirmalyax/mastering-github-cheatsheets-commands-and-interview-prep-49c9</link>
      <guid>https://dev.to/nirmalyax/mastering-github-cheatsheets-commands-and-interview-prep-49c9</guid>
      <description>&lt;p&gt;&lt;em&gt;&lt;a href="https://github.com/" rel="noopener noreferrer"&gt;GitHub&lt;/a&gt;&lt;/em&gt; has become an essential tool for developers worldwide, enabling seamless collaboration, version control, and code management. Whether you're a seasoned developer or just starting, mastering GitHub can give you a significant edge in your career. In this comprehensive blog post, we'll explore GitHub cheatsheets, command descriptions, and provide a curated list of interview questions to help you ace your next GitHub-related interview.&lt;/p&gt;

&lt;h2&gt;
  
  
  Git vs GitHub
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;Q. ARE THEY SAME?&lt;/strong&gt;&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;A Big NO!&lt;br&gt;
Git and GitHub are different tools with distinct purposes, and it's important not to confuse them.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;&lt;strong&gt;Git&lt;/strong&gt; is a &lt;strong&gt;distributed version control system&lt;/strong&gt; that manages and tracks changes in source code during software development. It allows developers to:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Work on the same codebase simultaneously&lt;/li&gt;
&lt;li&gt;Track changes and revert to previous versions&lt;/li&gt;
&lt;li&gt;Collaborate effectively with team members&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;strong&gt;GitHub&lt;/strong&gt; is a &lt;strong&gt;web-based hosting service for Git repositories&lt;/strong&gt;. It provides:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;A central repository for storing Git repositories&lt;/li&gt;
&lt;li&gt;A user-friendly interface for managing repositories&lt;/li&gt;
&lt;li&gt;Tools for collaboration, such as pull requests and issue tracking&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;In essence, &lt;strong&gt;Git&lt;/strong&gt; is the &lt;strong&gt;version control system&lt;/strong&gt;, while &lt;strong&gt;GitHub&lt;/strong&gt; is the &lt;strong&gt;platform for hosting and collaborating on Git repositories&lt;/strong&gt;.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;Git (Version Control System)
- Manages code changes
- Distributed version control

GitHub (Hosting and Collaboration)
- Hosts Git repositories
- Facilitates collaboration
- Pull requests, issue tracking, etc.
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Using Git and GitHub together streamlines collaboration, version control, backup, and project management for software development teams.&lt;/p&gt;

&lt;h2&gt;
  
  
  Git Cheatsheets
&lt;/h2&gt;

&lt;p&gt;Cheatsheets are handy resources that provide a quick reference to commonly used commands and workflows. Here are some essential GitHub cheatsheets to bookmark:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;&lt;a href="https://education.github.com/git-cheat-sheet-education.pdf" rel="noopener noreferrer"&gt;Git Cheat Sheet&lt;/a&gt;&lt;/strong&gt;: This official cheatsheet covers basic Git commands, setup, and configuration.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;&lt;a href="https://github.com/MarcoBehler/github-flow-cheatsheet" rel="noopener noreferrer"&gt;GitHub Flow Cheat Sheet&lt;/a&gt;&lt;/strong&gt;: A visual guide to the GitHub Flow, a lightweight, branch-based workflow.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;&lt;a href="https://www.git-tower.com/learn/cheat-sheets/git" rel="noopener noreferrer"&gt;Git Cheatsheet from Tower&lt;/a&gt;&lt;/strong&gt;: A comprehensive cheatsheet covering various Git commands and scenarios.&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  Git Command Descriptions
&lt;/h2&gt;

&lt;p&gt;Understanding GitHub commands is crucial for efficient version control and collaboration. Here's a breakdown of some essential commands:&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Command&lt;/th&gt;
&lt;th&gt;Description&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git init&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Initializes a new Git repository in the current directory.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git clone&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Creates a local copy of a remote repository.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git add&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Stages changes for the next commit.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git commit&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Records staged changes to the repository.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git push&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Uploads local commits to a remote repository.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git pull&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Downloads commits, files, and updates from a remote repository.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git branch&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Lists, creates, or deletes branches.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git checkout&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Switches between branches or restores files from a specific commit.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git merge&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Combines the changes from one branch into another.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git log&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Shows the commit history for the current branch.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git stash&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Temporarily stores changes that you don't want to commit immediately.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git stash pop&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Applies the most recently stashed changes and removes them from the stash.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git reset&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Undoes changes to the staging area or committed changes.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git revert&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Reverts a specific commit by creating a new commit that undoes the changes introduced by the specified commit.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git diff&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Shows the differences between commits, branches, or your working directory and the staging area.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git status&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Displays the current state of your working directory and staging area, showing which files have been modified, added, or removed.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git remote&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Manages the remote repository connections.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git fetch&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Downloads objects and references from a remote repository without merging them into your local repository.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git rebase&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Applies commits from one branch onto another branch, rewriting the commit history in the process.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git tag&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Creates, lists, deletes, or verifies tags, which are references used to mark specific points in the commit history.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git blame&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Shows who made each line change in a file and when the changes were made.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git cherry-pick&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Applies specific commits from one branch to another branch.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git clean&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Removes untracked files from the working directory.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;git reflog&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Shows a log of references and the commit history, providing a way to recover lost commits or branches.&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;h2&gt;
  
  
  Git &amp;amp; GitHub Interview Questions
&lt;/h2&gt;

&lt;p&gt;Preparing for GitHub-related interviews can be daunting, but practicing with relevant questions can boost your confidence and preparedness. Here are some common GitHub interview questions:&lt;/p&gt;

&lt;p&gt;1.&lt;strong&gt;What is Git, and how is it different from GitHub?&lt;/strong&gt;&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;Git is a distributed version control system that allows you to track changes in your code over time. It is a tool for managing and coordinating changes across multiple developers working on the same codebase. GitHub, on the other hand, is a web-based hosting service for Git repositories, providing a platform for collaboration, code review, issue tracking, and project management.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;2.&lt;strong&gt;Explain the GitHub Flow workflow.&lt;/strong&gt;&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;The GitHub Flow is a lightweight, branch-based workflow that integrates seamlessly with GitHub. It involves creating a new branch for each feature or bug fix, making commits to that branch, opening a pull request for code review, and merging the branch into the main branch after the review and approval process.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;3.&lt;strong&gt;How do you resolve merge conflicts in GitHub?&lt;/strong&gt;&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;Merge conflicts occur when two or more branches have made changes to the same lines of code. To resolve a merge conflict, you need to open the conflicted file(s) in a text editor, locate the conflict markers (&lt;code&gt;&amp;lt;&amp;lt;&amp;lt;&amp;lt;&amp;lt;&amp;lt;&amp;lt;&lt;/code&gt;, &lt;code&gt;=======&lt;/code&gt;, and &lt;code&gt;&amp;gt;&amp;gt;&amp;gt;&amp;gt;&amp;gt;&amp;gt;&amp;gt;&lt;/code&gt;), and manually edit the file to keep the desired changes. After resolving the conflicts, you can add the updated files and commit the changes.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;4.&lt;strong&gt;What is a pull request, and how do you create one?&lt;/strong&gt;&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;A pull request is a way to propose and collaborate on changes to a repository. To create a pull request, you first push your changes to a new branch in your forked repository, then navigate to the original repository on GitHub and create a new pull request. This allows other contributors to review your changes, provide feedback, and ultimately merge your branch into the main codebase.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;5.&lt;strong&gt;How do you revert a commit in GitHub?&lt;/strong&gt;&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;To revert a commit in GitHub, you can use the &lt;code&gt;git revert&lt;/code&gt; command followed by the commit hash you want to revert. This creates a new commit that undoes the changes introduced by the specified commit. Alternatively, you can use the GitHub interface to revert a commit by navigating to the commit, clicking the "Revert" button, and creating a new pull request with the reverted changes.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;6.&lt;strong&gt;What are branches in Git, and how do you create and manage them?&lt;/strong&gt;&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;Branches in Git represent independent lines of development. They allow you to work on new features, bug fixes, or experiments without affecting the main codebase. To create a new branch, you can use the &lt;code&gt;git branch &amp;lt;branch-name&amp;gt;&lt;/code&gt; command, and then switch to that branch with &lt;code&gt;git checkout &amp;lt;branch-name&amp;gt;&lt;/code&gt;. Managing branches involves merging changes back into the main branch, deleting obsolete branches, and maintaining a clear branching strategy.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;7.&lt;strong&gt;How do you fork a repository on GitHub?&lt;/strong&gt;&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;Forking a repository on GitHub creates a personal copy of the original repository under your GitHub account. This allows you to freely experiment with changes without affecting the original project. To fork a repository, navigate to the repository on GitHub, click the "Fork" button in the top-right corner, and choose the account where you want to create the fork.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;8.&lt;strong&gt;What is the difference between &lt;code&gt;git pull&lt;/code&gt; and &lt;code&gt;git fetch&lt;/code&gt;?&lt;/strong&gt;&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;&lt;code&gt;git pull&lt;/code&gt; is a combination of &lt;code&gt;git fetch&lt;/code&gt; and &lt;code&gt;git merge&lt;/code&gt;. It fetches the latest changes from the remote repository and automatically merges them into your local branch. &lt;code&gt;git fetch&lt;/code&gt;, on the other hand, only downloads the latest changes from the remote repository without merging them. This allows you to review the changes before merging them into your local branch.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;9.&lt;strong&gt;How do you squash multiple commits into a single commit in GitHub?&lt;/strong&gt;&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;To squash multiple commits into a single commit in GitHub, you can use the interactive rebase feature. First, you need to run &lt;code&gt;git rebase -i HEAD~n&lt;/code&gt;, where &lt;code&gt;n&lt;/code&gt; is the number of commits you want to squash. In the interactive rebase editor, change the word "pick" to "squash" for the commits you want to combine. After saving and exiting the editor, you'll be prompted to provide a new commit message for the squashed commit.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;10.&lt;strong&gt;What is a GitHub Action, and how can it be used in a project?&lt;/strong&gt;&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;GitHub Actions is a continuous integration and continuous deployment (CI/CD) platform provided by GitHub. It allows you to automate your software development workflows, such as building, testing, and deploying your code. You can define custom workflows using YAML files in your repository, triggered by events like pushes, pull requests, or scheduled tasks. GitHub Actions can be used for tasks like running tests, building and deploying applications, managing releases, and more.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;Remember, mastering Git &amp;amp; GitHub is an ongoing process, and regular practice and exposure to real-world scenarios are key to becoming proficient. Stay curious, explore additional resources, and don't hesitate to reach out to the GitHub community for guidance and support.&lt;/p&gt;

&lt;p&gt;Happy coding and collaborating!&lt;br&gt;
&lt;a href="https://nirmalyax.dev" rel="noopener noreferrer"&gt;Nirmalya Mondal&lt;/a&gt;&lt;/p&gt;

</description>
      <category>git</category>
      <category>github</category>
      <category>githubactions</category>
      <category>tutorial</category>
    </item>
    <item>
      <title>The Definitive Guide to Installing JENKINS on an EC2 Instance.</title>
      <dc:creator>Nirmalya Mondal</dc:creator>
      <pubDate>Fri, 15 Mar 2024 22:28:35 +0000</pubDate>
      <link>https://dev.to/nirmalyax/the-definitive-guide-to-installing-jenkins-on-an-ec2-instance-1dbh</link>
      <guid>https://dev.to/nirmalyax/the-definitive-guide-to-installing-jenkins-on-an-ec2-instance-1dbh</guid>
      <description>&lt;p&gt;&lt;strong&gt;Jenkins&lt;/strong&gt; is a powerful open-source automation server that facilitates continuous integration and continuous delivery (CI/CD). Installing Jenkins on an EC2 instance is a common choice for those seeking flexibility and scalability. This guide provides a step-by-step process that ensures a reliable installation, suitable for various scenarios.&lt;/p&gt;

&lt;h2&gt;
  
  
  Prerequisites
&lt;/h2&gt;

&lt;p&gt;Before diving into the installation, ensure that you have the following:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;An AWS account with appropriate permissions to create and manage EC2 instances.&lt;/li&gt;
&lt;li&gt;Basic knowledge of AWS services and EC2 concepts.&lt;/li&gt;
&lt;li&gt;An EC2 instance running a compatible Linux distribution (Ubuntu is recommended).&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Step 1: Launch an EC2 Instance
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;&lt;strong&gt;Log in to AWS Console:&lt;/strong&gt;&lt;/li&gt;
&lt;/ol&gt;

&lt;ul&gt;
&lt;li&gt;Access the AWS Management Console and navigate to the EC2 dashboard.&lt;/li&gt;
&lt;/ul&gt;

&lt;ol&gt;
&lt;li&gt;&lt;strong&gt;Launch EC2 Instance:&lt;/strong&gt;&lt;/li&gt;
&lt;/ol&gt;

&lt;ul&gt;
&lt;li&gt;Click on "Launch Instance" and choose an Amazon Linux 2 AMI or your preferred Linux distribution.&lt;/li&gt;
&lt;/ul&gt;

&lt;ol&gt;
&lt;li&gt;&lt;strong&gt;Configure Instance:&lt;/strong&gt;&lt;/li&gt;
&lt;/ol&gt;

&lt;ul&gt;
&lt;li&gt;Select an instance type based on your requirements.&lt;/li&gt;
&lt;li&gt;Configure instance details, add storage, and configure security groups.&lt;/li&gt;
&lt;li&gt;Ensure that port 8080 is open in the security group to allow Jenkins access.&lt;/li&gt;
&lt;/ul&gt;

&lt;ol&gt;
&lt;li&gt;&lt;strong&gt;Review and Launch:&lt;/strong&gt;&lt;/li&gt;
&lt;/ol&gt;

&lt;ul&gt;
&lt;li&gt;Review your configuration and launch the instance.&lt;/li&gt;
&lt;li&gt;Choose an existing key pair or create a new one to access the instance securely.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Step 2: Connect to the EC2 Instance
&lt;/h2&gt;

&lt;p&gt;Use SSH to connect to your EC2 instance:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;ssh &lt;span class="nt"&gt;-i&lt;/span&gt; your-key-pair.pem ec2-user@your-ec2-instance-ip
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Step 3: Update the System and Install JAVA
&lt;/h2&gt;

&lt;p&gt;Update the package lists and install necessary dependencies:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;&lt;span class="nb"&gt;sudo &lt;/span&gt;apt update 
&lt;span class="nb"&gt;sudo &lt;/span&gt;apt-get &lt;span class="nb"&gt;install &lt;/span&gt;fontconfig openjdk-17-jre
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Step 4: Install Jenkins
&lt;/h2&gt;

&lt;p&gt;This is the Debian package repository of Jenkins to automate installation and upgrade. To use this repository, first add the key to your system (for the Weekly Release Line):&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;&lt;span class="nb"&gt;sudo &lt;/span&gt;wget &lt;span class="nt"&gt;-O&lt;/span&gt; /usr/share/keyrings/jenkins-keyring.asc &lt;span class="se"&gt;\&lt;/span&gt;
https://pkg.jenkins.io/debian-stable/jenkins.io-2023.key
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Step 5: Add Jenkins Repository
&lt;/h2&gt;

&lt;p&gt;Then add a Jenkins apt repository entry:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;&lt;span class="nb"&gt;echo &lt;/span&gt;deb &lt;span class="o"&gt;[&lt;/span&gt;signed-by&lt;span class="o"&gt;=&lt;/span&gt;/usr/share/keyrings/jenkins-keyring.asc] &lt;span class="se"&gt;\&lt;/span&gt;
    https://pkg.jenkins.io/debian-stable binary/ | &lt;span class="nb"&gt;sudo tee&lt;/span&gt; &lt;span class="se"&gt;\&lt;/span&gt;
    /etc/apt/sources.list.d/jenkins.list &lt;span class="o"&gt;&amp;gt;&lt;/span&gt; /dev/null
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Step 6: Update Package and Install Jenkins
&lt;/h2&gt;

&lt;p&gt;Update your local package index:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;&lt;span class="nb"&gt;sudo &lt;/span&gt;apt-get update
&lt;span class="nb"&gt;sudo &lt;/span&gt;apt-get &lt;span class="nb"&gt;install &lt;/span&gt;jenkins
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Step 7: Access Jenkins Web Interface
&lt;/h2&gt;

&lt;p&gt;Open your web browser and navigate to &lt;code&gt;http://your-ec2-instance-ip:8080&lt;/code&gt;. Retrieve the initial Jenkins admin password:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;&lt;span class="nb"&gt;sudo cat&lt;/span&gt; /var/lib/jenkins/secrets/initialAdminPassword
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Copy the password and paste it into the Jenkins web interface to unlock.&lt;/p&gt;

&lt;h2&gt;
  
  
  Step 8: Install Recommended Plugins
&lt;/h2&gt;

&lt;p&gt;Choose "Install suggested plugins" to install the default plugins or select specific plugins according to your needs.&lt;/p&gt;

&lt;h2&gt;
  
  
  Step 9: Create Admin User
&lt;/h2&gt;

&lt;p&gt;After the plugins are installed, create an admin user and set up Jenkins according to your preferences.&lt;/p&gt;

&lt;h2&gt;
  
  
  Step 10: Start Using Jenkins
&lt;/h2&gt;

&lt;p&gt;You now have Jenkins installed and configured on your EC2 instance. Explore Jenkins, create jobs, and automate your workflows!&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Note:&lt;/strong&gt; For enhanced security, consider configuring HTTPS using a reverse proxy like Nginx or Apache. Always refer to the Jenkins documentation for the latest and most accurate information.&lt;/p&gt;

&lt;p&gt;By following these steps, you've established a robust Jenkins installation on your EC2 instance, setting the foundation for efficient CI/CD pipelines.&lt;/p&gt;

</description>
      <category>jenkins</category>
      <category>cicd</category>
      <category>aws</category>
      <category>bash</category>
    </item>
    <item>
      <title>The Definitive Guide to Installing Jenkins on an EC2 Instance.</title>
      <dc:creator>Nirmalya Mondal</dc:creator>
      <pubDate>Sun, 18 Feb 2024 19:14:14 +0000</pubDate>
      <link>https://dev.to/nirmalyax/the-definitive-guide-to-installing-jenkins-on-an-ec2-instance-485d</link>
      <guid>https://dev.to/nirmalyax/the-definitive-guide-to-installing-jenkins-on-an-ec2-instance-485d</guid>
      <description>&lt;p&gt;&lt;strong&gt;Jenkins&lt;/strong&gt; is a powerful open-source automation server that facilitates continuous integration and continuous delivery (CI/CD). Installing Jenkins on an EC2 instance is a common choice for those seeking flexibility and scalability. This guide provides a step-by-step process that ensures a reliable installation, suitable for various scenarios.&lt;/p&gt;

&lt;h2&gt;
  
  
  Prerequisites
&lt;/h2&gt;

&lt;p&gt;Before diving into the installation, ensure that you have the following:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;An AWS account with appropriate permissions to create and manage EC2 instances.&lt;/li&gt;
&lt;li&gt;Basic knowledge of AWS services and EC2 concepts.&lt;/li&gt;
&lt;li&gt;An EC2 instance running a compatible Linux distribution (Ubuntu is recommended).&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Step 1: Launch an EC2 Instance
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;&lt;strong&gt;Log in to AWS Console:&lt;/strong&gt;&lt;/li&gt;
&lt;/ol&gt;

&lt;ul&gt;
&lt;li&gt;Access the AWS Management Console and navigate to the EC2 dashboard.&lt;/li&gt;
&lt;/ul&gt;

&lt;ol&gt;
&lt;li&gt;&lt;strong&gt;Launch EC2 Instance:&lt;/strong&gt;&lt;/li&gt;
&lt;/ol&gt;

&lt;ul&gt;
&lt;li&gt;Click on "Launch Instance" and choose an Amazon Linux 2 AMI or your preferred Linux distribution.&lt;/li&gt;
&lt;/ul&gt;

&lt;ol&gt;
&lt;li&gt;&lt;strong&gt;Configure Instance:&lt;/strong&gt;&lt;/li&gt;
&lt;/ol&gt;

&lt;ul&gt;
&lt;li&gt;Select an instance type based on your requirements.&lt;/li&gt;
&lt;li&gt;Configure instance details, add storage, and configure security groups.&lt;/li&gt;
&lt;li&gt;Ensure that port 8080 is open in the security group to allow Jenkins access.&lt;/li&gt;
&lt;/ul&gt;

&lt;ol&gt;
&lt;li&gt;&lt;strong&gt;Review and Launch:&lt;/strong&gt;&lt;/li&gt;
&lt;/ol&gt;

&lt;ul&gt;
&lt;li&gt;Review your configuration and launch the instance.&lt;/li&gt;
&lt;li&gt;Choose an existing key pair or create a new one to access the instance securely.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Step 2: Connect to the EC2 Instance
&lt;/h2&gt;

&lt;p&gt;Use SSH to connect to your EC2 instance:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;ssh &lt;span class="nt"&gt;-i&lt;/span&gt; your-key-pair.pem ec2-user@your-ec2-instance-ip
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Step 3: Update the System and Install JAVA
&lt;/h2&gt;

&lt;p&gt;Update the package lists and install necessary dependencies:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;&lt;span class="nb"&gt;sudo &lt;/span&gt;apt update 
&lt;span class="nb"&gt;sudo &lt;/span&gt;apt-get &lt;span class="nb"&gt;install &lt;/span&gt;fontconfig openjdk-17-jre
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Step 4: Install Jenkins
&lt;/h2&gt;

&lt;p&gt;This is the Debian package repository of Jenkins to automate installation and upgrade. To use this repository, first add the key to your system (for the Weekly Release Line):&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;&lt;span class="nb"&gt;sudo &lt;/span&gt;wget &lt;span class="nt"&gt;-O&lt;/span&gt; /usr/share/keyrings/jenkins-keyring.asc &lt;span class="se"&gt;\&lt;/span&gt;
https://pkg.jenkins.io/debian-stable/jenkins.io-2023.key
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Step 5: Add Jenkins Repository
&lt;/h2&gt;

&lt;p&gt;Then add a Jenkins apt repository entry:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;&lt;span class="nb"&gt;echo &lt;/span&gt;deb &lt;span class="o"&gt;[&lt;/span&gt;signed-by&lt;span class="o"&gt;=&lt;/span&gt;/usr/share/keyrings/jenkins-keyring.asc] &lt;span class="se"&gt;\&lt;/span&gt;
    https://pkg.jenkins.io/debian-stable binary/ | &lt;span class="nb"&gt;sudo tee&lt;/span&gt; &lt;span class="se"&gt;\&lt;/span&gt;
    /etc/apt/sources.list.d/jenkins.list &lt;span class="o"&gt;&amp;gt;&lt;/span&gt; /dev/null
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Step 6: Update Package and Install Jenkins
&lt;/h2&gt;

&lt;p&gt;Update your local package index:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;&lt;span class="nb"&gt;sudo &lt;/span&gt;apt-get update
&lt;span class="nb"&gt;sudo &lt;/span&gt;apt-get &lt;span class="nb"&gt;install &lt;/span&gt;jenkins
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Step 7: Access Jenkins Web Interface
&lt;/h2&gt;

&lt;p&gt;Open your web browser and navigate to &lt;code&gt;http://your-ec2-instance-ip:8080&lt;/code&gt;. Retrieve the initial Jenkins admin password:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;&lt;span class="nb"&gt;sudo cat&lt;/span&gt; /var/lib/jenkins/secrets/initialAdminPassword
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Copy the password and paste it into the Jenkins web interface to unlock.&lt;/p&gt;

&lt;h2&gt;
  
  
  Step 8: Install Recommended Plugins
&lt;/h2&gt;

&lt;p&gt;Choose "Install suggested plugins" to install the default plugins or select specific plugins according to your needs.&lt;/p&gt;

&lt;h2&gt;
  
  
  Step 9: Create Admin User
&lt;/h2&gt;

&lt;p&gt;After the plugins are installed, create an admin user and set up Jenkins according to your preferences.&lt;/p&gt;

&lt;h2&gt;
  
  
  Step 10: Start Using Jenkins
&lt;/h2&gt;

&lt;p&gt;You now have Jenkins installed and configured on your EC2 instance. Explore Jenkins, create jobs, and automate your workflows!&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Note:&lt;/strong&gt; For enhanced security, consider configuring HTTPS using a reverse proxy like Nginx or Apache. Always refer to the Jenkins documentation for the latest and most accurate information.&lt;/p&gt;

&lt;p&gt;By following these steps, you've established a robust Jenkins installation on your EC2 instance, setting the foundation for efficient CI/CD pipelines.&lt;/p&gt;

</description>
      <category>jenkins</category>
      <category>aws</category>
    </item>
    <item>
      <title>Folder Structure For E-commerce</title>
      <dc:creator>Nirmalya Mondal</dc:creator>
      <pubDate>Sat, 20 Jan 2024 11:16:51 +0000</pubDate>
      <link>https://dev.to/nirmalyax/folder-structure-for-e-commerce-k4f</link>
      <guid>https://dev.to/nirmalyax/folder-structure-for-e-commerce-k4f</guid>
      <description>&lt;h2&gt;
  
  
  &lt;strong&gt;Create a Folder&lt;/strong&gt;
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight jsx"&gt;&lt;code&gt;&lt;span class="o"&gt;**-&lt;/span&gt; &lt;span class="nx"&gt;src&lt;/span&gt;
  &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;components&lt;/span&gt;
  &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;context&lt;/span&gt;
  &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;pages&lt;/span&gt;
  &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;redux&lt;/span&gt;
  &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;firebase&lt;/span&gt;&lt;span class="o"&gt;**&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  &lt;strong&gt;Step 1 : Create a Navbar Folder&lt;/strong&gt;
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight jsx"&gt;&lt;code&gt;&lt;span class="o"&gt;**-&lt;/span&gt; &lt;span class="nx"&gt;components&lt;/span&gt;
  &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;navbar&lt;/span&gt;
    &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;Navbar&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nx"&gt;jsx&lt;/span&gt;&lt;span class="o"&gt;**&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  &lt;strong&gt;Step 2 : Create a Footer Folder&lt;/strong&gt;
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight jsx"&gt;&lt;code&gt;&lt;span class="o"&gt;**-&lt;/span&gt; &lt;span class="nx"&gt;components&lt;/span&gt;
  &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;footer&lt;/span&gt;
    &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;Footer&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nx"&gt;jsx&lt;/span&gt;&lt;span class="o"&gt;**&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  &lt;strong&gt;Step 3 : Create a Layout Folder&lt;/strong&gt;
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight jsx"&gt;&lt;code&gt;&lt;span class="o"&gt;**-&lt;/span&gt; &lt;span class="nx"&gt;components&lt;/span&gt;
  &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;layout&lt;/span&gt;
    &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;Layout&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nx"&gt;jsx&lt;/span&gt;&lt;span class="o"&gt;**&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;strong&gt;&lt;code&gt;Layout.jsx&lt;/code&gt;&lt;/strong&gt;&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight jsx"&gt;&lt;code&gt;&lt;span class="o"&gt;**&lt;/span&gt;&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="nx"&gt;React&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="s1"&gt;react&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;
&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="nx"&gt;Footer&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="s1"&gt;../footer/Footer&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;
&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="nx"&gt;Navbar&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="s1"&gt;../navbar/TopNvbar&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;

&lt;span class="kd"&gt;function&lt;/span&gt; &lt;span class="nf"&gt;Layout&lt;/span&gt;&lt;span class="p"&gt;({&lt;/span&gt; &lt;span class="nx"&gt;children&lt;/span&gt; &lt;span class="p"&gt;})&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="k"&gt;return &lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;
    &lt;span class="p"&gt;&amp;lt;&lt;/span&gt;&lt;span class="nt"&gt;div&lt;/span&gt;&lt;span class="p"&gt;&amp;gt;&lt;/span&gt;
      &lt;span class="p"&gt;&amp;lt;&lt;/span&gt;&lt;span class="nc"&gt;Navbar&lt;/span&gt; &lt;span class="p"&gt;/&amp;gt;&lt;/span&gt;
      &lt;span class="p"&gt;&amp;lt;&lt;/span&gt;&lt;span class="nt"&gt;div&lt;/span&gt; &lt;span class="na"&gt;className&lt;/span&gt;&lt;span class="p"&gt;=&lt;/span&gt;&lt;span class="s"&gt;"content"&lt;/span&gt;&lt;span class="p"&gt;&amp;gt;&lt;/span&gt;
        &lt;span class="si"&gt;{&lt;/span&gt;&lt;span class="nx"&gt;children&lt;/span&gt;&lt;span class="si"&gt;}&lt;/span&gt;
      &lt;span class="p"&gt;&amp;lt;/&lt;/span&gt;&lt;span class="nt"&gt;div&lt;/span&gt;&lt;span class="p"&gt;&amp;gt;&lt;/span&gt;
      &lt;span class="p"&gt;&amp;lt;&lt;/span&gt;&lt;span class="nc"&gt;Footer&lt;/span&gt; &lt;span class="p"&gt;/&amp;gt;&lt;/span&gt;
    &lt;span class="p"&gt;&amp;lt;/&lt;/span&gt;&lt;span class="nt"&gt;div&lt;/span&gt;&lt;span class="p"&gt;&amp;gt;&lt;/span&gt;
  &lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;

&lt;span class="k"&gt;export&lt;/span&gt; &lt;span class="k"&gt;default&lt;/span&gt; &lt;span class="nx"&gt;Layout&lt;/span&gt;&lt;span class="o"&gt;**&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  &lt;strong&gt;Step 4 : Create a Page&lt;/strong&gt;
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight jsx"&gt;&lt;code&gt;&lt;span class="o"&gt;**-&lt;/span&gt; &lt;span class="nx"&gt;pages&lt;/span&gt;
  &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;home&lt;/span&gt;
    &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;Home&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nx"&gt;jsx&lt;/span&gt;
  &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;allproducts&lt;/span&gt;
    &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;AllProducts&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nx"&gt;jsx&lt;/span&gt;
  &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;Order&lt;/span&gt;
    &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;Order&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nx"&gt;jsx&lt;/span&gt;
  &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;cart&lt;/span&gt;
    &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;Cart&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nx"&gt;jsx&lt;/span&gt;
  &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;admin&lt;/span&gt;
    &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;dashboard&lt;/span&gt;
      &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;Dashboard&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nx"&gt;jsx&lt;/span&gt;
  &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;nopage&lt;/span&gt;
    &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nx"&gt;NoPage&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nx"&gt;jsx&lt;/span&gt;&lt;span class="o"&gt;**&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;code&gt;**Home.jsx**&lt;/code&gt;&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight jsx"&gt;&lt;code&gt;&lt;span class="o"&gt;**&lt;/span&gt;&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="nx"&gt;React&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="s1"&gt;react&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;

&lt;span class="kd"&gt;function&lt;/span&gt; &lt;span class="nf"&gt;Home&lt;/span&gt;&lt;span class="p"&gt;()&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="k"&gt;return &lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;
    &lt;span class="p"&gt;&amp;lt;&lt;/span&gt;&lt;span class="nt"&gt;div&lt;/span&gt;&lt;span class="p"&gt;&amp;gt;&lt;/span&gt;Home&lt;span class="p"&gt;&amp;lt;/&lt;/span&gt;&lt;span class="nt"&gt;div&lt;/span&gt;&lt;span class="p"&gt;&amp;gt;&lt;/span&gt;
  &lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;

&lt;span class="k"&gt;export&lt;/span&gt; &lt;span class="k"&gt;default&lt;/span&gt; &lt;span class="nx"&gt;Home&lt;/span&gt;&lt;span class="o"&gt;**&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  &lt;strong&gt;Step 5 : Import Layout in Home.jsx&lt;/strong&gt;
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight jsx"&gt;&lt;code&gt;&lt;span class="o"&gt;**&lt;/span&gt;&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="nx"&gt;React&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="s1"&gt;react&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;
&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="nx"&gt;Layout&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="s1"&gt;../../components/layout/Layout&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;

&lt;span class="kd"&gt;function&lt;/span&gt; &lt;span class="nf"&gt;Home&lt;/span&gt;&lt;span class="p"&gt;()&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="k"&gt;return &lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;
    &lt;span class="p"&gt;&amp;lt;&lt;/span&gt;&lt;span class="nc"&gt;Layout&lt;/span&gt;&lt;span class="p"&gt;&amp;gt;&lt;/span&gt;Home&lt;span class="p"&gt;&amp;lt;/&lt;/span&gt;&lt;span class="nc"&gt;Layout&lt;/span&gt;&lt;span class="p"&gt;&amp;gt;&lt;/span&gt;
  &lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;

&lt;span class="k"&gt;export&lt;/span&gt; &lt;span class="k"&gt;default&lt;/span&gt; &lt;span class="nx"&gt;Home&lt;/span&gt;&lt;span class="o"&gt;**&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  &lt;strong&gt;Step 6 : Create a route of all page&lt;/strong&gt;
&lt;/h2&gt;

&lt;h3&gt;
  
  
  Install React router dom for routing
&lt;/h3&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight jsx"&gt;&lt;code&gt;&lt;span class="o"&gt;**&lt;/span&gt;&lt;span class="nx"&gt;npm&lt;/span&gt; &lt;span class="nx"&gt;i&lt;/span&gt; &lt;span class="nx"&gt;react&lt;/span&gt;&lt;span class="o"&gt;-&lt;/span&gt;&lt;span class="nx"&gt;router&lt;/span&gt;&lt;span class="o"&gt;-&lt;/span&gt;&lt;span class="nx"&gt;dom&lt;/span&gt;&lt;span class="o"&gt;**&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h3&gt;
  
  
  &lt;strong&gt;Define routes in App.jsx&lt;/strong&gt;
&lt;/h3&gt;

&lt;p&gt;&lt;strong&gt;Import &lt;code&gt;BrowserRouter as Router&lt;/code&gt;, &lt;code&gt;Route&lt;/code&gt;, &lt;code&gt;Routes&lt;/code&gt;, from react-router-dom&lt;/strong&gt;&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight jsx"&gt;&lt;code&gt;&lt;span class="o"&gt;**&lt;/span&gt;&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="nx"&gt;BrowserRouter&lt;/span&gt; &lt;span class="k"&gt;as&lt;/span&gt; &lt;span class="nx"&gt;Router&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nx"&gt;Route&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nx"&gt;Routes&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;react-router-dom&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;&lt;span class="o"&gt;**&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Complete Code
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight jsx"&gt;&lt;code&gt;&lt;span class="o"&gt;**&lt;/span&gt;&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="nx"&gt;React&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="s1"&gt;react&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;
&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="nx"&gt;BrowserRouter&lt;/span&gt; &lt;span class="k"&gt;as&lt;/span&gt; &lt;span class="nx"&gt;Router&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nx"&gt;Route&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nx"&gt;Routes&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;react-router-dom&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;

&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="nx"&gt;Home&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="s1"&gt;./pages/home/Home&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="nx"&gt;Order&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="s1"&gt;./pages/order/Order&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="nx"&gt;Cart&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="s1"&gt;./pages/cart/Cart&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="nx"&gt;Dashboard&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="s1"&gt;./pages/admin/dashboard/Dashboard&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="nx"&gt;NoPage&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="s1"&gt;./pages/nopage/NoPage&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;

&lt;span class="kd"&gt;function&lt;/span&gt; &lt;span class="nf"&gt;App&lt;/span&gt;&lt;span class="p"&gt;()&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="k"&gt;return &lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;
    &lt;span class="p"&gt;&amp;lt;&lt;/span&gt;&lt;span class="nc"&gt;Router&lt;/span&gt;&lt;span class="p"&gt;&amp;gt;&lt;/span&gt;
      &lt;span class="p"&gt;&amp;lt;&lt;/span&gt;&lt;span class="nc"&gt;Routes&lt;/span&gt;&lt;span class="p"&gt;&amp;gt;&lt;/span&gt;
        &lt;span class="p"&gt;&amp;lt;&lt;/span&gt;&lt;span class="nc"&gt;Route&lt;/span&gt; &lt;span class="na"&gt;path&lt;/span&gt;&lt;span class="p"&gt;=&lt;/span&gt;&lt;span class="s"&gt;"/"&lt;/span&gt; &lt;span class="na"&gt;element&lt;/span&gt;&lt;span class="p"&gt;=&lt;/span&gt;&lt;span class="si"&gt;{&lt;/span&gt;&lt;span class="p"&gt;&amp;lt;&lt;/span&gt;&lt;span class="nc"&gt;Home&lt;/span&gt;&lt;span class="p"&gt;/&amp;gt;&lt;/span&gt;&lt;span class="si"&gt;}&lt;/span&gt; &lt;span class="p"&gt;/&amp;gt;&lt;/span&gt;
        &lt;span class="p"&gt;&amp;lt;&lt;/span&gt;&lt;span class="nc"&gt;Route&lt;/span&gt; &lt;span class="na"&gt;path&lt;/span&gt;&lt;span class="p"&gt;=&lt;/span&gt;&lt;span class="s"&gt;"/order"&lt;/span&gt; &lt;span class="na"&gt;element&lt;/span&gt;&lt;span class="p"&gt;=&lt;/span&gt;&lt;span class="si"&gt;{&lt;/span&gt;&lt;span class="p"&gt;&amp;lt;&lt;/span&gt;&lt;span class="nc"&gt;Order&lt;/span&gt;&lt;span class="p"&gt;/&amp;gt;&lt;/span&gt;&lt;span class="si"&gt;}&lt;/span&gt; &lt;span class="p"&gt;/&amp;gt;&lt;/span&gt;
        &lt;span class="p"&gt;&amp;lt;&lt;/span&gt;&lt;span class="nc"&gt;Route&lt;/span&gt; &lt;span class="na"&gt;path&lt;/span&gt;&lt;span class="p"&gt;=&lt;/span&gt;&lt;span class="s"&gt;"/cart"&lt;/span&gt; &lt;span class="na"&gt;element&lt;/span&gt;&lt;span class="p"&gt;=&lt;/span&gt;&lt;span class="si"&gt;{&lt;/span&gt;&lt;span class="p"&gt;&amp;lt;&lt;/span&gt;&lt;span class="nc"&gt;Cart&lt;/span&gt;&lt;span class="p"&gt;/&amp;gt;&lt;/span&gt;&lt;span class="si"&gt;}&lt;/span&gt; &lt;span class="p"&gt;/&amp;gt;&lt;/span&gt;
        &lt;span class="p"&gt;&amp;lt;&lt;/span&gt;&lt;span class="nc"&gt;Route&lt;/span&gt; &lt;span class="na"&gt;path&lt;/span&gt;&lt;span class="p"&gt;=&lt;/span&gt;&lt;span class="s"&gt;"/dashboard"&lt;/span&gt; &lt;span class="na"&gt;element&lt;/span&gt;&lt;span class="p"&gt;=&lt;/span&gt;&lt;span class="si"&gt;{&lt;/span&gt;&lt;span class="p"&gt;&amp;lt;&lt;/span&gt;&lt;span class="nc"&gt;Dashboard&lt;/span&gt;&lt;span class="p"&gt;/&amp;gt;&lt;/span&gt;&lt;span class="si"&gt;}&lt;/span&gt; &lt;span class="p"&gt;/&amp;gt;&lt;/span&gt;
        &lt;span class="p"&gt;&amp;lt;&lt;/span&gt;&lt;span class="nc"&gt;Route&lt;/span&gt; &lt;span class="na"&gt;path&lt;/span&gt;&lt;span class="p"&gt;=&lt;/span&gt;&lt;span class="s"&gt;"/*"&lt;/span&gt; &lt;span class="na"&gt;element&lt;/span&gt;&lt;span class="p"&gt;=&lt;/span&gt;&lt;span class="si"&gt;{&lt;/span&gt;&lt;span class="p"&gt;&amp;lt;&lt;/span&gt;&lt;span class="nc"&gt;NoPage&lt;/span&gt;&lt;span class="p"&gt;/&amp;gt;&lt;/span&gt;&lt;span class="si"&gt;}&lt;/span&gt; &lt;span class="p"&gt;/&amp;gt;&lt;/span&gt;
      &lt;span class="p"&gt;&amp;lt;/&lt;/span&gt;&lt;span class="nc"&gt;Routes&lt;/span&gt;&lt;span class="p"&gt;&amp;gt;&lt;/span&gt;
    &lt;span class="p"&gt;&amp;lt;/&lt;/span&gt;&lt;span class="nc"&gt;Router&lt;/span&gt;&lt;span class="p"&gt;&amp;gt;&lt;/span&gt;
  &lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;

&lt;span class="k"&gt;export&lt;/span&gt; &lt;span class="k"&gt;default&lt;/span&gt; &lt;span class="nx"&gt;App&lt;/span&gt;&lt;span class="o"&gt;**&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



</description>
    </item>
  </channel>
</rss>
