SQL Tutorial For Beginners | Learn SQL
Don't become Obsolete & get a Pink Slip
Follow DataFlair on Google News & Stay ahead of the game
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.
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.
4. SQL Tutorial – History
It later came to be known as Oracle.
|1970||Dr. Edgar F. “Ted” Coddfrom IBM who was known as the father of relational databases described the relational model of databases.|
|1978||IBM released a product named System/R using Codd’s ideas.|
|1986||First 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.
5. SQL Tutorial – SQL Command
Following are the commands in SQL to manipulate the data which we can store in RDBMS.
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 –