<?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: Y S KAUSHIK REDDY</title>
    <description>The latest articles on DEV Community by Y S KAUSHIK REDDY (@kaushikebookstore).</description>
    <link>https://dev.to/kaushikebookstore</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.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4253509%2Fa90a7303-5246-490f-afbf-0bb6fb4e3a46.jpg</url>
      <title>DEV Community: Y S KAUSHIK REDDY</title>
      <link>https://dev.to/kaushikebookstore</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/kaushikebookstore"/>
    <language>en</language>
    <item>
      <title>Learn SQL From Scratch: 7 Essential SQL Queries Every Beginner Should Know</title>
      <dc:creator>Y S KAUSHIK REDDY</dc:creator>
      <pubDate>Thu, 19 Nov 2026 09:43:10 +0000</pubDate>
      <link>https://dev.to/kaushikebookstore/learn-sql-from-scratch-7-essential-sql-queries-every-beginner-should-know-53ci</link>
      <guid>https://dev.to/kaushikebookstore/learn-sql-from-scratch-7-essential-sql-queries-every-beginner-should-know-53ci</guid>
      <description>&lt;h1&gt;
  
  
  Learn SQL From Scratch: 7 Essential SQL Queries Every Beginner Should Know
&lt;/h1&gt;

&lt;p&gt;SQL (Structured Query Language) is an important skill for students, software developers, data analysts, and freshers preparing for technical interviews.&lt;/p&gt;

&lt;p&gt;If you are new to SQL, here are seven useful SQL queries explained with simple examples.&lt;/p&gt;

&lt;p&gt;For these examples, imagine we have a &lt;code&gt;students&lt;/code&gt; table containing &lt;code&gt;id&lt;/code&gt;, &lt;code&gt;name&lt;/code&gt;, &lt;code&gt;marks&lt;/code&gt;, &lt;code&gt;department&lt;/code&gt;, and &lt;code&gt;department_id&lt;/code&gt; columns.&lt;/p&gt;

&lt;h2&gt;
  
  
  1. SELECT — Display Data
&lt;/h2&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;students&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;This displays all records and columns from the students table.&lt;/p&gt;

&lt;h2&gt;
  
  
  2. WHERE — Filter Records
&lt;/h2&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;students&lt;/span&gt;
&lt;span class="k"&gt;WHERE&lt;/span&gt; &lt;span class="n"&gt;marks&lt;/span&gt; &lt;span class="o"&gt;&amp;gt;&lt;/span&gt; &lt;span class="mi"&gt;80&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;This displays students who scored more than 80 marks.&lt;/p&gt;

&lt;h2&gt;
  
  
  3. ORDER BY — Sort Data
&lt;/h2&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;students&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;marks&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;p&gt;This sorts students from highest to lowest marks.&lt;/p&gt;

&lt;h2&gt;
  
  
  4. COUNT — Count Records
&lt;/h2&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="nb"&gt;COUNT&lt;/span&gt;&lt;span class="cm"&gt;(*) FROM students;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;This returns the total number of student records.&lt;/p&gt;

&lt;h2&gt;
  
  
  5. GROUP BY — Group Records
&lt;/h2&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;department&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nb"&gt;COUNT&lt;/span&gt;&lt;span class="cm"&gt;(*)
FROM students
GROUP BY department;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;This counts how many students belong to each department.&lt;/p&gt;

&lt;h2&gt;
  
  
  6. INNER JOIN — Combine Tables
&lt;/h2&gt;

&lt;p&gt;Imagine another table named &lt;code&gt;departments&lt;/code&gt;, containing &lt;code&gt;id&lt;/code&gt; and &lt;code&gt;department_name&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="n"&gt;students&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;departments&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;department_name&lt;/span&gt;
&lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;students&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;departments&lt;/span&gt;
&lt;span class="k"&gt;ON&lt;/span&gt; &lt;span class="n"&gt;students&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;department_id&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;departments&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;id&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;This combines matching records from the two tables.&lt;/p&gt;

&lt;h2&gt;
  
  
  7. UPDATE — Modify Records
&lt;/h2&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;students&lt;/span&gt;
&lt;span class="k"&gt;SET&lt;/span&gt; &lt;span class="n"&gt;marks&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="mi"&gt;90&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="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;This changes the marks of the student whose ID is 1.&lt;/p&gt;

&lt;p&gt;Be careful when using UPDATE. Without a WHERE condition, you could update every row in the table.&lt;/p&gt;

&lt;h2&gt;
  
  
  How to Learn SQL in 30 Days
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;Week 1:&lt;/strong&gt; Databases, SELECT, WHERE and ORDER BY.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Week 2:&lt;/strong&gt; SQL functions, GROUP BY and HAVING.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Week 3:&lt;/strong&gt; JOINs, subqueries and database relationships.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Week 4:&lt;/strong&gt; SQL exercises, interview questions and a mini project.&lt;/p&gt;

&lt;h2&gt;
  
  
  Free SQL Learning Resources
&lt;/h2&gt;

&lt;p&gt;You can practice using:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;W3Schools SQL Tutorial&lt;/li&gt;
&lt;li&gt;SQLBolt&lt;/li&gt;
&lt;li&gt;HackerRank SQL Practice&lt;/li&gt;
&lt;/ul&gt;

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

&lt;p&gt;The best way to learn SQL is to practice writing queries regularly. Start with simple examples and gradually build your confidence.&lt;/p&gt;

&lt;p&gt;If you prefer a structured workbook, I've also created &lt;strong&gt;SQL Mastery in 30 Days: From Zero to Database Confidence&lt;/strong&gt;, a paid PDF eBook covering SQL lessons, exercises and interview preparation.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Price:&lt;/strong&gt; ₹149&lt;/p&gt;

&lt;p&gt;&lt;a href="https://studigoo.com/product/sql-mastery-in-30-days-from-zero-to-database-confidence/" rel="noopener noreferrer"&gt;Explore my SQL workbook&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;em&gt;Disclosure: This is my own paid digital eBook.&lt;/em&gt;&lt;/p&gt;

</description>
      <category>sql</category>
      <category>beginners</category>
      <category>database</category>
      <category>tutorial</category>
    </item>
  </channel>
</rss>
