1Structured Query Language
2
3A language which enables a user to create, modify and
4essentially interact with a database.
5Two of the most common Database Management Engines are
6MySQL: https://www.mysql.com/
7PostgreSQL: https://www.postgresql.org/
1SQL 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:
2
3This allows users to retrieve information from the relational database.
4It enables the development of tables and databases.
5It allows data base and tables to be modified, added, removed, and changed.
6It gives protection, and allows permission to be set.
7Allows new ways for people to manage the info.
1SQL is a domain-specific language used in programming and designed for managing
2data held in a relational database management system, or for stream processing
3in a relational data stream management system.
1SQL stands for:
2Structured Query Language
3
4It's language which enables a user to create,
5modify and essentially interact with a database.
6As a tester we are usually using Data manipulation
7language part of SQL
8
9SQL has 2 parts:
101-DATA MANIPULATION LANGUAGE
11It is used to add, retrieve or update the data.
12= insert, select, update, delete
13
142-DATA DEFINITION LANGUAGE
15It is used to create database schema and can
16be used to define some constraints as well.
17=create, alter, drop, truncate
18
19create table
20create window etc.