SQL (Database app)

SQL is the standard language for manipulating, storing and retrieving data in a database. This presentation explains the advantages of using SQL, the process of creating a database using SQL language, and provides references for further reading.

SQL (Database app)

INTRODUCTION
• SQL is based on the standard language for manipulating, storing and retrieving data into
database.
• Structure query language is the standards for relational database system. there are
different types of RDBMS such as MS Access, MySQL, Postgres, MS Access and SQL
server.

Why use SQL in database
• SQL is the most popular and suitable for database creation because they provide various
facilities to user.
• It allow for user to access data in the relational database management system.
• It allow for user to define and manipulate data in proper manner.
• It useful for embedded with other standard language such as pre-complier, SQL modules
and other libraries.

Cont.
• It allow for user to create and drop database and multiple table by using SQL commands.
• It allow for user to set permissions on procedures, views and tables.
• It allow for user to perform different function in database and create, stored procedure
for further development.
• It useful for user to set up specific permission on table, views and procedures.

Structure Query Language process

Cont.
• When it will be executing the structure command for relational database management
system so that system identify the best way to carry out request where SQL engine figure
out how to interpret the task.

Cont.
There are different components in the process.
• Optimization Engines
• Classical Query engine
• Query dispatcher
• SQL query engine

How to create database by using SQL language
• A Database is mainly defined the structure set of data or information. In this way, SQL is
the important step to store the data in structured manner. It will create a database through
SQL statements.

Syntax
• Create database DB_name;
This statement will use to execute query for creating new database in SQL.
• For creating the database, it is important to store data in the form of table. While using
create table statement in SQL.

Cont.
For Example-
• Create table Employee
• (
• Enrollment_No int(10);
• Name Varchar(20),
• Subject Varchar (20),
• )

Advantage of SQL
• It can perform high functionality by using SQL queries. User can efficiently retrieve the
large amount of data from database system.
• There are no as such coding required because SQL help for managing database through
SQL statements.
• It is well defined standard, portable and interactive language.

Cont.
• By using SQL queries, every table is broken up into smaller entities called entities.. The
fields in any table consists of primary key and their multiple attributes. A field is a type
of column in database table where it is designed to maintain specific information in
proper manner.

REFERENCES
• Mukherjee, S., 2019. Popular SQL Server Database Encryption Choices. arXiv preprint
arXiv:1901.03179.
• Kotsogiannis, I., Tao, Y., He, X., Fanaeepour, M., Machanavajjhala, A., Hay, M. and
Miklau, G., 2019. PrivateSQL: a differentially private SQL query engine. Proceedings of
the VLDB Endowment. 12(11). pp.1371-1384.

Thank You