Database Querying using MySQL 1 Shot | MySQL class 12 ip | CBSE Class 12 Informatics Practices

Описание: Database Querying using MySQL 1 Shot | MySQL class 12 ip | CBSE Class 12 Informatics Practices

In this video, I have explained the complete Chapter Database Querying using SQL of Unit 3, for CBSE Class 12 Informatics Practices students.

Install MySQL :    • How to Download MySQL in Windows 10 | Mysq...  

Topics covered in this video:
01:11 - Introduction
01:30 - File Management System
06:03 - Database
06:31 - DBMS (Database Management System)
08:19 - RDBMS and its Terminologies
13:13 - Keys (Primary Key, Candidate Key, Alternate Key, Composite Primary Key and Foreign Key)
26:28 - Starting MySQL Commands
27:30 - Show Databases
28:00 - Create Database
28:44 - Use Database
29:08 - Show Tables
29:59 - Creating a Table
33:20 - Describe Table
34:36 - Inserting Values
41:22 - Select Command
43:07 - Where Clause
50:56 - Column Alias
51:51 - Distinct Command
52:30 - Between and Not Between Operator
55:10 - In and Not In
56:33 - Like and Not Like
1:00:50 - IS NULL and IS NOT NULL
1:02:24 - Alter Command
1:08:21 - Update Command
1:11:51 - Delete Command
1:13:21 - Drop Command
1:13:36 - Order By
1:15:08 - Group By, Having Clause and Aggregate Functions
1:25:46 - DDL and DML Commands
1:29:37 - Cartesian Product, Equi Join and Natural Join
1:44:07 - Math Functions
1:46:04 - Text Functions
1:53:46 - Date & Time Functions

📘🚀🚀 Class 12 IP – Chapter wise Notes & PYQs 🚀🚀
💰🤑SPECIAL DISCOUNT OFFER DURING EXAM DAYS 💰🤑
Access available till board exams only (Read-Only PDF)
🔗👉🏻Buy here : https://rzp.io/rzp/12IPBoards


PLAYLISTS LINKS

🌟IP Spark Series (Boards 2026)
   • IP Spark Series (BOARDS 2026)  

🌟Class XII - Informatics Practices (065)
   • Class 12 - Informatics Practices (065)  

You can join the Telegram Channel for all the updates..
🌟🌟🌟🌟🌟🌟🌟🌟🌟🌟🌟🌟🌟🌟🌟🌟
Social Handles.. (Please Subscribe and Follow)
📕YouTube Channel:    / swatichawlaofficial  
🌐Instagram:   / swatichawla.  .
💠Facebook:   / swatichawlao.  .
🥏Telegram Channel for Class 12 Computer Science: https://t.me/swatichawla12cs
🥏Telegram Channel for Class 11 and 12 Informatics Practices: https://t.me/swatichawla12ip
🥏Telegram Channel for Class 11 Computer Science: https://t.me/swatichawla11cs
🥏Telegram Channel for Class 10 Information Technology and Artificial Intelligence: https://t.me/swatichawla10it
🥏Telegram Channel for Class 9 Information Technology: https://t.me/swatichawla9it