NEB Class 12 • Computer Science • DBMS • Concept Guide

SQL Commands & Queries: NEB Class 12 Computer Guide

Master SQL Commands and Queries through clear concepts, representations, a reliable answer method and exam-focused practice.

ConceptsWorked reasoningNEB practice

Core concept

What SQL Commands and Queries means physically

SQL defines, retrieves and changes relational data declaratively. Reliable queries select explicit columns, join through meaningful keys, filter rows before grouping where appropriate and use transactions for related changes.

Logical query stages include FROM/JOIN→WHERE→GROUP BY→HAVING→SELECT→ORDER BY. Aggregate functions summarize groups; NULL requires IS NULL rather than equality.

The institutional reference gives the wider physical model; the CDC curriculum determines the NEB boundary.

Worked checkpoint with interpretation

SELECT course_id,COUNT(*) FROM enrolment GROUP BY course_id HAVING COUNT(*)>10; lists courses with more than ten enrolments.

Do not stop at the number. State what the sign, ratio, spacing, frequency or direction means. A common error is Forgetting a join condition and creating a Cartesian product, using =NULL, updating without WHERE, or selecting ungrouped columns beside aggregates.

NEB answer method

Model → evidence → equation → check

First identify the system and what the question asks. Label the diagram, apparatus or reaction with SI quantities, then state the principle before selecting an equation. Solve symbolically where possible and check units, limiting cases and chemical or physical meaning.

Stage	Question	Evidence
Model	What is idealised?	Assumption stated
Representation	Which diagram fits?	Labels or balanced equation
Calculation	Which relation follows?	Symbols then SI values
Evaluation	Does it make sense?	Unit, sign and trend check

Make the idea concrete in Nepal

Connect the model to a school laboratory, household technology, health, environment, energy or local material. The example should clarify the science rather than merely mention a place. Compare a prediction with an observation and record uncertainty.

Review the NEB Class 12 Computer Science revision roadmap and the complete Computer Science guide. For online or physical tuition, call 9846662070.

Frequently asked questions

Questions students ask about SQL Commands and Queries

What is the central idea of SQL Commands and Queries?+

Which equation should I remember?+

Logical query stages include FROM/JOIN→WHERE→GROUP BY→HAVING→SELECT→ORDER BY. Aggregate functions summarize groups; NULL requires IS NULL rather than equality.

How should I begin a numerical?+

Draw the situation, list known quantities in SI units, choose the governing relation symbolically, substitute once and finish with a unit and reasonableness check.

What is a common exam mistake?+

Forgetting a join condition and creating a Cartesian product, using =NULL, updating without WHERE, or selecting ungrouped columns beside aggregates.

How can I practise this topic?+

Alternate one concept explanation, one diagram and two numericals. Revisit errors after a day instead of only rereading the solution.

Where can I get tuition support?+

For online or physical KTM Tuition classes, call 9846662070. After Grade 12, the MKS Education panel below gives preparation and pre-counselling contacts.

References and next steps

Scope checked against CDC Nepal; concept support from an institutional reference and OpenStax Science. Continue with the SQL Commands and Queries cluster.

Continue planning