dbms sql w3schools code example
Example 1: what is SQL
SQL full form is a structured query language, and it allows you to interact through commands with the database. Here are some of the SQL Database functions:
This allows users to retrieve information from the relational database.
It enables the development of tables and databases.
It allows data base and tables to be modified, added, removed, and changed.
It gives protection, and allows permission to be set.
Allows new ways for people to manage the info.
Example 2: 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.