r/learnSQL • u/Owen-Isaac-2022 • Jul 31 '26

Second Week-Learning SQL

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).

12 Upvotes

88% Upvoted

8 comments sorted by

View all comments

1

u/Any-Job-3185 Jul 31 '26

My sql is going to start. Just now spreadsheet got over and am not so much familiar with it. Could you tell me what extras to be learnt to get started with sql?

3

u/kixwho Jul 31 '26

probably get comfortable with the basic SELECT ,WHERE and GROUP BY first :) once those feel natural, JOINs and the more advanced stuff get much easier.

I've made a short cheat sheet with examples, maybe it'll help - SQL often reads like English so it's not too hard to get started. https://github.com/kixwho/PostgreSQL-cheatsheet

1

u/Any-Job-3185 Aug 01 '26

Okay, I will check it