Introduction To SQL

Introduction To SQL Server

Introduction:

In this article, you will learn, what SQL Server is.

SQL stands for Structured Query Language. This is a computer language, which is used to manage, collect, restore the data in the relational database. Most Relational Database Management Systems like MS SQL Server, Microsoft Access, Oracle, MySQL, DB2, Sybase, Postgre SQL use SQL as a database query language.

SQL is a critical programming language, produced for generating and querying the relational database management system. Some important queries of SQL are-

SQL INSERT is used to insert the records into the database tables.

SQL DELETE is used to delete the records from the database tables.

SQL SELECT command is used to modify the data in the database tables.

SQL Process

When we are executing different type of queries in SQL for any relational database management system, the system finds the short way to finalize your request.

Some basic components of SQL process are-

SQL Query Engine, Query Dispatcher, Classic Query Engine and Optimization Engine.

Diagram of SQL Architecture

1. Parser

In SQL process, the first step is parsing. The database parser is a statement when informed by the function means that only the function and not the database can break the number of parses. This includes an independent slice of a SQL statement into a data structure that other techniques are in process.

When we generate the function problem for SQL statement, the function generates a parse call to the database to read the statement for the implement. The parse opens or creates a cursor, which holds a parsed SQL statement and other processing information handles the session-specific private SQL area.

In the process of parse call, the database shows the following conditions-

• Syntax Check

• Semantic Check

• Shared Pool Check

2. SQL Optimization

In the optimization process, Oracle database performs a hard parse at least once for each different DML statement and shows the development during this parse. The database never boosts DDL except it includes a DML element such as a subquery, which requires an optimization.

3. SQL Execution

In the execution process, SQL engine implements every row source in the tree originated by the row source author. This step is an essential step in DML processing.

Summary:

Thus, we learned, SQL is used to store a large amount of data.