SQL DBS code example

Example 1: 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.

Example 2: 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.

Tags:

Sql Example