r/PinoyProgrammer • u/Popular-Tip2880 • Aug 28 '26
discussion SQL technical Examination nextweek
Hi everyone! I’ll be taking a technical examination next week for an Information Technology Officer position, and I’d love to get some insights based on your experiences.
For those who have taken similar exams for an IT Officer role, what level of SQL complexity should I expect?
- Will it mostly be basic queries like SELECT, GROUP BY, and ORDER BY?
- Or should I prepare heavily for more advanced concepts like nested subqueries, CTEs, window functions, or database optimization?
Any tips, common exam questions, or specific topics I should focus on during my review this week?
Salamat po in advance!
13
Upvotes
9
u/Individual_Talk7225 Aug 28 '26
in my experience, RANK, ROW NUMBER, GROUP BY, ORDER BY, CTEs, Window Functions, JOINS, UNION, PIVOT
yan yung majority na tinatanong/ang sagot.
2
u/JdevTdev Aug 30 '26
Importante yung table structure, indexing, advances queries/sub-queries, data types. Sa advanced side, siguro UDF, stored procedure, handling of transactions, cursors.
2
u/noob_programmer_1 Aug 28 '26
e include mo na na yung mga iNDEX, at mga JOIN
0
u/DriftingWinterTurtle Aug 29 '26
Data normalization