SQL Database Project | RDBMS Database Project

SQL – Structured Query Language

Introduction to SQL

The Structured Query Language (SQL) is a standard programming language to access and manipulate database. SQL allows the user to create, retrieve, alter and transfer information among database. It is a language designed for managing accessing data in a Relational Data Base Management System (RDBMS),

Processing Skills of SQL

The various processing skills of SQL are :

• Data Definition Language (DDL),


• Data Manipulation Language (DML),


• Embedded Data Manipulation Language,


• View Definition,


• Authorization,


• Integrity,


• Transaction Control.

Data Definition Language (DDL)

The Data Definition Language is a Statement where a Table can be used to Create.  The Table are created with data and its related information.  The DDL SQL Query is a CREATE Statement.

Data Manipulation Language (DML)

The Data Manipulation Language is a Statement for calculating a Data which is stored in a Database.  The Database data are calculated with Query.  The Data Manipulation Language Query are Insert, Select, Update, Delete are used for calculating a database.

Embedded Data Manipulation Language 

The Data Manipulation Language are inserted in a Program Language with inputting, Control Statement.  The Create, insert, select, update, delete statements are used in Embedded Data Manipulation Language.

View Definition

The View Definition are used in Data Manipulation Language.  The View Command are used to View a Data from Table with Some Conditions.

Authorization

The Authorization is a Rights giving to Access the Data from the Database in SQL.  The Security are given to the SQL Database Table.  For example a Authorized Person can access the Data from the Database Table. 

Integrity

The Integrity Option are available in SQL.  The two Table are integrated and access the data and can be manipulated.  For example, Student Details Table and Student Mark  Table are Integrated and the table data are Manipulated and Produce Mark Statement.

Transaction Control

The Transaction Control is a Query where a transaction can be done or not is asked to the user.  If the User says it is yes the transaction are done otherwise the transaction will not be done.  This type of manipulation is a Transaction Control.

Example for Structured Query Language

Payroll System

The Structured Query Language can be used to Develop a Table for Employee Payroll System.  The Table Contains Employee Code, Employee Name, Employee Department, Employee Salary, House Rent Allowance, Daily Allowance, Travel Allowance, Home Loan, Other Deduction and Calculating a Salary with Allowance and Deduction.  The Net Pay and Gross Pay is Calculated for the Employee.  The Query can be used to Calculate a Employee.

• The Create Query is used to Create a Table for Employee Payroll System.


• The Insert Query is used to insert a Data for a Table Employee Payroll System.


• The Select Query is used to Display a Data for Calculate a Employee Payroll System.