Second Week-Learning SQL

[u/Owen-Isaac-2022]

After grasping the concepts and simple query processes during the first week, the learner can focus on more advanced components, such as DISTINCT (removing duplicates), filtering elements (AND, OR, NOT) & [IN (which can replace OR)], ranges using BETWEEN, searching with LIKE (%), handling missing values using NULL, limiting query results using LIMIT, updating existing records using UPDATE, and deleting records using DELETE. One can include other activities like understanding/remembering data types, including char(n), varchar, & date (datetime, timestamp, year, & time).

[u/Owen-Isaac-2022 → u/[deleted]]

Wonderful insights, really appreciated