Study note for CyberSoft Class

MySQL

Formatter for SQL:

SQL Formatter & Beautifier Online

Create Docker & TablePlus DB

SQL Data Types

Create, Show, Drop Databases

Create, Show, Drop, Rename Tables

CRUD - Create Read Update Delete

CRUD - Create : INSERT

CRUD - READ : SELECT

CRUD - Update : UPDATE

CRUD - Delete : DELETE

String Functions

CONCAT & CONCAST_WS - join 2+ strings into 1

SUBSTRING - work with part of strings

REPLACE - replace parts of strings

REVERSE

CHAR_LENGTH - counts characters in string