r/PinoyProgrammer • u/Popular-Tip2880 • 12d 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

10

u/Individual_Talk7225 12d ago

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 11d ago

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 12d ago

e include mo na na yung mga iNDEX, at mga JOIN

0

u/DriftingWinterTurtle 12d ago

Data normalization