🎓 Lecture 1 — String Patterns, Ranges, and Sets

🎯 Learning Objectives

By the end of this lesson, you will be able to:

• Describe how to simplify SELECT statements using string patterns, ranges, and sets.
• Use wildcard characters with the LIKE predicate.
• Apply BETWEEN for range-based filtering.
• Use IN to handle multiple values efficiently.

🧩 1. Introduction

The main purpose of a Database Management System (DBMS) is not just to store data, but also to retrieve it efficiently.

In its simplest form, a query like:

SELECT * FROM Book;

returns all rows and columns from the table.

However, to make queries more specific and efficient, we can apply conditions in the WHERE clause using:

• String patterns (LIKE)
• Ranges (BETWEEN)
• Sets of values (IN)

🔤 2. String Patterns (Using LIKE)