BeginnersBook

  • Home
  • Java
    • Java OOPs
    • Java Collections
    • Java Examples
  • C
    • C Examples
  • C++
    • C++ Examples
  • DBMS
  • Computer Network
  • Python
    • Python Examples
  • More…
    • jQuery
    • Kotlin
    • WordPress
    • SEO
    • JSON
    • JSP
    • JSTL
    • Servlet
    • MongoDB
    • XML
    • Perl

DBMS: Advantages of SQL

By Chaitanya Singh | Filed Under: DBMS

In this article, we will discuss the advantages of SQL. We have already seen the several features of SQL in characteristics of SQL. Here, we will cover some of the advantages that we get while using SQL as a database language.

1. Fast Response Time

You can quickly retrieve large amount of data from database using SQL. The response time of a SQL query is very fast.

2. Requires No coding

Learning SQL is easy and doesn’t require any prior coding or programming knowledge. The syntax of SQL is very simple and close to english so learning curve is smooth.

3. Portable

SQL is portable, it supports various operating system and devices. SQL statements can be stored as saved procedures and these procedures can be used on a different machine to perform the same task without needing to rewrite the statements again.

4. Standardised language

SQL is been used for over the years and has wide variety of well maintained documentation. This language is so standardised that the same syntax can be used on various different platforms.

5. Intergation

SQL server can connect to third party backends like Oracle, IDM Db2, MySQL etc. using drivers. These drivers allow the smooth integration.

6. Secure

SQL allows to set permissions in tables, this makes it secure as a user with no permission cannot read, write or modify the data in database. SQL also has the concept of constraints that ensures what type of data can be inserted into the tables. All these features make SQL a secure database language.

7. Scalable

It is easy to add or drop tables in the database using SQL. Also, the database size doesn’t affect the performance of SQL that much and it works pretty great with large databases as well. It is easy to add several new tables into the database as well as drop multiple tables from database.

8. Supports Transactions

Transactions are the logical units or sequence of tasks that either needs to be completed fully or none to maintain database integrity. SQL commands such as COMMIT, ROLLBACK, SAVEPOINT etc. support transactions.

❮ Characteristics Of SQLSQL Command ❯

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

DBMS Tutorial

Basics

  • DBMS Tutorial
  • DBMS Introduction
  • Database Applications
  • DBMS vs File System
  • DBMS vs RDBMS
  • DBMS Architecture
  • Three-level DBMS architecture
  • View in DBMS
  • Abstraction
  • Instance & Schema
  • DBMS languages

Data Models

  • Data Models
  • ER Diagram
  • ER Design issues
  • Convert ER to table
  • DBMS Generalization
  • DBMS Specialization
  • DBMS Aggregration
  • Relational Model
  • Hierarchical Model
  • Constraints
  • Cardinality

Relational Database

  • RDBMS concepts
  • Relational Algebra
  • Relational Calculus
  • Keys Index
  • Primary Key
  • Super Key
  • Candidate Key
  • Foreign Key
  • Composite Key
  • Alternate Key

Normalization

  • Normalization
  • Functional dependency

Transaction Management

  • Transaction Management
  • ACID properties
  • Transaction States
  • DBMS Schedules
  • Serializability
  • Conflict Serializability
  • View Serializability
  • Recoverability Of Schedule
  • Failure Classification
  • Log based Recovery
  • DBMS Checkpoint
  • Deadlock

Concurrency Control

  • Concurrency Control
  • Lock based protocol
  • Timestamp based protocol
  • Validation based protocol

File Organization

  • File Organization
  • Sequential File Organization
  • Heap File Organization
  • Hash File Organization
  • DBMS ISAM
  • B+ File Organization
  • Cluster File Organization

SQL Introduction

  • SQL Introduction
  • SQL Characteristics
  • Advantages of SQL
  • SQL Commands
  • SQL Operators
  • SQL CREATE
  • SQL DROP
  • SQL SELECT
  • SQL INSERT

Copyright © 2012 – 2022 BeginnersBook . Privacy Policy . Sitemap