SQL Basics: Querying a Database

SQL Basics: Querying a Database

What Is SQL?

SQL (Structured Query Language) is a language for talking to databases. Databases store massive amounts of data in organized tables. SQL lets you retrieve, filter, and analyze this data. Every company uses SQL to manage customer information, inventory, and finances.

Basic SQL Commands

SELECT retrieves data from tables. WHERE filters results by conditions. FROM specifies which table to query. ORDER BY sorts results. LIMIT restricts how many rows return.

SELECT name, email FROM users
WHERE age > 18
ORDER BY name
LIMIT 10;

Filtering and Combining Data

Use AND/OR to combine multiple conditions. LIKE searches for text patterns. COUNT aggregates data into summaries. GROUP BY organizes results by category.

SELECT country, COUNT(*) as total
FROM customers
GROUP BY country
ORDER BY total DESC;

Key Takeaways

• SQL retrieves and filters database data
• WHERE filters results by conditions
• GROUP BY and COUNT summarize data

Thinking Like a Computer Scientist

Before we dive into SQL Basics: Querying a Database, let me tell you something important. The most valuable skill in computer science is not memorising facts or typing fast. It is a way of THINKING. Computer scientists look at big, messy, confusing problems and break them down into small, simple steps. They find patterns. They test ideas. They are not afraid of making mistakes because every mistake teaches them something.

Right now, India has the second-largest number of internet users in the world — over 900 million people! And the companies building the apps and services these people use need millions more computer scientists. Many of them will be people your age, learning these concepts right now. This chapter on sql basics: querying a database is one more step on that journey.

Writing Your First SQL Query

SQL (Structured Query Language) is how we talk to databases. It is like asking questions in a special language that databases understand. Here are some examples:

-- Create a table (like creating a new spreadsheet)
CREATE TABLE students (
    roll_number INTEGER PRIMARY KEY,
    name        TEXT NOT NULL,
    class       INTEGER,
    city        TEXT,
    marks       REAL
);

-- Add some students
INSERT INTO students VALUES (1, 'Aarav Patel', 8, 'Ahmedabad', 92.5);
INSERT INTO students VALUES (2, 'Diya Sharma', 8, 'Delhi', 88.0);
INSERT INTO students VALUES (3, 'Krishna Iyer', 8, 'Chennai', 95.0);

-- Ask questions (queries)
SELECT name, marks FROM students WHERE marks > 90;
-- Result: Aarav Patel (92.5), Krishna Iyer (95.0)

SELECT city, AVG(marks) as avg_marks
FROM students GROUP BY city ORDER BY avg_marks DESC;
-- Shows average marks per city, highest first

SQL reads almost like English: "SELECT the name and marks FROM students WHERE marks are greater than 90." This is why SQL has remained the most important database language for over 50 years! India's Aadhaar system, the world's largest biometric database with 1.4 billion entries, uses SQL databases at its core.

The UPI Revolution as a CS Case Study

Before UPI, sending money meant NEFT forms, IFSC codes, 24-hour waits, and fees. UPI abstracted all that complexity behind a simple VPA (Virtual Payment Address like name@upi). This is the power of abstraction — hiding complex implementation behind a simple interface. Under the hood, UPI uses encryption (security), API calls (networking), database transactions (data management), and load balancing (distributed systems). Every CS concept you learn shows up somewhere in UPI's architecture.

Searching and Sorting: Fundamental Algorithms

Two of the most important problems in computer science are searching (finding something) and sorting (putting things in order). Let us explore both:

  LINEAR SEARCH — Check each item one by one
  ────────────────────────────────────────────
  Find 7 in: [3, 8, 1, 7, 4, 9, 2]

  Check 3? No. Check 8? No. Check 1? No. Check 7? YES! Found at position 4.
  Worst case: Check ALL items → N comparisons

  BINARY SEARCH — Only works on SORTED lists (but much faster!)
  ────────────────────────────────────────────
  Find 7 in: [1, 2, 3, 4, 7, 8, 9]  (sorted!)

  Middle is 4. Is 7 > 4? Yes → search right half [7, 8, 9]
  Middle is 8. Is 7 < 8? Yes → search left half [7]
  Found 7! Only 3 checks instead of 7!

  BUBBLE SORT — Compare neighbors, swap if wrong order
  ────────────────────────────────────────────
  [5, 3, 8, 1] → Compare 5,3 → Swap! → [3, 5, 8, 1]
                → Compare 5,8 → OK     → [3, 5, 8, 1]
                → Compare 8,1 → Swap!  → [3, 5, 1, 8]
  ... repeat until no swaps needed
  Final: [1, 3, 5, 8] ✓

Binary search is amazingly fast. In a phone book with 1 million names, linear search might check all million entries. Binary search finds ANY name in at most 20 checks! (because 2²⁰ = 1,048,576). This is why algorithms matter — choosing the right one can be the difference between 1 million operations and 20 operations. Google searches through billions of web pages and returns results in under a second because of brilliant algorithms!

Inside the Tech Industry

Let me give you a glimpse of how sql basics: querying a database is applied in production systems at India's top tech companies. At Flipkart, during Big Billion Days, the system handles over 15,000 orders per SECOND. Every one of those orders involves inventory checks, payment processing, fraud detection, warehouse assignment, and delivery scheduling — all happening simultaneously in under 2 seconds. The engineering behind this is extraordinary.

At Razorpay, which processes payments for hundreds of thousands of businesses, the system must handle concurrent transactions while ensuring exactly-once processing (you cannot charge someone's card twice!). This requires distributed consensus algorithms, idempotency keys, and sophisticated error handling. When you see "Payment Successful" on your screen, dozens of systems have communicated, verified, and recorded the transaction in milliseconds.

Zomato's recommendation engine analyses your past orders, location, time of day, weather, and even what people similar to you are ordering to suggest restaurants. This involves machine learning models trained on billions of data points, real-time inference systems, and A/B testing frameworks that compare different recommendation strategies. The "For You" section on your Zomato app is the result of some seriously sophisticated computer science.

Even India's public infrastructure uses these concepts. IRCTC's Tatkal booking system handles millions of simultaneous users at 10 AM, requiring load balancing, queue management, and optimistic locking to prevent overbooking. The Delhi Metro's automated signalling system uses real-time algorithms to maintain safe distances between trains. Traffic management systems in cities like Bangalore and Pune use computer vision to analyse traffic density and optimise signal timings.

Key Vocabulary

Here are important terms from this chapter that you should know:

🔬 Experiment: Measure Algorithm Speed

Here is a practical experiment: write two Python programs — one that uses a list and one that uses a dictionary — to check if a word exists in a collection of 10,000 words. Time both programs. You will discover that the dictionary version is dramatically faster (O(1) vs O(n)). Now try it with 100,000 words, then 1,000,000. Watch how the difference grows exponentially. This single experiment will teach you more about data structures than reading a textbook chapter.

Connecting the Dots

SQL Basics: Querying a Database does not exist in isolation — it connects to everything else in computer science. The concepts you learned here will show up again and again: in web development, in AI, in app building, in cybersecurity. Computer science is like a giant jigsaw puzzle, and each chapter you complete adds another piece. Some day, you will step back and see the complete picture — and it will be beautiful.

India is producing the next generation of global tech leaders. Students from IITs, NITs, IIIT Hyderabad, and BITS Pilani are founding companies, leading engineering teams at Google and Microsoft, and solving problems that affect billions of people. Your journey through these chapters is the same journey they started on. Keep building, keep experimenting, and most importantly, keep enjoying the process.

Crafted for Class 4–6 • Data Science • Aligned with NEP 2020 & CBSE Curriculum