SIGN IN YOUR ACCOUNT TO HAVE ACCESS TO DIFFERENT FEATURES

FORGOT YOUR PASSWORD?

FORGOT YOUR DETAILS?

AAH, WAIT, I REMEMBER NOW!
Openbaraza

Openbaraza

Openbaraza

Baraza is a Swahili word that means a deliberation meeting held by a collective group of people with wisdom.

T : +254 (20) 2243097 / 2227100
Email: info@openbaraza.org

OPENBARAZA
Dew CIS Solutions LTD Barclays Plaza, 12th Floor. Loita Street.

Open in Google Maps
  • Framework
  • Projects
    • Human Resource
      • Human Resource
      • Time Attendance
      • Project Planning
    • Finance Management
      • Business
      • Payroll
    • Investment Management
      • Banking
      • Chama
      • Sacco
    • Case Management
      • Judiciary
    • Real Estate Management
      • Property
    • Academic Management
      • UMIS
      • Schools
  • Forums
    • HCM HR Payroll
    • Business
    • Sacco
    • Banking
  • Blog & News
    • OpenBaraza Framework
    • Databases
    • Java Programming
    • Scrum
  • Contact Us

Structured Query Language -(SQL)

by dennis@dennis.me.ke / Monday, 26 November 2018 / Published in Databases

By now it’s probably pretty clear what the SQL language is and what it does. But for the fun of theoretical intellect let do a quick run through of few things. The SQL is a language to used operate and manipulate databases; some of the functions include database creation, deletion, fetching rows and columns, modifying rows, etc.

What is SQL?

First things first, what is SQL ? Well SQL stands for Structured Query Language, which is a computer language for storing, manipulating and retrieving data stored in a relational database. So basically is a language that was developed explicitly for databases, which is pretty neat considering not even a whole country can say they have their own personal language.
All the Relational Database Management Systems (RDMS) like MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server use SQL as their standard database language.
Just like any other widely used language, SQL has different dialects, such as −
• MS SQL Server using T-SQL,
• Oracle using PL/SQL,
• MS Access version of SQL is called JET SQL (native format) etc.

Why SQL?

SQL is widely popular because it offers the following advantages −
• Give the users the capability to access and manipulate data in the relational database management systems.
• Allows users to define the database and manipulate its structure.
• It can be embedded within other languages using SQL modules, libraries & pre-compilers.
All this without having to spend hours burying one’s self in books trying to learn it, SQL has a vast pool of readily available information on the web.

A Brief History of SQL

• 1970 − Dr. Edgar F. “Ted” Codd of IBM who is known as the father of relational databases, describes a relational model for databases.
• 1974 − Structured Query Language appeared.
• 1978 − System/R is released by IBM after they worked to develop Dr. Codd’s idea.
• 1986 − IBM developed the first prototype of relational database and standardized by ANSI. The first relational database was released by Relational Software which later came to be known as Oracle.

SQL Process

When you are executing an SQL command for any RDBMS, the system does most of the heavy lifting so you don’t have to. It determines the best way to carry out your request and SQL engine figures out how to interpret the task.
There are various components included in this process.
These components are −
• Query Dispatcher
• Optimization Engines
• Classic Query Engine
• SQL Query Engine, etc.
A classic query engine handles all the non-SQL queries, but a SQL query engine won’t handle logical files.

SQL Commands

The standard SQL commands to interact with relational databases are CREATE, SELECT, INSERT, UPDATE, DELETE and DROP. These commands can be classified into the following groups based on their nature −

DDL – Data Definition Language

Used to create and modify the structure of database objects in a database.

DML – Data Manipulation Language

Used for adding (inserting), deleting, and modifying (updating) data in a database

DCL – Data Control Language

Used to control access to data stored in a database.

Let’s show this practically:

Create command
CREATE TABLE customers (
customer_id serial primary key,
customer_name varchar(50) not null,
details text
);

Insert command
INSERT INTO customers (customer_id, customer_name) VALUES
(1, 'Mary'),
(2, 'Joyce'),
(3, 'Esther');

Select command
SELECT from customers where customer_name = ‘Lisa’;


Delete command
Delete from customers where customer_name = ‘Lisa’;


Update command
UPDATE customers
set customer_name = ‘Musa’
where customer_id = 1;

1
  • Tweet

About dennis@dennis.me.ke

What you can read next

Operations Of a Database
Introduction to Databases

Leave a Reply Cancel reply

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

Recent Posts

  • 08. BODMAS IN JAVA

  • 07. JAVA ARRAYS: Store Student Details Using Arrays and List

  • 06. Classes: Store Student Details Using Json Format

  • 02. SPRINT RETROSPECTIVE

  • 01. SCRUM (DEMO)

Categories

  • Databases
  • Java Programming
  • OpenBaraza Framework
  • Scrum

QUICK LINKS

  • Home
  • Our Stories
  • Contact Us
  • Terms and Conditions
  • Our Policy

VISIT US

Open Baraza
Barclays Plaza, 12th Floor.
Loita Street, Nairobi.

Open in Google Maps

GET IN TOUCH

Tel: +254 (20) 2243097 / 2227100
     +254(726)209214, +254(738)819505
Email: info@openbaraza.org

Follow Us

over a year agoRT @dewcis: Manage your HR,Payroll and Time attendance with just a click of a button with our Easy to use Baraza Human Capital Management(H…
over a year agoInstalling Java Development Kit(JDK) Tutorial #Java #javascript" title="https://t.co/a2K2VzYhYq #Java #javascript" target="_blank">https://t.co/a2K2VzYhYq #Java #javascript
over a year agoNew Blog alert #java#arrays" title="https://t.co/EBDMlqL2Kq #java#arrays" target="_blank">https://t.co/EBDMlqL2Kq #java#arrays #classes
over a year agoAre you a fresh university graduate with a computer related degree and interested in being a software developer or… https://t.co/94CzteMjLq
over a year agoCheck out our new blog on operators #operators #codinglife" title="https://t.co/vOcebUw1xI #operators #codinglife" target="_blank">https://t.co/vOcebUw1xI #operators #codinglife
over a year agoLearning Java language on windows #Windows" title="https://t.co/HfsLDSWcVP #Windows" target="_blank">https://t.co/HfsLDSWcVP #Windows #Java #javascript #codinglife
over a year agoRT @dewcis: Fair Trade Software Foundation (FTSF) is venturing into a new cooperative enterprise named workpamoja. As part of the initiativ…
over a year agoWhat is SQL? Why SQL? SQLProcess? This are some the question our continuing database series article will be answeri… https://t.co/HgiUf3XwYz
over a year agoAs businesses grow, there is a need for the business owners to embrace emerging technologies. Check out our continu… https://t.co/Vq6gaF3n1o
over a year agoLike storage boxes, a database is an arranged chest of tables and columns that hold information. Check our our late… https://t.co/krRINpg03x
Follow @openbaraza
  • GET SOCIAL
Openbaraza

© All rights reserved | Open Baraza developed by DewCis Solutions.

TOP