Structured Query Language
Class 12 Computer Science Interactive Learning Workbook: Master SQL fundamentals, DDL vs DML commands, data types (CHAR, VARCHAR, INT, FLOAT, DATE), constraints (NOT NULL, UNIQUE, PRIMARY KEY), table management (CREATE, DESCRIBE, ALTER, DROP), data retrieval (SELECT, DISTINCT, aliases), filtering (WHERE, IN, BETWEEN, LIKE), NULL handling, data modification (UPDATE, DELETE), sorting (ORDER BY), aggregate functions (MAX, MIN, AVG, SUM, COUNT), GROUP BY, HAVING, and multi-table joins (Cartesian Product, Equi-Join, Natural Join) across 9 structured modules.
Course Chapters & Learning Modules
Total 9 interactive modules with guided checkpoint challenges.
Module 1: SQL, Databases, DDL and DML
Understand the purpose of Structured Query Language (SQL), differentiate Data Definition Language (DDL) from Data Manipulation Language (DML), and master SQL command syntax.
Module 2: Data Types, Constraints and Creating Databases
Master SQL data types (CHAR, VARCHAR, INT, FLOAT, DATE), implement table constraints (NOT NULL, UNIQUE, PRIMARY KEY), and manage databases with CREATE, USE, SHOW, and DROP.
Module 3: Create, Describe, Alter and Drop Tables
Build table structures using CREATE TABLE, inspect schemas with DESCRIBE and SHOW TABLES, modify structures using ALTER TABLE (ADD/DROP COLUMN/PRIMARY KEY), and remove tables using DROP TABLE.
Module 4: Insert, Select, Aliases and DISTINCT
Populate tables using INSERT INTO, query data using SELECT projections, format column headers using AS aliases, and eliminate duplicate result rows using DISTINCT.
Module 5: WHERE, Operators, IN, BETWEEN and LIKE
Filter query results using the WHERE clause: apply relational and logical operators, match lists with IN, evaluate inclusive ranges with BETWEEN, and perform pattern matching with LIKE wildcards (% and _).
Module 6: NULL, IS NULL, UPDATE, DELETE and ORDER BY
Handle missing data using NULL and IS NULL/IS NOT NULL, modify records safely with UPDATE, remove rows with DELETE, and sort output using ORDER BY (ASC/DESC).
Module 7: Aggregate Functions and Grouping
Summarize data using SQL aggregate functions (MAX, MIN, AVG, SUM, COUNT), group rows by category using GROUP BY, and filter group summaries using HAVING.
Module 8: Joins: Cartesian Product, Equi-Join and Natural Join
Combine data across multiple relations: understand Cartesian Product (Cross Join), master Equi-Joins using explicit primary/foreign key equality conditions, and explore Natural Joins.
Module 9: SQL Practice Lab: Read a Query and Check It
Synthesize full SQL query architecture: compose clauses in standard order (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY), review safe database habits, and master the comprehensive Checkpoint Exam.
Learn With Pragati AI Today
Adopt your interactive companion, write live code, and earn verifiable school credentials.