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 SQL

By Chaitanya Singh | Filed Under: DBMS

Structured Query Language, popularly known as SQL is a domain specific language used to manage data in relational database management systems (RDBMS).

  • It allows the user to perform operations such as create, delete etc. on tables in database
  • It also allows operations such as read, insert, update, delete etc. on the data stored in the tables.
  • All popular relational database management softwares such as MySQL, PostgreSQL, Oracle, Microsoft Access, IDBM Db2, SQLite etc. use SQL to manage the database.
  • SQL is a simple english like language which is used to query the database to perform various operations on the database.

Rules for a Better SQL Schema

  1. Only use lowercase letters, numbers and underscores for database, schema, column and table name.
  2. Use simple & meaningful, table and column name. This is because sometimes, we refer the attribute of a table from another table as foreign key.
  3. SQL is not a case sensitive language, however the keywords used in the SQL query are generally written in uppercase.
  4. Using SQL queries you can perform various operations on the database.

SQL Processing

  • When a SQL statement executes, system first performs various checks such as syntax check, semantic check, shared pool check on the SQL query during parsing phase.
  • In the second phase, which is also known as hard parsing phase, system performs query optimization and generate various execution plans.
  • In the next phase, row source generator software receives the optimal execution plan and generate a iterative plan that is used by the database.
  • Last step is execution of the query based on the iterative plan generated in the previous step.
DBMS SQL
❮ Cluster File OrganizationSQL Characteristics ❯

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