Cyber Security | Web Development

  SQL _Queries   Resource: https://balanced-quince-db1.notion.site/SQL-7347f5956fe347f887b4132c716cd236#17bc403a1add453db519621da47c1de3 Database queries CREATE DATABASE LOGICFIRST; -- creates a new database -- TO DELETE A DATABASE DROP DATABASE LOGICFIRST; DROP SCHEMA LOGICFIRST; -- same as above. u can use DATABASE Or SCHEMA DROP SCHEMA IF EXISTS LOGICFIRST; -- prevents error if db not found   SHOW DATABASES; -- shows all the databases SHOW SCHEMAS; -- same as above. shows schemas/db   USE SYS; -- uses this database for all further commands SHOW TABLES;-- shows all tables in the database being used Table - Create,Delete,Alter primary key - uniquely identifies a row in a table //creating a table CREATE TABLE student(                id INT PRIMARY KEY,     name VARCHAR(30),     gpa DECIMAL(3,2) ); -- ----or----- CREATE TABLE student(                id INT,     name VARCHAR(30),     gpa DECIMAL(3,2),     PRIMARY KEY(id) );  

Linux commands   chmod => change mode RWX R = Read => 4 W = Write => 2 X = Execute => 1 Three types of groups User Group Other I give the owner(User) permission to all access file or directory drwx------ In linux command #chmod 7 00 filename.txt I give members of the group(Group) to access only read and execute drwxr-x--- In Linux command #chmod 7 5 0 filename.txt I give the public access(Other) only read drwxr-xr--- In linux command #chmod 75 4 filename.txt