SQL Databases are huge gathering of logical related information which can be created, accessed, managed, and updated. The data may be in any form like text and numbers.
Many types of data stores are present, such as files on the file system, where data reading and writing will be very slow. So in the present generation, Relational Database Administration framework is being utilized to store and oversee colossal measure of information. All relational database management systems like MySQL, MS Access, Oracle, Sybase, Postgre and SQL Server use SQL as standard database language.
Conceptual
figure
Queries - Is used to fetch the database from the database.
RDBMS - Stands for relational database management system.
Operating system - Which support basic computer functions.
Database - Is a logical related data which is stored in the database.
Examples
The below example describes the sample example of sql query.
[c]sql> create table student(stu_id number(4),stu_name varchar(255),fee int);
Query OK, 0 rows affected (0.32 sec)
sql> insert into student values(1001,'rock',12000);
Query OK, 1 row affected (0.16 sec)
sql> insert into student values(1002,'hairy',13000);
Query OK, 1 row affected (0.17 sec)
sql> insert into student values(1003,'scena',13000);
Query OK, 1 row affected (0.16 sec)
select * from student;
+--------+----------+-------+
| stu_id | stu_name | fee |
+--------+----------+-------+
| 1001 | rock | 12000 |
| 1002 | hairy | 13100 |
| 1003 | scena | 13000 |
+--------+----------+-------+
3 rows in set (0.00 sec)[/c]
It will display all the student table values that are stored in the database.
SQL process
Description
SQL databases are very quick and user friendly database. SQL is an ANSI (American National Standards Institute) standard but there are many different versions of the SQL language.
SQL is published under an open-source license agreement.
SQL handles more expensive and powerful database packages.
SQL deals with C, C++, PHP, Java and so on and other working frameworks.
SQL works quick and handle even with tremendous information sets.
SQL is neighborly to PHP, the most section on dialect for web improvement.
SQL advances gigantic databases, upto 50 million columns and significantly more in the table. The default size point of confinement of a table is 4GB, however can be stretched out to a hypothetical cutoff of 8 million terabytes (TB).
SQL is imprint. In general source, GPL permits developers to change the SQL programming to suit their own particular informational system.
Features
Description
The features of SQL databases are as follows:
High Performance
High Availability
Adaptability and Flexibility Run anything
Robust Transactional Support
Web and Data Warehouse Strengths
Strong Data Protection
Comprehensive Application Development
Management Ease
Open Source Freedom and 24 x 7 Support
Lowest Total Cost of Ownership
Summary
Key Points
SQL Databases - Are a collection of huge amount of data.
SQL Process - Describes the supporting versions and features of SQL Database.