what sql language 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 basically a programming language that lets people manipulate databases.
Example 3: what sql language
1- Data Manipulation Language(DML)-(SELECT, INSTERT, UPDATE...)
DML statements affect records in table. These are
basic operations we perform on data such as selecting
few records from a table, inserting new records,
deleting unnecessary records, updating existing records.
2-Data Definition Language (CREATE , ALTER , DROP)...
DDL statements are used to modify database or
table schema. These statements handle the design
and storage of database objects.
3-Data Control Language (GRANT , REVOKE)...
DCL statements control the level of access that
users have on database objects
4- Transaction Control Language (BEGIN TRAN, COMMIT TRAN, ROLLBACK)...
TCL statements allows us to control and manage
transactions to maintain the integrity of data
withing SQL statements.
Example 4: how do you use sql
Our web application uses Oracle database and
I normally write queries to do Data validation.
For example:
I create data from UI or I send POST request
from API then I write query to verify that
data was successfully and correctly inserted
into database. Our database consists of
many tables, so most of the time,
I need to write queries that involve joins.
CAN MENTION: Since our application has
large sets of data, data is stored into
Oracle and to another CACHE database.
I write queries to test data that both are in SYNC(same).