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 stands for Structured Query Language. It’s the language of choice on today’s web for storing,
2manipulating and retrieving data within relational databases. Most, if not all of the websites you visit
3will use it in some way.
4Using SQL, you are able to interact with the database by writing queries, which when executed,
5return any results which meet its criteria.
1CREATE TABLE friends (
2 id INTEGER,
3 name TEXT,
4 birthday DATE
5);
6
7INSERT INTO friends (id, name, birthday)
8VALUES (1, 'Jane Doe', '1990-05-30');
9
10
11INSERT INTO friends(id , name , birthday)
12VALUES(2 , 'APOORV' , '2000-2-2');
13
14
15
16UPDATE friends
17SET name = 'Jane Srivastava'
18WHERE id = 1;
19
20ALTER TABLE friends
21ADD COLUMN email TEXT;
22
23
24UPDATE friends
25SET email = '203029@klsafjls'
26where id = 1;
27
28UPDATE friends
29SET email = '203029@klsafjls'
30where id = 2;
31
32DELETE FROM friends
33WHERE id = 1;
34
35
36SELECT *
37FROM friends;
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.