Code Marathi Logo

Introduction

5 min read ·

SQL stands for Structured Query Language. It is the standard language used to store, retrieve, manage, and manipulate data in relational database management systems (RDBMS).
SQL is used by developers, data analysts, data engineers, database administrators, and backend systems to work with structured data efficiently.

Why SQL Exists

As applications grew, data needed to be:
  • Stored permanently
  • Structured properly
  • Retrieved efficiently
  • Updated safely
  • Shared across multiple users
SQL was designed to interact with relational databases in a simple, readable, and powerful way.
Instead of writing complex programs to handle data, SQL allows you to communicate with databases using declarative commands.

What SQL Is Used For

SQL is used to:
  • Create databases and tables
  • Insert data into tables
  • Retrieve data using queries
  • Update existing records
  • Delete records
  • Control access and permissions
  • Maintain data integrity
  • Perform analytics and reporting
SQL is the backbone of:
  • Web applications
  • Enterprise systems
  • Banking software
  • E-commerce platforms
  • Data analytics pipelines

What Is a Database

A database is an organized collection of data stored electronically.
Example:
  • Student records
  • Product catalogs
  • Transaction history
  • User profiles
Databases allow:
  • Fast searching
  • Secure storage
  • Concurrent access
  • Data consistency

What Is a Relational Database

A relational database stores data in the form of tables (also called relations).
Each table consists of:
  • Rows (records)
  • Columns (attributes)
Example table: Students
idnameagecourse
1Amit20SQL
2Riya22Python

What Is SQL Exactly

SQL is a declarative language, which means:
You tell the database what you want, not how to do it.
Example:
The database engine decides:
  • How to search
  • Which indexes to use
  • How to optimize performance

SQL Is Not Case-Sensitive

Both are valid, but uppercase keywords are considered best practice.

SQL Components (Types of SQL Commands)

SQL commands are grouped into categories.

1. DDL – Data Definition Language

DDL commands define and modify database structure.
Common DDL commands:
  • CREATE
  • ALTER
  • DROP
  • TRUNCATE
Example:

2. DML – Data Manipulation Language

DML commands manage data inside tables.
Common DML commands:
  • INSERT
  • UPDATE
  • DELETE
Example:

3. DQL – Data Query Language

Used to retrieve data.
Main command:
  • SELECT
Example:

4. DCL – Data Control Language

Used for permissions and security.
Commands:
  • GRANT
  • REVOKE
Example:

5. TCL – Transaction Control Language

Used to manage transactions.
Commands:
  • COMMIT
  • ROLLBACK
  • SAVEPOINT
Example:

What Is a Table

A table is a structured format to store data.
  • Each row represents one record
  • Each column represents one attribute
  • Tables enforce data types and constraints
Example:

Keys in SQL

Primary Key

  • Uniquely identifies a row
  • Cannot be NULL
  • No duplicates

Foreign Key

  • Links two tables
  • Maintains relationship between tables

Constraints in SQL

Constraints ensure data integrity.
Common constraints:
  • NOT NULL
  • UNIQUE
  • PRIMARY KEY
  • FOREIGN KEY
  • CHECK
  • DEFAULT
Example:

SQL Data Types

SQL supports multiple data types, such as:
  • INT – integers
  • VARCHAR – text
  • DATE – date values
  • FLOAT – decimal numbers
  • BOOLEAN – true/false
Choosing correct data types improves:
  • Performance
  • Storage efficiency
  • Data accuracy

SQL Works with Many Databases

SQL syntax is mostly common, but databases may have slight differences.
Popular SQL-based databases:
  • MySQL
  • PostgreSQL
  • Oracle
  • SQL Server
  • SQLite
Core SQL concepts remain the same across all.

SQL vs NoSQL (Basic Difference)

SQLNoSQL
Structured dataUnstructured data
Fixed schemaFlexible schema
TablesDocuments / Collections
Strong consistencyHigh scalability
SQL is preferred when:
  • Data relationships matter
  • Transactions are critical
  • Data integrity is important

Real-World SQL Example

This single query can:
  • Filter data
  • Sort results
  • Return only required columns

Common Beginner Mistakes

  • Forgetting WHERE in DELETE
  • Not using primary keys
  • Using wrong data types
  • Ignoring constraints
  • Writing inefficient queries

Why SQL Is Important

  • Industry-standard language
  • Works across platforms
  • Required for backend development
  • Essential for data analytics
  • Core skill for FAANG interviews
  • Foundation for data engineering