Chapter 1
About DATA, DBMS, RDBMS, SQL
What is Data?
Data refers to raw facts, figures, observations, or values that have not yet been processed into
meaningful information.
Data can be numbers, text, images, audio, videos, dates, or any other form of digital content.
By itself, data may not provide any meaningful insight. Once it is organized, processed, and
analyzed, it becomes useful information.
Characteristics of Data
Good-quality data should have the following characteristics:
1. Accuracy
The data should be correct and free from errors.
Example:
2. Completeness
All required fields should be filled.
3. Consistency
The same information should remain uniform throughout the database.
4. Timeliness
The information should be updated whenever changes occur.
5. Reliability
Data should come from trusted sources.
Sources of Data
Data can be collected from many different sources.
Examples include:
• Online forms
• Websites
• Mobile applications
• IoT devices
• Social media platforms
• Banking systems
• Hospital management systems
• Schools and colleges
• Government records
• Customer feedback surveys
• Types of Data
• Data is generally classified into three categories.
1. Structured Data
Structured data is organized into rows and columns and follows a predefined format.
It is easy to search, update, and analyze.
Examples:
• SQL databases
• Excel spreadsheets
• Employee records
• Student databases
Characteristics
• Organized
• Easy to query
• Stored in tables
• Supports relationships
2. Unstructured Data
Unstructured data does not follow a fixed format.
Examples
• Images
• Videos
• Audio files
• PDF documents
• Emails
• WhatsApp chats
• Social media posts
Characteristics
• Difficult to analyze
• No predefined structure
• Requires AI or big data tools for processing
3. Semi-Structured Data
Semi-structured data has some organizational properties but does not fit neatly into tables.
Examples
• JSON
• XML
• CSV
• HTML
Characteristics
• Flexible structure
• Easy to exchange between systems
• Widely used in web applications
Structured Data
Structured Data is data that is organized in a predefined format, usually in the form of rows
and columns. Since it follows a fixed structure (schema), it is easy to store, search, update,
and analyze.
Structured data is typically stored in Relational Database Management Systems (RDBMS) such
as MySQL, Oracle, SQL Server, and PostgreSQL.
Simple Definition
Structured Data is data that is organized into tables with rows and columns, making it easy to
store, retrieve, and manage using SQL.
Advantages of Structured Data
• Easy to store and organize.
• Fast searching and retrieval.
• Supports SQL queries.
• High accuracy due to validation rules.
• Reduces duplicate data.
• Easy to update and maintain.
• Supports relationships between tables.
• Provides better security and access control.
• Generates reports quickly.
• Suitable for large organizations.
Disadvantages of Structured Data
• Requires a predefined schema before storing data.
• Less flexible when the structure changes frequently.
• Not suitable for storing images, videos, or audio files.
• Modifying the database structure can be time-consuming.
Where is Structured Data Used?
Structured data is widely used in industries where information must be organized and
accessed efficiently.
• Banking systems
• Hospital management systems
• School and college databases
• E-commerce platforms (Amazon, Flipkart)
• Railway reservation systems
• Airline booking systems
• Payroll systems
• Inventory management
• Customer Relationship Management (CRM)
• Human Resource Management (HRMS)
Popular Databases for Structured Data
• MySQL
• Oracle Database
• Microsoft SQL Server
• PostgreSQL
• SQLite
• MariaDB
What is a DBMS?
• A Database Management System (DBMS) is software that allows users to create, store,
organize, retrieve, update, and manage data efficiently.
Real-Life Example
Think of a library.
• The books are the data.
• The library is the database.
• The librarian is the DBMS.
Disadvantages of a DBMS
• Initial setup cost can be high.
• Requires trained professionals.
• Maintenance can be expensive.
• Performance may decrease with very large databases.
• Software licensing costs.
What is RDBMS?
Definition
RDBMS stands for Relational Database Management System.
It is an advanced type of DBMS that stores data in the form of related tables.
These tables are connected using Primary Keys and Foreign Keys.
Advantages of an RDBMS
• Minimizes duplicate data.
• Maintains relationships between tables.
• Faster searching.
• High security.
• Supports complex queries.
• Better scalability.
• Easier maintenance.
• Ensures data consistency.
• Supports multiple users.
• Reliable transaction management.
Disadvantages of an RDBMS
• More complex than a basic DBMS.
• Requires proper database design.
• Slightly higher hardware requirements.
• Performance tuning is needed for very large databases.
Popular RDBMS Software
• MySQL
• Oracle Database
• Microsoft SQL Server
• PostgreSQL
• SQLite
• MariaDB
• IBM Db2
What is a Database?
A database is a structured collection of related data that is stored electronically and managed
for easy access, retrieval, updating, and deletion.
What is SQL?
Definition
SQL (Structured Query Language) is a standard language used to communicate with a
Relational Database Management System (RDBMS).
It is used to create databases, create tables, store data, retrieve data, update records, delete
records, and manage database security.
Advantages of SQL
• Easy to learn and use
• Fast data retrieval
• Handles large volumes of data
• Supports data insertion, updating, and deletion
• Provides high data security
• Ensures data integrity
• Supports multiple users simultaneously
• Generates reports efficiently
• Industry-standard database language
• Integrates with programming languages and BI tools
• High demand in the job market
• Portable across different database systems
Disadvantages of SQL
• Mainly works with structured data
• Syntax varies slightly across database systems
• Complex queries can be difficult to write
• Performance depends on proper database design
• Not suitable for storing unstructured data (images, videos, audio)
• Requires knowledge of database concepts
• Large databases require regular maintenance
Real-World Use Cases of SQL
• Banking Systems
• E-Commerce Websites
• Hospital Management Systems
• School & College Management Systems
• Railway Reservation Systems
• Airline Reservation Systems
• Inventory Management
• Payroll Management
• Customer Relationship Management (CRM)
• Human Resource Management (HRMS)
• Social Media Platforms
• Online Food Delivery Apps
• Telecom Companies
• Insurance Companies
• Government Departments
• Data Analytics & Business Intelligence
• Finance and Accounting Systems
• Manufacturing Industry
• Logistics and Supply Chain Management
• Hotel Management Systems
Careers That Require SQL
SQL is a core skill for many technology and business roles.
• Data Analyst
• Business Analyst
• Data Engineer
• Database Administrator (DBA)
• Data Scientist
• BI Developer
• ETL Developer
• Backend Developer
• Software Engineer
• Cloud Data Engineer