Posts

📘 SQL Blog Series – 5

  Today, we’re going to understand how to use aggregrate fucntions in Sql. An aggregate function is a function that performs a calculation on a set of values, and returns a single value. Aggregate functions are often used with the  GROUP BY  clause of the  SELECT  statement. The  GROUP BY  clause splits the result-set into groups of values and the aggregate function can be used to return a single value for each group. The most commonly used SQL aggregate functions are: MIN()  - returns the smallest value within the selected column MAX()  - returns the largest value within the selected column COUNT()  - returns the number of rows in a set SUM()  - returns the total sum of a numerical column AVG()  - returns the average value of a numerical column Aggregate functions ignore null values (except for  COUNT(*) ). We will go through the aggregate functions above in the next chapters. The SQL MIN() and MAX() Functions The  M...
Post a Comment
Read more

📘 SQL Blog Series – 4

Today, we’re going to understand how to fetch data based on specific requirements using different SQL clauses and filters. These filters help us control what kind of data we want to see from a table instead of showing everything. 🔹 WHERE Clause The WHERE clause is used to filter rows based on a specific condition. It tells the database to return only the records that satisfy that condition. Without the WHERE clause, SQL will show all the data from the table. 🔹 Equal to (=) The equal-to operator is used to match values exactly. It returns the records where the column value is the same as the value we specify. 🔹 Greater than (>) and Less than (<) These operators are used to compare values numerically. The greater-than sign is used to find records with values higher than the given number. The less-than sign is used to find records with values lower than the given number. 🔹 IN Clause The IN clause is used when we want to match a column with multiple values. I...
Post a Comment
Read more

📘 SQL Blog Series – 3

On this blog I’ve uploaded all the practical implementations from our previous posts. I used HeidiSQL as the interface to run and visualize queries — don’t be surprised: everything runs on MySQL; HeidiSQL simply connects to MySQL and makes it easier to view results. If you want to try it yourself, download HeidiSQL from your browser and connect using your MySQL credentials (root or another user). Enjoy the video and practice along — you learn by doing, not just by watching.
Post a Comment
Read more

📘 SQL Blog Series - Day-2

Image
  In the previous blog, we explored what SQL is and why it’s such an essential part of every application. We also understood how SQL connects with different programming languages and frameworks to manage data effectively. Today, let’s dive a bit deeper and begin our actual SQL journey. We’ll start by learning about databases , tables , and some basic SQL commands that form the foundation of everything we do in SQL. 🏗️ What is a Database? A database is like the main storage base that holds all our data in an organized way. Think of it as a big container where all your information is stored safely. Inside a database, data isn’t just scattered around — it’s neatly arranged in the form of tables . Each database can have multiple tables, and each table stores data related to a specific topic or entity — like customers, employees, products, or orders. 🧩 SQL Data Types When we create tables in SQL, every column needs to store a specific kind of data — numbers, text, dates, or even ...
Post a Comment
Read more

📘 SQL Blog Series - Day-1

Image
 🧠 What is a Database? How many of you have come across the word database ? I’m sure almost everyone has heard it at least once! But what exactly is a database? Let’s understand it with a simple example. Think about the lunch boxes we carry to school or college every day — they store our food safely until we need it. In the same way, a database is like a storage box for data. It safely stores and organizes all the information a system needs, so that it can be used whenever required. A database is nothing but a place to store things — just like our brain. Think about it: we remember moments from our childhood and sometimes smile when we recall them. That’s because our brain stores those memories. Similarly, a database acts as the memory of a computer system , storing data so it can be recalled and used whenever needed. 🗂️ Types of Databases Just like everything else in the tech world, databases also come in different types. The two main ones are SQL and NoSQL databases. Now...
Post a Comment
Read more

📘 SQL Blog Series – 10 Days Roadmap

Image
 Welcome to the SQL Blog Series! Over the next 10 days, we’ll explore SQL step by step, from the basics to advanced concepts. Below is the complete syllabus of what we’ll be covering.
Post a Comment
Read more

Day 30: Beyond Python – Frameworks & Career Paths to Explore Next

Image
  Python has been our trusted companion for the past 29 days. We’ve walked through the basics, dived into advanced concepts, and explored the depth of this versatile language. But here’s the exciting truth: learning Python is just the beginning . The real magic starts when you see how Python powers some of the most impactful technologies in the world. Today, let’s step beyond core Python and look at the frameworks, libraries, and career paths you can explore next.
Post a Comment
Read more