Logo
×

Introduction to SQL

SQL Introduction

  • SQL is Standard Query Language.
  • This language is used to communicate or interact with database.
  • In other words, SQL is used to access and manage data or information in the database by performing many different operations on data or tables or database.
  • According to the ANSI (American National Standards Institute), SQL is a standard language for RDBMS.
  • With the help of SQL, each user can get a different view of data as per their need.
  • SQL retrieves same data from a database and represents it in many different ways so that user can understand easily.
  • SQL is not case-sensitive.
  • In most of the cases, SQL syntax differs as the database changes.
  • Some most popular databases are: MySQL, ORACLE, DB2, SQL SERVER, MS ACCESS etc.

What is Database?

  • Database is a Data structure which stores organized data or information in the form of tables or files.
  • Database is nothing but a collection of tables/files/data.
  • Database is a collection of related data, which is organized in such a way so that storing, accessing, managing, modifying/updating of data becomes easier.
For example: Microsoft Excel is example of desktop database programs, which allows user to insert /enter data, store data and access that data whenever required.

What is DBMS?

DataBase Management System (DBMS) is a set of programs or software which allows creation, modification of database and at the same time it allows many different users to perform operations on database like store, modify, access etc.

RDBMS

Relational Database Management System is based on Relational model.
  • In RDBMS, everything is present in the form of relations.
  • Relation means Table.
  • Data is present in a tabular form.
  • Tables are interrelated with each other.
  • Dependencies/ Relationship between two tables is also represented through relation/table.

What is Difference Between DBMS and RDBMS ?

  • RDBMS applications store data in a tabular form whereas DBMS applications store data in the form of files.
  • DBMS can have Tables but there is no relation present in between tables.

Related Topics

SQL UPDATE

SQL UPDATE The SQL UPDATE statement is utilized to update and modify the records present into a database. It is used to change the already existing records stored in the tables...

3 minutes read.

Drop vs Truncate in SQL

In this article, we will learn and understand the Drop and Truncate commands and the difference between these two commands. What is Drop Command? Drop is a Data Definition Language command in...

6 minutes read.

Difference between Delete, Drop and Truncate in SQL

What is the Delete command in SQL? In DML (Data Manipulation Language), we use the delete command that allows us to delete the some entries and modify the databases in SQL....

4 minutes read.

How to drop a column in SQL?

How to drop a column in SQL Introduction To delete a column from an already created table, one needs to use the ALTER command along with the DROP COLUMN clause. Syntax: ALTER TABLE tablename...

4 minutes read.

DELETE VS DROP in SQL

This page contains all the information about the Delete command and Drop command concept and the difference between the DELETE and DROP commands in SQL. What is the DELETE command in...

3 minutes read.

SQL Data Manipulation Language

Data Manipulation Language manipulates/make changes in data present in a table. It only affects data/records of table, not on the schema/structure of table. INSERT, UPDATE, DELETE are the commands of DML. INSERT: Stores...

2 minutes read.

SQL ORDER BY

SQL ORDER BY The SQL ORDER BY clause is used to sort the data stored in tables in the database. The sorting can be done in an ascending way, descending way,...

5 minutes read.

GROUP BY vs ORDER BY

The GROUP BY clause and ORDER BY clause in SQL are used to arrange data obtained by SQL queries. The important difference between the GROUP BY clause and ORDER BY...

4 minutes read.

SQL DROP Table

In this tutorial, we will help you to understand how to delete the table from the database in SQL with the help of examples. The DROP TABLE query is used to...

4 minutes read.

Difference between SQL and NoSQL

SQL vs. NoSQL | Difference between SQL and NoSQL Choosing a database is the most fundamental decision that needs to be decided before starting a task. Relational and non-relational databases are...

3 minutes read.

Commit and Rollback in SQL

In Structured Query Language, we have Data Definition Language (DDL) and Data Manipulation Language (DML) commands the same way we have Transaction Control Language (TCL) commands in the Structured Query...

4 minutes read.

SQL SELECT IN

SQL SELECT IN is a logical operator in Structured Query Language. It is used in SQL queries to reduce the use of multiple 'OR' operators. s The IN operator in SQL...

6 minutes read.

SQL NOT Operator

SQL NOT is a Boolean operator used with the WHERE clause. NOT operator shows the records if the expression is false. When we use the NOT operator, we fetch only...

7 minutes read.

SQL Cast Operator

While writing SQL queries, we can see many values which are to be converted into another datatype for accessing them. In SQL this conversion is generally done by CAST function. CAST...

4 minutes read.

WEB SQL

What is Web SQL? In SQL we can create databases, read the data in the databases, insert the records into the databases, and delete the records from the databases. For storing...

4 minutes read.

SQL Aggregate Functions

In this tutorial, we will learn and understand the SQL Aggregate Functions concept with the help of examples. SQL Aggregate Function is a function used to perform calculation operations on one...

4 minutes read.

SQL Injection

SQL injection is a technique, this may destroy the database. It is one type of hacking technique. SQL IN WEB PAGES: Injection occurs when we ask for input like an id or...

3 minutes read.

SQL Left Join

The SQL Left Join query displays all the records from the table and displays similar records from the right table. The query displays zero records if it doesn’t find any...

4 minutes read.

SQL INSERT Table

In this tutorial, we will help you to understand and learn how to add records to the table in SQL with the help of examples. SQL INSERT query is used to...

5 minutes read.

SQL CRUD Operation

In any computer language, CRUD operation is a foundation. CRUD operation rules are applied in databases as well. These operations are the basic operations used to perform with any database...

7 minutes read.