SQL - SPLessons

SQL Databases

Chapter 3

SPLessons 5 Steps, 3 Clicks
5 Steps - 3 Clicks

SQL Databases

SQL Databases

shape Description

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.

shape 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.

shape Examples

The below example describes the sample example of sql query.

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)

It will display all the student table values that are stored in the database.

SQL process

shape 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

shape 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

shape Key Points

  • SQL Databases – Are a collection of huge amount of data.
  • SQL Process – Describes the supporting versions and features of SQL Database.