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 Characteristics of SQL

By Chaitanya Singh | Filed Under: DBMS

In this article, you will learn the characteristics of SQL.

Characteristics of SQL

  1. Easy to Learn: SQL is user-friendly, english like language that makes it easy to learn. Learning SQL doesn’t require prior knowledge.
  2. Portable language: SQL is a portable language, which means the software that supports SQL can be moved to another machine without affecting the capability of SQL interacting with the database on new machine.
  3. Supports wide variety of commands: SQL supports various useful commands such as:
    • DDL (Data Definition Language) commands like CREATE, DROP, ALTER.
    • DML (Data Manipulation Language) commands like INSERT, DELETE, UPDATE.
    • DCL (Data Control Language) commands like GRANT, REVOKE.
    • TCL (Transaction Control Language) commands like COMMIT, ROLLBACK.
    • DQL (Data Query Language) commands like SELECT.
  4. Reusability: SQL promotes reusability by supporting stored procedures. These stored procedures are stored SQL statements that can be used to perform a specific task any number of times. This makes it easier to write SQL statements for a re-occurring task and reusing the saved stored procedure to perform the same task without rewriting the same SQL statements again.
  5. Supports JOIN: SQL supports join which is used to combine the data of two or more tables. This can be useful when we need to perform the operation on multiple tables.
  6. Supports UNION: UNION command can be used to join two or more DQL statement (SELECT statements).
  7. Integration: SQL allows integration to non-SQL database applications as well.
  8. Performance: Better performance even if the database size if huge.
  9. SQL is scalable and flexible.
  10. SQL is secure.
❮ DBMS SQL IntroAdvantages of SQL ❯

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