TGViewer
Data Analyst Interview Resources Data Analyst Interview Resources @dataanalystinterview ยท 52.6K subscribers
Post #2326 1.43K
โœ… ๐Ÿ”ค Aโ€“Z of SQL Commands ๐Ÿ—„๏ธ๐Ÿ’ปโšก

A โ€“ ALTER
Modify an existing table structure (add/modify/drop columns).

B โ€“ BEGIN
Start a transaction block.

C โ€“ CREATE
Create database objects like tables, views, indexes.

D โ€“ DELETE
Remove records from a table.

E โ€“ EXISTS
Check if a subquery returns any rows.

F โ€“ FETCH
Retrieve rows from a cursor.

G โ€“ GRANT
Give privileges to users.

H โ€“ HAVING
Filter aggregated results (used with GROUP BY).

I โ€“ INSERT
Add new records into a table.

J โ€“ JOIN
Combine rows from two or more tables.

K โ€“ KEY (PRIMARY KEY / FOREIGN KEY)
Define constraints for uniqueness and relationships.

L โ€“ LIMIT
Restrict number of rows returned (MySQL/PostgreSQL).

M โ€“ MERGE
Insert/update data conditionally (mainly in SQL Server/Oracle).

N โ€“ NULL
Represents missing or unknown data.

O โ€“ ORDER BY
Sort query results.

P โ€“ PROCEDURE
Stored program in the database.

Q โ€“ QUERY
Request for data (general SQL statement).

R โ€“ ROLLBACK
Undo changes in a transaction.

S โ€“ SELECT
Retrieve data from tables.

T โ€“ TRUNCATE
Remove all records from a table quickly.

U โ€“ UPDATE
Modify existing records.

V โ€“ VIEW
Virtual table based on a query.

W โ€“ WHERE
Filter records based on conditions.

X โ€“ XML PATH
Generate XML output (mainly SQL Server).

Y โ€“ YEAR()
Extract year from a date.

Z โ€“ ZONE (AT TIME ZONE)
Convert datetime to specific time zone.

โค๏ธ Double Tap for More
  • โค 2
More from @dataanalystinterview
  1. Oct 7, 2026๐— ๐—ฎ๐˜€๐˜๐—ฒ๐—ฟ ๐—ฃ๐—ผ๐˜„๐—ฒ๐—ฟ ๐—•๐—œ ๐—ณ๐—ผ๐—ฟ ๐—™๐—ฅ๐—˜๐—˜! ๐Ÿ”ฅ Learn Power BI through these FREE learninโ€ฆ
  2. Oct 1, 2026๐Ÿ”ฅ Top 10 Theoretical Interview Questions Every Data Analyst Must Prepare ๐Ÿ“Š Data Analystโ€ฆ
  3. Sep 29, 2026๐Ÿš€ Excel Formulas Fundamentals โ€” Part 10 ๐Ÿ“Š Conditional Functions (SUMIF, SUMIFS, COUNTIF,โ€ฆ
  4. Sep 29, 2026๐—™๐—ฅ๐—˜๐—˜ ๐—ฅ๐—ฒ๐˜€๐—ผ๐˜‚๐—ฟ๐—ฐ๐—ฒ๐˜€ ๐—ง๐—ผ ๐—Ÿ๐—ฒ๐—ฎ๐—ฟ๐—ป ๐—”๐—œ ๐—ถ๐—ป ๐Ÿฎ๐Ÿฌ๐Ÿฎ๐Ÿฒ๐Ÿš€ โ€‹ Explore 6 free resourceโ€ฆ
  5. Sep 29, 2026๐Ÿ“Š Tableau Learning Roadmap โ€” Part 2 Connecting to Data Before creating visualizations inโ€ฆ
  6. Sep 28, 2026This is useful when you want to guide someone through an analytical narrative. The Tableauโ€ฆ
Threads Profile ViewerView any public Threads profile without an account.Open ThreadLook โ†’Writing with AI? Make it sound human.Metric37 rewrites AI drafts so they read naturally. Free AI detector, 1,500 words free.Try Metric37 โ†’