SQL Tutorial For Beginners

By HAU DANG

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

• Language: English
• Publisher: Lulu.com
• Release date: Dec 17, 2021
• ISBN: 9781716152030

Book preview

Chapter 1 Introduction to 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 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.

4. SQL Tutorial – History

It later came to be known as Oracle.

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.

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

a. Data Query Language (DQL)

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

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.

Chapter 2 SQL RDBMS Concept

1. Concept Of SQL RDBMS

Today, in this RDBMS tutorial, we will discuss SQL RDBMS Concept. Firstly, we will see what is RDBMS and the forms of SQL RDBMS. Moreover, we will see SQL Constraints, RDBMS examples, and SQL RDBMS normalization. Also, we will discuss SQL RDBMS features and advantages. In this SQL RDBMS tutorial, we are going to learn about the basic concepts of RDBMS in SQL which will help us study and work well with the technology.

So, let’s start the SQL RDBMS Concept.

SQL RDBMS Concept – Features & Advantages

2. What is RDBMS?

Relational Database Management System is a type of Database management i.e. DBMS which focuses on the relational model. A relational database allows us to deal with different types of data in different ways. The data can retrieve