Windows admin part: SELECT NAME

PHYSICAL SCHEMA: which is created by company like logs
LOGICAL SCHEMA: which is created by us

SELECT NAME FROM sys.databases

CREATE DATABASE db_name

CREATE TABLE_NAME ( FIELD_NAME DATA_TYPE IDENTITY(STARTING FROM, INCREASE BY) PRIMARY KEY, )

CREATE TABLE_NAME ( FIELD_NAME DATA_TYPE IDENTITY(STARTING FROM, INCREASE BY) PRIMARY KEY, FIELD_NAME DATA_TYPE FOREIGN KEY REFERENCES TABLE_NAME(PRIMARY KEY_FIELD), )

INSERT INTO tablename (col1, col2) values (column1data, column2data )

UPDATE INTO tablename SET (UpdData) where Col = value

DELETE FROM tablename where col = value;

ALTER TABLE tablename ADD colname data type

ALTER TABLE tablename DROP colname

ALTER TABLE tablename ALTER column colname datatype