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

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.

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 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 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.

How to delete a row in SQL

Introduction To delete or remove the unused/unwanted rows from a table, DELETE command is used in SQL.DELETE command removes the entire record from a table.The DELETE statement can delete one or...

6 minutes read.

SQL SELECT SUM

The SQL Sum() function is an aggregate function in SQL that returns the total values of an expression. The expression may be numerical, or it may be an expression. Syntax: SELECT SUM(columnname)...

3 minutes read.

SQL SELECT MIN

The SQL Min() function is an aggregate function in SQL. SQL Min() returns the minimum value of a given condition. The expression may be numerical, or it may be an expression. The syntax...

5 minutes read.

How to add column in table in SQL ?

How to add column in table in SQL  Introduction To add a column in already created table, one needs to use the ALTER command along with the ADD clause.If in the query,...

7 minutes read.

Trigger in SQL

In this article, we will learn about the concept of trigger in SQL and its implementation with the help of an example. A Trigger in Structured Query Language is a set...

4 minutes read.

SQL Top Clause

Top Clause: It returns the first ‘n’ number of rows as output. This Top clause is used to retrieve the required number of rows when there are thousands of records stored...

3 minutes read.

SQL Arithmetic Operators

This page contains all the information, learn about SQL Arithmetic Operators concept in the SQL table with the help of examples. The Arithmetic Operators is used to perform mathematical calculations on...

5 minutes read.

Grant Command in SQL

What is DCL (Data Control Language)? Data Control Language (DCL) is a computer programming language with syntax intended to manage access to data kept in databases. It is a part of...

3 minutes read.

SQL CASE

This page contains all the information about SQL CASE. The CASE is an If-Else type of logical query used in the statement. The CASE in Structured Query Language is similar...

5 minutes read.

SQL Queries

In a database, queries are used to request the result set of data from the table or action on the records. A Query can answer your simple or complicated question, perform...

5 minutes read.

Truncate function in SQL

The TRUNCATE is a numeric function in SQL which truncates the number according to the particular decimal points. Syntax of TRUNCATE Function SELECT TRUNCATE(X, D) AS Alias_Name; In the TRUNCATE syntax, X...

4 minutes read.

SQL COPY Table

In this tutorial, we will learn how to copy tables in SQL with the help of examples. Using the SELECT INTO statement in the SQL we can copy one table into...

4 minutes read.

SQL Temporary Tables

Temporary Table: The Temporary tables are generally created in TempDB. If the last connection is terminated then the tables are deleted automatically. These are generally used to store and process the...

4 minutes read.

SQL WHERE Statement

SQL WHERE Statement Introduction WHERE clause is used to include a condition while fetching data from tables.When you have to specify a condition that has to be obeyed while data is...

9 minutes read.

SQL VIEW

The SQL VIEW concept helps to hide the difficulty of the records and provides limitations to access to the database. The SQL view is similar to the SQL tables. In SQL...

7 minutes read.

SQL SELECT Database

In this tutorial, we will help you to understand and learn how to select the database in SQL with the help of examples. The database user or the administrator wants to...

3 minutes read.