Scribd
Upload
22 views5 pages

CBSE Class 12 SQL Guide 2026

The document is a comprehensive SQL guide for Class 12 CBSE Computer Science students, covering essential SQL statements, examples, and outputs. It includes a one-page revision sheet detailing DDL, DML, DQL, aggregate functions, and constraints, as well as multiple-choice questions for practice. Additionally, it maps the syllabus for the 2026 exam, highlighting relevant units and practical applications.

Uploaded by

ahmadmusfir1978
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
22 views5 pages

CBSE Class 12 SQL Guide 2026

The document is a comprehensive SQL guide for Class 12 CBSE Computer Science students, covering essential SQL statements, examples, and outputs. It includes a one-page revision sheet detailing DDL, DML, DQL, aggregate functions, and constraints, as well as multiple-choice questions for practice. Additionally, it maps the syllabus for the 2026 exam, highlighting relevant units and practical applications.

Uploaded by

ahmadmusfir1978
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Class 12 CBSE Computer Science (2026) Complete

SQL Guide

1. Exam-Oriented SQL Statements (CBSE)


1 CREATE TABLE Student (Roll INT PRIMARY KEY, Name VARCHAR(20));
2 INSERT INTO Student VALUES (1, 'Ali');
3 SELECT * FROM Student WHERE Roll=1;
4 UPDATE Student SET Name='Ayaan' WHERE Roll=1;
5 DELETE FROM Student WHERE Roll=1;
2. SQL with Examples & Output
Example Table: Student
Roll Name Marks
1 Ali 85
2 Sara 92

Query: SELECT Name FROM Student WHERE Marks > 90;


Output: Sara
3. One-Page SQL Revision Sheet
1 DDL → CREATE, DROP, ALTER, TRUNCATE
2 DML → INSERT, UPDATE, DELETE
3 DQL → SELECT
4 Aggregate → COUNT, SUM, AVG, MIN, MAX
5 Constraints → PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL
4. MCQs & SQL Practice
1 Q1. Which command removes all records but not table structure? → TRUNCATE
2 Q2. Which clause is used with GROUP BY? → HAVING
5. CBSE 2026 Syllabus Mapping
1 Unit 4 → Relational Database Concepts
2 Unit 5 → SQL Commands
3 Practical → SQL Queries & Output

You might also like