Skip to main content
Super TutorResources
Chapter 1 of 7
Syllabus

Querying and SQL Functions — Syllabus

CBSE · Class 12 · Informatics Practices

What Querying and SQL Functions covers in CBSE Class 12 Informatics Practices: 4 topics, for the 2026-27 session.

111 questions84 flashcards4 formulas & key relations5 concepts

Interactive on Super Tutor

Studying Querying and SQL Functions? Get the full interactive chapter.

Quizzes, flashcards, AI doubt-solver and a step-by-step study plan — built for syllabus and more.

Try Super Tutor — Free

Free trial, no card needed.

4 Topics · CBSE Class 12 Informatics Practices · 2026-27

Topics in Querying and SQL Functions

1

1. SQL Functions

  • SQL functions are categorised into Single row functions and Aggregate functions based on whether they act on one or multiple rows.
  • Single row functions are also known as Scalar functions.
  • Single row functions can be used in SELECT, WHERE, and ORDER BY clauses.
2

2. String and Date Functions

  • UCASE or UPPER converts a string into uppercase.
  • LOWER or LCASE converts a string into lowercase.
  • MID, SUBSTRING, and SUBSTR return a substring from a given position.
3

3. Aggregate Functions and GROUP BY

  • MAX returns the largest value from a specified column.
  • MIN returns the smallest value from a specified column.
  • AVG returns the average of values in a specified column.
4

4. Operations on Relations

  • UNION, INTERSECT and MINUS are binary operations on relations.
  • These operations work only when both relations have the same number of attributes and matching domains on corresponding attributes.
  • UNION combines selected rows of two tables and removes duplicates that appear in both tables.

Key Concepts

Central concept: SQL querying with functions, grouping, set operations, and joins

SQL FunctionsSingle Row FunctionsAggregate FunctionsGROUP BY and HAVINGOperations on RelationsUsing Two Relations in a QueryCARSHOWROOM DatabaseSchoolUniform Database Example

Work through every topic in Querying and SQL Functions with notes and quizzes

Start This Chapter

Frequently Asked Questions

What are the important topics in Querying and SQL Functions for CBSE Class 12 Informatics Practices?
Key topics in Querying and SQL Functions include SQL Functions, String and Date Functions, Aggregate Functions and GROUP BY, Operations on Relations. Study these first, then practise questions on each for the CBSE Class 12 board exam.
How should I revise Querying and SQL Functions for the CBSE Class 12 board exam?
Learn the core ideas first, then work through the 111 practice questions on Querying and SQL Functions. Revise definitions regularly and use flashcards for quick recall before the exam.

Sources & Official References

Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.

More resources for Querying and SQL Functions

All CBSE Class 12 Informatics Practices Syllabus

For serious students

Get the full Querying and SQL Functions chapter — start free.

Quizzes, flashcards, an AI doubt solver and a study plan for CBSE Class 12 Informatics Practices. Free to start, no card needed.

Try Super Tutor Free
Try this chapter free