What is sql

This article is tagged with: What is sql and mysql

what is sql

Structured Query Language
A language which enables a user to create, modify and
essentially interact with a database.
Two of the most common Database Management Engines are
MySQL: https://www.mysql.com/
PostgreSQL: https://www.postgresql.org/

what is sql

SQL stands for:
Structured Query Language
It's language which enables a user to create,
modify and essentially interact with a database.
As a tester we are usually using Data manipulation
language part of SQL
SQL has 2 parts:
1-DATA MANIPULATION LANGUAGE
It is used to add, retrieve or update the data.
= insert, select, update, delete
2-DATA DEFINITION LANGUAGE
It is used to create database schema and can
be used to define some constraints as well.
=create, alter, drop, truncate
create table
create window etc.

what is sql

SQL is a domain-specific language used in programming and designed for managing
data held in a relational database management system, or for stream processing
in a relational data stream management system.

SQL

CREATE TABLE friends (
id INTEGER,
name TEXT,
birthday DATE
);
INSERT INTO friends (id, name, birthday)
VALUES (1, 'Jane Doe', '1990-05-30');
INSERT INTO friends(id , name , birthday)
VALUES(2 , 'APOORV' , '2000-2-2');
UPDATE friends
SET name = 'Jane Srivastava'
WHERE id = 1;
ALTER TABLE friends
ADD COLUMN email TEXT;
UPDATE friends
SET email = '[email protected]'
where id = 1;
UPDATE friends
SET email = '[email protected]'
where id = 2;
DELETE FROM friends
WHERE id = 1;
SELECT *
FROM friends;

what is sql

SQL is basically a programming language that lets people manipulate databases.

This article is tagged with: What is sql and mysql