Class 12 IP Unit 2 Database Query Using SQL | One Shot | Math,Text,Date,Aggregate Functions |2025-26
Hamari Academy | By Yogendra Sir
0:00 / 0:00
Class 12 IP Unit 2 Database Query Using SQL | One Shot | Math,Text,Date,Aggregate Functions |2025-26
253 176 просмотров · 4 года назад
Hamari Academy | By Yogendra Sir
11,3 тыс. подписчиков
253 176 просмотров · 4 года назад
📘 *Class 12 IP | Unit 2: Database Query Using SQL | One Shot | Math, Text, Date, Aggregate Functions | CBSE 2025-26*
Welcome to *Hamari Academy**! In this **One Shot Crash Course**, Yogendra Sir covers **Unit 2: Database Query Using SQL* for **Class 12 Informatics Practices (IP)**, as per the **CBSE 2025-26 syllabus**.
🔑 *Topics Covered in This Video:*
**SQL Query Basics**: SELECT, WHERE, and basic operations
**Mathematical Functions in SQL**: SUM, AVG, COUNT, etc.
**Text Functions**: CONCAT, LENGTH, UPPER, LOWER
**Date Functions**: YEAR, MONTH, DAY, NOW()
**Aggregate Functions**: GROUP BY, HAVING, COUNT, MAX, MIN
⏱️ *Timestamps:*
00:00 - Introduction to SQL Queries
02:00 - SQL Query Basics (SELECT, WHERE)
05:00 - Mathematical Functions in SQL (SUM, AVG, COUNT)
09:00 - Text Functions in SQL (CONCAT, LENGTH)
12:30 - Date Functions in SQL (YEAR, MONTH, NOW())
16:00 - Aggregate Functions (GROUP BY, COUNT, MAX, MIN)
20:00 - Practical Examples and Tips
📂 *Useful Resources:*
▶️ **Full Class 12 IP Playlist**:
[ • Class 12 IP Informatics Practices Full Syl... ]( • Class 12 IP Informatics Practices Full Syl... )
▶️ **Class 12 IP Revision Playlist**:
[ • Class 12 Informatics Practices (IP) Revisi... ]( • Class 12 Informatics Practices (IP) Revisi... )
▶️ **Class 12 IP/CS Sample Paper Solved Playlist**:
[ • CBSE Class 12 Computer Science Sample Pape... ]( • CBSE Class 12 Computer Science Sample Pape... )
📱 **Join the Telegram Channel for More Resources**:
[https://t.me/ipcsbyyogendrasir](https://t.me/ipcsbyyogendrasir)
👍 *Like, Comment, and Subscribe* to *Hamari Academy* for more 2025-26 CBSE updates.
📝 *Need Notes or Have Questions?*
Drop a comment below, and Yogendra Sir will be happy to help!
🔔 *Stay tuned for more amazing content for the CBSE 2025-26 session!*
#HamariAcademy #Class12IP #CBSE2025 #InformaticsPractices #SQLQueries #DatabaseQueries #AggregateFunctions #MathFunctions #TextFunctions #DateFunctions