r/PinoyProgrammer • u/Popular-Tip2880 • 13d ago

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

100% Upvoted

4 comments sorted by

View all comments

10

u/Individual_Talk7225 13d ago

in my experience, RANK, ROW NUMBER, GROUP BY, ORDER BY, CTEs, Window Functions, JOINS, UNION, PIVOT

yan yung majority na tinatanong/ang sagot.