BeginnersBook

  • Home
  • Java
    • Java OOPs
    • Java Collections
    • Java Examples
  • C
    • C Examples
  • C++
    • C++ Examples
  • DBMS
  • Computer Network
  • Python
    • Python Examples
  • More…
    • jQuery
    • Kotlin
    • WordPress
    • SEO
    • JSON
    • JSP
    • JSTL
    • Servlet
    • MongoDB
    • XML
    • Perl

Introduction to SQL

Last Updated: August 19, 2022 by Chaitanya Singh | Filed Under: SQL

SQL is a language which is used to interact with relational database management system.

Before we learn what is a SQL and what we can do with the SQL, let’s learn the basics first.

What is a database

Database is a organized collection of data. For example a database of a college would be having a collection of data such as –
1. Personal records of Students
2. Students performance history
3. Teachers data
4. Financial department data etc.

Database Management System (DBMS)

A database management system is a software application which is used for managing different databases. It helps us to create and manage database. With the help of DBMS we take care following tasks –
1. Data Security
2. Data Backup
3. Manages huge amount of data
4. Data export & import
5. Serving multiple concurrent database requests
6. Gives us a way to manage the data using programming languages.

To learn more about DBMS, refer this guide – DBMS Tutorial.

Types of Databases

There are two types of databases –
1. Relational Database
2. Non-relational Database

Non-relational databases:

Data is not organized in form of tables. Data is stored in form of key & value pairs. The examples of non-relational databases are: JSON & XML.

We cannot interact with non-relational databases using SQL.

Relational Databases:

In relational database, data is organized in form of tables. A table contains rows and columns of data. Table has a unique key to identify each row of the table.

SQL is used to interact with relational databases. We often refer relational database as SQL database.

What is SQL?

1. SQL stands for Structured Query Language, which is a standardised language for interacting with RDBMS (Relational Database Management System). Some of the popular relational database example are: MySQL, Oracle, mariaDB, postgreSQL etc.

2. SQL is used to perform C.R.U.D (Create, Retrieve, Update & Delete) operations on relational databases.

3. SQL can also perform administrative tasks on database such as database security, backup, user management etc.

4. We can create databases and tables using SQL.

Types of Structured Query Language(SQL)

In the above section, we learned what we do with the database using SQL. SQL is basically combination of four different languages, they are –

DQL (Data Query Language)

DQL is used to fetch the data from the database that already exists in the database. DQL command is: SELECT.

DDL (Data Definition Language)

DDL is used to define table schemas. DDL commands are: CREATE, DROP and ALTER.

DCL (Data Control Language)

DCL is used for user & permission management. It controls the access to the database. DCL commands are: GRANT and REVOKE.

DML (Data Manipulation Language)

DML is used for inserting, updating and deleting data from the database. DML commands are: INSERT, DELETE and UPDATE.

TCL (Transaction Control Language)

TCL is used for transaction management tasks in the database. TCL commands are: COMMIT and ROLLBACK.

What is a Query

A Query is a set of instruction given to the database management system, which tells RDBMS what information you would like to get, insert, update or delete from the database.

Note: Do not worry about learning the queries now, this is just an introduction. We will learn how to write queries in detail in the next tutorials.
For e.g. to fetch the employee name from the database table EMPLOYEE, we write the SQL Query like this:

SELECT employee_name from EMPLOYEE;
❮ SQL TutorialSQL Syntax ❯

Top Related Articles:

  1. SQL SELECT TOP Statement
  2. SQL Rename Database using ALTER DATABASE Statement
  3. SQL CREATE DATABASE Statement
  4. SQL UPDATE Statement
  5. SQL DROP DATABASE Statement

About the Author

I have 15 years of experience in the IT industry, working with renowned multinational corporations. Additionally, I have dedicated over a decade to teaching, allowing me to refine my skills in delivering information in a simple and easily understandable manner.

– Chaitanya

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

SQL Tutorial

  • SQL Tutorial
  • SQL Introduction
  • SQL Syntax
  • SQL Data Types

SQL Database

  • SQL CREATE DB
  • SQL DROP DB
  • SQL Rename DB
  • SQL USE DB

SQL Queries

  • SQL Select
  • SQL Select Distinct
  • SQL Select Count
  • SQL Select Top
  • SQL Where
  • SQL AND, OR & NOT
  • SQL Order By
  • SQL Insert Into
  • SQL Insert Into SELECT
  • SQL Select Random
  • SQL Alias
  • SQL NULL Check
  • SQL Update
  • SQL Delete
  • SQL MIN, MAX
  • SQL SUM
  • SQL AVG

Copyright © 2012 – 2025 BeginnersBook . Privacy Policy . Sitemap