sql

Question 1

What are database languages?

Answer 1

Languages that allow databases to complete operations
Use DDL (data description language) or
DML ( data manipulation language)

Question 2

What is CRUD?

Answer 2

Create (insert new data)
Read (read and query data)
Update (modify)
Delete (delete unneeded data)

Question 3

What is SQL?

Answer 3

A declarative language designed for relational databases to create, modify, drop, insert, update, delete and select

Question 4

table formatting for creating tables?

Answer 4

CREATE TABLE table1_name
(
column1 dataType [CONSTRAINT],
**
PRIMARY KEY (column1_name),
FOREIGN KEY (column1_name) REFERENCES (table2_name) (column_name),
UNIQUE (column_name),
);
unique is for all values needed as unique
primary key can be multiple so can list

Question 5

What is the insert formula?

Answer 5

INSERT INTO tableName
(column1, column2, … , columnN)
VALUES (value1, value2, … , valueN);

Question 6

What is the select formula?

Answer 6

SELECT (attribute1, attribute2, attributeN)
FROM (table1, table2, tableN)
WHERE [Condition];