SQL Tutorial For Beginners | Learn SQL

1. Structured Query Language – SQL Tutorial

Today, we start our new journey with SQL Tutorial. SQL stands for Structured Query Language. In this SQL tutorial, we will learn the actual meaning of SQL and its uses. Also, we will discuss important SQL Commands and SQL Examples. At last, we will see the evolution of SQL.
So, let’s start SQL Tutorial.

SQL Tutorial

SQL Tutorial For Beginners | Learn SQL

2. What is SQL?

SQL is a database query language we use it for operating databases. It is used for storing and managing data in Relational DBMS, the operations included are creation, deletion, modifying rows, etc. SQL is standardized by ANSI (American National Standards Institute).
Let us learn in detail about SQL.
SQL is a Relational Database Management Systems (RDMS), that is, it is a standard language for Relational Database system.
Examples of RDMS are MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server, they all use SQL as their standard database language.
Different used dialects are –

  • MS SQL Server using T-SQL,
  • Oracle using PL/SQL,

The MS Access version is called JET SQL (native format) etc.

3. SQL Tutorial – Use of SQL (Structured Query Language)?

  • It allows users to access information within the computer database management systems.
  • Allows users to explain the information.
  • SQL users to outline (the information) during an information and manipulate that data.
  • Allows entering among alternative languages exploitation SQL modules, libraries & pre-compilers.
  • Allows users to form and drop databases and tables.
  • Structured Query Language users to form read, keep procedure, functions during an information.
  • Allows users to line permissions on tables, procedures, and views.

Let’s explore SQL Operators

4. SQL Tutorial – History

It later came to be known as Oracle.

YearDescription
1970Dr. Edgar F. “Ted” Coddfrom IBM who was known as the father of relational databases described the relational model of databases.
1974SQL appeared.
1978IBM released a product named System/R using Codd’s ideas.
1986First prototype was the relational database is developed which is standardized by ANSI.

When you are executing associate degree SQL command for any RDBMS, the system determines the most effective thanks to do your request and SQL engine figures out a way to interpret the task.
Have a look at SQL Data Types
There are varied components enclosed during this method in SQL Tutorial.
Components of SQL are −

  • Query Dispatcher
  • Optimization Engines
  • Classic query Engine
  • SQL query Engine, etc.

A classic query engine handles all the non-SQL queries. However, a SQL query engine will not handle logical files.

SQL Tutorial

SQL Tutorial – Process of SQL

5. SQL Tutorial – SQL Command

Following are the commands in SQL to manipulate the data which we can store in RDBMS.

SQL Tutorial - SQL Command

SQL Tutorial – SQL Command

a. Data Query Language (DQL)

i. SELECT – This SQL Command we use to retrieve certain records from one or more tables.
Learn more about SQL Command in details

b. Data Manipulation Language (DML)

i. INSERT – We use this command in SQL to create a record.
ii. UPDATE –  We use this command in SQL to change certain records.
iii. DELETE – This command is used to delete certain records.

c. Data Definition Language (DDL)

i. CREATE – We use this command to create a new table, a view of a table, or other objects in the database.
ii. ALTER – This command is used to modify an existing database object, such as a table.
iii. DROP – We use this command to delete an entire table, a view of a table or other object in the database.

d. Data Control Language (DCL)

i. GRANT – We use this command to give a privilege to someone.
ii. REVOKE – This command is used to take back privileges granted to someone

6. Conclusion: SQL Tutorial

Hence, in this SQL Tutorial, we discussed the meaning of Structured Query Language. Moreover, we saw the need and use of SQL. Also, this SQL Tutorial guides us, many SQL commands and components of Structured Query Language. Still, if any doubt in this complete SQL tutorial, ask in the comment tab.
See also – 
SQL Subqueries
For reference

3 Responses

  1. Kartik Yadav says:

    what are the subqueries in SQL?

    • Data Flair says:

      Hi Kartik,
      I hope you read the complete SQL tutorial. Now you want to know about Subquery. So, here is the answer
      A query that is nested within any SELECT, INSERT, UPDATE, or DELETE statement is a subquery. It is also possible to nest a subquery in another. We can put a subquery anywhere we can put an expression.
      You can learn more about Subqueries fro the below link –
      https://data-flair.training/blogs/sql-subquery/

  2. Vishal Anand says:

    Hi Data Flair Team,

    This is really helpful and I will recommend Data Flair to others for learning SQL and other applications.

    Thank you,
    Vishal Anand

Leave a Reply

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