Scribd
Upload
4 views2 pages

LP 5SQL Coding Practice

The lesson plan outlines a hands-on coding practice session focused on SQL for the 2025 UG Batch at Amrita Vishwa Vidyapeetham, Kochi Campus. Students will learn to solve SQL problems using DDL and DML queries, with a focus on SELECT, JOIN, and GROUP BY. The session includes practical exercises, group discussions, and a home assignment to reinforce learning.

Uploaded by

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

LP 5SQL Coding Practice

The lesson plan outlines a hands-on coding practice session focused on SQL for the 2025 UG Batch at Amrita Vishwa Vidyapeetham, Kochi Campus. Students will learn to solve SQL problems using DDL and DML queries, with a focus on SELECT, JOIN, and GROUP BY. The session includes practical exercises, group discussions, and a home assignment to reinforce learning.

Uploaded by

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

Amrita Vishwa Vidyapeetham

Kochi Campus

LESSON PLAN
Course : 2025 UG Batch

Semester : Semester 4

Batches : INTMCA

Subject : Technical Training

Lesson Name : Hands-on Coding Practice – SQL

No Sessions :1

Instructor : Vidya Gopinath

Objective:

This session involves solving SQL problems using DDL and DML queries. Students will gain
experience with SELECT, JOIN, GROUP BY, and filtering data.

1. Training Infrastructure

SI No Resources Required Location


1 Computer Lab, Internet CIR Labs
2 Whiteboard, Projector Classroom / Lab
2. Bibliography

SI No References Chapter/Section Page No


1 LeetCode / Topic-specific –
PrepInsta / Questions
W3Schools
2 GeeksforGeeks / Concept –
TutorialsPoint Explanations
3. Pre-requisite Knowledge

Students should have attended relevant foundational sessions (Python/SQL/DBMS/Java).

4. Training Methodology

SI No Methodology Training Aids


1 Hands-on Practice or IDE / SQL Tool / Slides
Quiz/Test
2 Concept Review and Whiteboard, Projector
Debugging
5. Introduction

This session will cover the core ideas and techniques relevant to Hands-on Coding Practice
– SQL as required in technical placements.

6. Lesson Coverage (In Sequence)

1. Concept Overview
2. Demonstration / Examples
3. Practice Task / Quiz
4. Group Discussion

7. Summary and Conclusion

By the end of the session, students will be able to apply the discussed topic confidently in
interviews.

8. Questions to the Class (To Check Assimilation)

1. What is the real-world relevance of today’s topic?


2. What type of questions are expected?
3. Share an example.

9. Home Assignment

Complete 2–3 practice questions on the session topic and submit code/output with
explanation.

Prepared by: Vidya Gopinath

Checked by: –

Approved by: N R Mohanan

Review

Date Instructor Comments


Head – L&D’s Remarks

Director’s Remarks

You might also like