Lesson 1: What is a Database?

Welcome to the first lesson of your SQL journey.

Introduction

When I first started learning coding at ThinkByByte, I was confused about where data actually lives. To handle this data efficiently, we use a DBMS (Database Management System).

In this lesson, we will understand what DBMS is, why it is needed, and how it works.

What is DBMS?

DBMS (Database Management System) is a software system that allows users to store, manage, retrieve, and modify data efficiently in a structured format.

A Real-Life Example

Imagine an organization 🏢:

  • Employee Details = Data
  • Register or Computer System = DBMS
  • Employer or Management = User

The DBMS helps management to:

  • Add new employees
  • Update employee data
  • Check employee data
  • Remove resigned/old employees' data

Why Do We Need DBMS?

In earlier days, data was stored using file systems like text files or Excel documents. This created many problems.

Problems with File Systems:

  • ❌ Duplicate Data: The same information is stored in multiple places.
  • ❌ Less Secure: Anyone with access to the file can see it.
  • ❌ Difficult Access: Searching for specific data takes a long time.
  • ❌ Inconsistent Data: Updates in one file might not reflect in another.
  • ❌ No Backup: If the file is deleted, it is gone forever.

How DBMS Helps:

  • ✅ Structured Format: Data is organized logically.
  • ✅ High Security: Only authorized users can access data.
  • ✅ Reduced Duplication: Data is stored centrally.
  • ✅ Fast Retrieval: We can find any record instantly using queries.
  • ✅ Backup & Recovery: Your data is safe even if the system crashes.

What is RDBMS?

RDBMS stands for Relational Database Management System.

An RDBMS is a type of DBMS where data is stored in the form of Tables (Rows and Columns). These tables maintain relationships between them.

Difference Between DBMS and RDBMS

DBMS RDBMS
Stores data in files or hierarchical formats Stores data only in Tables (Rows & Columns)
Relationships are not mandatory Relationships are mandatory (Primary/Foreign Keys)
Less strict structure Follows strict structure (Schema)
Example: XML, Hierarchical DB Example: MySQL, Oracle, SQL Server

Examples of RDBMS Software

Here are a few of the most commonly used RDBMS software:

  • Oracle (Widely used in large enterprises)
  • MySQL (Popular for web applications)
  • Microsoft SQL Server
  • PostgreSQL
  • SQLite (Used in mobile apps)

Summary: Advantages of DBMS

  • ✅ Improved data security
  • ✅ Easy data access to users
  • ✅ Reduced data redundancy
  • ✅ Data consistency
  • ✅ Multi-user support

Next Up: Now that we know what a database is, let's learn the language we use to talk to it.

Go to Lesson 2: Introduction to SQL & Datatypes (Coming Soon)

Comments

Post a Comment

Popular posts from this blog

Lesson 2: Introduction to SQL

Welcome to Lesson 2. In the last lesson, we learned that the database is like a "digital filing cabinet." Now, we are going to learn the language used to talk to that cabinet. That language is SQL.  In this Introduction to SQL for beginners , you will learn how to use SQL to fetch data from a database. 1. What is SQL? SQL stands for Structured Query Language . It is the standard language for storing, manipulating, and retrieving data in a relational database. You: "Hey database, show me the names of all employees who joined today." SQL: SELECT emp_name FROM employees; Database: "Here is the list." Important Note: SQL is NOT a database (like Oracle or MySQL). SQL is the language used to talk to those databases. 2. The 3 Golden Rules of SQL Syntax Just like English has grammar rules, SQL has syntax rules. If you break them, the database won't understand you. Rule Explanation 1. Semico...
Read more

Lesson 4: SQL Constraints (Rules for Your Data).

Welcome to Lesson 4. In the last lesson, we learned about Data Types (Text, Numbers, Dates). But simply knowing the type isn't enough. Imagine a "Sign Up" form on a website. What happens if: A user tries to sign up without a password ? Two users try to use the same email address ? The database must stop this! We use Constraints to enforce these rules. 1. What are SQL Constraints? Constraints are rules we apply to columns to ensure the data is accurate and reliable. If you try to insert data that breaks a rule, the database will say "Error" and reject it. 2. The 6 Most Important Constraints Here are the rules you will use in almost every table: Constraint The Rule Real Life Example NOT NULL The column cannot be empty. A user must have a Password. UNIQUE No duplicate values allowed. Two users cannot have the same Email . DEFAULT ...
Read more