LESSON PLAN
CLASS : XI SUBJECT : INFORMATICS PRACTICES
TEACHER : ____________________________
BOOK : NCERT CLASS XI INFORMATICS PRACTICES
NAME OF THE CHAPTER : SQL – SELECT Command
Time : 6 PERIODS × 40 mins
Weightage : 8 Marks
1. INTRODUCTION
The SELECT command in SQL is used to retrieve data from one or more tables in a database.
It allows users to specify which columns of data to display, apply conditions using WHERE,
sort data with ORDER BY, and use aggregate functions for summarizing information. This
lesson focuses on developing the ability to write and execute SELECT queries efficiently.
2. LEARNING OBJECTIVES
The students will be able to:
❖ Understand the purpose and syntax of the SELECT command.
❖ Retrieve specific data using column names and filtering conditions.
❖ Use WHERE, ORDER BY, and DISTINCT clauses effectively.
❖ Apply aggregate functions such as COUNT, SUM, AVG, MIN, MAX.
❖ Use logical operators (AND, OR, NOT) in queries.
❖ Retrieve data from multiple tables using simple joins.
3. LEARNING OUTCOMES
Knowledge - The students will learn:
• Structure and syntax of the SELECT statement.
• Use of conditions, sorting, and filtering in data retrieval.
• Application of aggregate functions in queries.
• How to combine multiple conditions using logical operators.
Skills - (21st Century Skills):
• Critical Thinking: Analyze and write queries to retrieve relevant information.
• Creativity: Design meaningful data retrieval tasks from real-world databases.
• Collaboration & Communication: Work in groups to solve SQL query exercises.
• Information Literacy: Research SQL clauses and functions through reliable sources.
• Problem Solving: Debug and optimize queries for efficiency.
4. TEACHING PREPARATIONS REQUIRED BEFORE THE CLASS
• NCERT Textbook
• SQL software (MySQL / SQLite / SQL Fiddle)
• Sample database with student and marks tables
• PowerPoint slides showing SELECT command syntax and examples
5. TEACHING METHODOLOGIES
❖ Lecture method for explaining syntax and structure.
❖ Demonstration through live query execution.
❖ ICT Method: Use of videos and online database simulators.
❖ Self-learning through practice exercises.
6. SPECIFIC METHODOLOGY INCLUDING THE DOL PARAMETERS
• Flipped Classroom: Students explore SELECT basics before class using videos.
• Peer Teaching: Groups create and present their own query problems.
• Differentiated Learning: Simple to advanced level SELECT queries.
• Experiential Learning: Practical execution of SQL queries in lab.
• Scientific Temperament: Analyze results of different queries to verify accuracy.
• Art Integration: Create visual representation (flowchart) of SELECT query structure.
• Critical Thinking: Predict output of given queries before execution.
• Communication: Conduct brainstorming on real-life data applications.
• Self-Learning: Explore SQL documentation and experiment with sample datasets.
7. PREVIOUS KNOWLEDGE
Students are already familiar with the concept of databases and tables, and have basic
understanding of SQL commands like CREATE TABLE and INSERT.
8. FLOW OF THE SESSION
• Introduction to SELECT command and syntax
• Selecting all columns vs. specific columns
• Using WHERE clause for filtering data
• Applying ORDER BY for sorting results
• Using DISTINCT for unique values
• Applying aggregate functions (COUNT, SUM, AVG, MIN, MAX)
• Using logical operators (AND, OR, NOT)
• Practical exercises on real datasets
9. RECAPITULATION
❖ SELECT is used to retrieve data from one or more tables.
❖ WHERE filters records based on specified conditions.
❖ ORDER BY sorts the data in ascending or descending order.
❖ DISTINCT removes duplicate records.
❖ Aggregate functions summarize data.
❖ Logical operators combine multiple conditions in a query.
10. HOME TASK FOR THE CHAPTER
• Write SQL queries to display all columns from STUDENT table.
• Display the names of students with marks greater than 80.
• List all students sorted by their marks in descending order.
• Find the average marks from the table.
• Display distinct city names from the STUDENT table.
11. ASSESSMENT STRATEGIES
• MCQ Worksheet on SELECT syntax and clauses.
• Short answer questions on filtering and sorting.
• Assertion-Reasoning based on query outcomes.
• Case Study: Write SQL queries for given data scenarios.
• Practical Evaluation: Execute and verify SQL queries.
