Important Questions of MYSQL | MYSQL Commands | Class 12 Computer Science Python
ฝัง
- เผยแพร่เมื่อ 24 ก.ย. 2024
- Important Questions of MYSQL | MYSQL Commands | Class 12 Computer Science Python
MYSQL
Database Concepts: Introduction to database concepts and its need. Relational data model: Concept of domain, relation, tuple, attribute, degree, cardinality, key, primary key, candidate key, alternate key and foreign key.
• Database | Relational ...
Introduction of MYSQL, Features, MYSQL v/s SQL, DDL and DML Commands
• MYSQL | Difference bet...
Download and Install MYSQL Server (Complete Step - by - Step Guide)
• How to Download MySQL ...
MYSQL Commands
Create Database, Use Database, Show Databases, Show Tables, Create Table, char v/s varchar , data types in MYSQL (PART-1)
• MYSQL COMMANDS (Part -...
Desc Command, Insert Into and Select Command (PART-2)
• MYSQL COMMANDS (PART- ...
WHERE Clause, Relational Operators, Logical Operators, Putting Text in Query, Scalar Expressions (PART - 3)
• MYSQL COMMANDS (PART 3...
DISTINCT BETWEEN NOT BETWEEN IS NULL IS NOT NULL LIKE NOT LIKE (PART-4)
• MYSQL COMMANDS (PART-4...
ALTER , UPDATE , DELETE , DROP Commands (PART-5)
• MY SQL COMMANDS (PART-...
Aggregate Functions (PART-6)
• AGGREGATE FUNCTIONS | ...
Order By , Group By , Having Clause (PART-7)
• MYSQL COMMANDS (PART-7...
Joins in MYSQL (Equi Join Natural Join) (Part - 8)
• JOINS IN MYSQL | EQUI ...
Important Question of MYSQL (Part - 1)
• IMPORTANT QUESTIONS OF...
Important Questions Of MYSQL (Based On Two Tables) - (Part - 2)
• IMPORTANT QUESTIONS OF...
Constraints in MYSQL
• CONSTRAINTS IN MYSQL |...
1 Shot Video of MYSQL
• Database and MySql Cla...
Join this channel to get access to perks:
/ @swatichawlaofficial
YT 1k Sub.
• Thank You my Viewers (...
Channel Trailer video
• Check it out !!! What ...
random module
• random module
Mathematical and String Functions
• Playlist
Using Python Libraries:
• Using Python Libraries
Data Structures: Stack and Queue
• Data Structures : Line...
File Handling:
• File Handling
Recursion
• Recursion
Idea of Algorithmic Efficiency
www.youtube.co...
Interface Python with MYSQL:
• Interface Python with ...
MYSQL
• MYSQL
Computer Networks:
• Computer Networks
Programming Corner:
• Programming Corner
Output Based Questions:
• Output Based Questions
Boolean Algebra
• Boolean Algebra
Basics of Python
• Python Introduction, F...
Flow of Control
• Flow of Control (Condi...
String Manipulation
• String Manipulation
List Manipulation
• List Manipulation
Dictionaries
• Dictionaries in Python
Sorting
• Playlist
Thank u so much best computer teacher ever seen ....🙏
Glad to hear this...
Most welcome
Thank you ma'am
I was able to solve all the questions myself....
It was all possible because of your lectures which included detailed explanation and concept clarification 🙏🏼
I am for sure that you will reach '100' sub "dream" on 2nd April when we write CS board exam❤❤❤
you're the best tbh wow what an explanation
!!
Thanks a lot 😊
Mam I have seen you have replied each and every comment. Hatts off to you mam 🙏🙏
Thanku so much...
Mam by your videos I can easily understand the computer science chapters😊.
Great....Thank u...
Keep watching...
@@SwatiChawlaofficial yes mam
Thanku...🙏🏻😊
Aap ke pass computer thi class 12 me agr thi to plz batana computer me acha score kese kre ...plz I really need help
Thank you so much mam...u r the best🤗🤗
Most welcome 😊
Mam in the resort and ownedby table's question in its part 1 can we write" where type like 5 star" instead of "where type = 5 star"????
mam you are the best computer teacher ...................😘😘
Thanku so much...🙏🏻😊
Thanku mam...😊....Mam you are so much consistent about your work.... I like it mam👍
Thanku beta...
Welcome mam😊
Mam 20 min 20 sec p jo question h last part wala usme hm query - "select type,owner from resort,owned by where resort place equal owned by.place and resort.type equal 5 star." aise bhi likh skte h
Thank you ma'am for making such Amazing Videos only these helped me to understand the concepts
Dhanaywad mam🙏 I was having doubts related to DDL and DML... Now all clear🔥 Mam ek last doubt hai... Mam date format YYYY/MM/DD hai na? Because at 14:02 the StartDate column of resort table format is YY/M/DD and M is in name... So if this format is there then what is the clause/statement for it?
Both methods are correct...
check out this..it will help u..to understand the concept better.
mysql> create table DS
-> (NNAME varchar(12),
-> DOB date);
Query OK, 0 rows affected (1.14 sec)
mysql> insert into DS values('aaa','1990-8-8');
Query OK, 1 row affected (0.21 sec)
mysql> select * from ds;
+-------+------------+
| NNAME | DOB |
+-------+------------+
| aaa | 1990-08-08 |
+-------+------------+
1 row in set (0.00 sec)
mysql> insert into DS values('aaa','1991/7/8');
Query OK, 1 row affected (0.17 sec)
mysql> select * from ds;
+-------+------------+
| NNAME | DOB |
+-------+------------+
| aaa | 1990-08-08 |
| aaa | 1991-07-08 |
+-------+------------+
2 rows in set (0.00 sec)
mysql> insert into DS values('aaa','99-8-9');
Query OK, 1 row affected (0.16 sec)
mysql> select * from ds;
+-------+------------+
| NNAME | DOB |
+-------+------------+
| aaa | 1990-08-08 |
| aaa | 1991-07-08 |
| aaa | 1999-08-09 |
+-------+------------+
3 rows in set (0.00 sec)
mysql> insert into DS values('aaa','20-8-9');
Query OK, 1 row affected (0.18 sec)
mysql> select * from ds;
+-------+------------+
| NNAME | DOB |
+-------+------------+
| aaa | 1990-08-08 |
| aaa | 1991-07-08 |
| aaa | 1999-08-09 |
| aaa | 2020-08-09 |
+-------+------------+
4 rows in set (0.00 sec)
mysql> insert into DS values('aaa','22-8-9');
Query OK, 1 row affected (0.06 sec)
mysql> select * from ds;
+-------+------------+
| NNAME | DOB |
+-------+------------+
| aaa | 1990-08-08 |
| aaa | 1991-07-08 |
| aaa | 1999-08-09 |
| aaa | 2020-08-09 |
| aaa | 2022-08-09 |
+-------+------------+
5 rows in set (0.00 sec)
@@SwatiChawlaofficial ok mam... Thank You mam🙏
@@SwatiChawlaofficial words are short to describe your contribution
.....👏
Thanks Swati maa'm🙂👍🏻
Welcome
Thank u soo much mam loved it
Most Welcome
Thanks maam🙏
Welcome
Best teaching style
Thanku...🙏🏻😊
I like your video before starting 👍
Thank you so much 😀
Mam please tell me that:- count (*) will be given in
,count (*),
Like this only yes!....
So my question is.........
For which column we will count the values
I cant able to understand this only
Butttt other alll superb mam, U are tooo great, Teaching very nicely👍👍👍👍👍👍
I used to see only your videos for computer science It helps me too much.......
Only please clear my doubt🙇🙇
Thanku for appreciating...
If only count(*) will be given..
Like
Select count(*) from tablename;
It will count the total number of rows in that table.
I understand that mam
But if it asked
Like
Select Doc,Count (*),Name from Document;
then....
We shall count that haw many have same document and we will count same document.....
Yes?
Or we will count the same name???
then also....count(*) column will display value of total number of rows..
Mam but as U have taught in this lecture, no personal count (*) coulumn is there then.......
Thank you so much mam
Most welcome 😊
Mam you are doing great work for us thank you so much🥺🙏🏻
Most Welcome..🙏🏻😊
Keep Watching 👍🏻
THANKS ma'am
Welcome
Mam why you not used update command at in part 5 of ques no. Where table given trainer and course.bonus vala ques
Very helpful
Thanks
Nice way of teaching ..mam ❤️
Please provide the pdf of these lectures...🙏🙏 I shall be highly obliged to you ❤️
Sure... You can enjoy special perks by joining the membership.
Have a look at this.
th-cam.com/channels/2vH9rqGh-fJELF8acGfBdw.htmljoin
Mam how many output based questions are asked in boards class 12
maam thank you so much for these pyqs, i was feeling tensed abput my board exam on 2nd april and this is helping me gain confidence
Thanks
Thank You Ma'am 😊
Welcome
First comment.....
Best teacher ♥️😎
Yes sure best teacher ❤️
Thank you so much 😀
Thank you mam for this video as it really help in my exams.!
Glad to hear that
Keep watching..
Mam can u make a marks distribution of each chapter video👀🙏
Thanks mam its very useful
Welcome 😊
Keep Watching
Awsm maam 🙏
Thanku....
Keep watching..
Thank you very much ma'am
Welcome....🙏🏻😊
U r just awesome
thanku...
Please upload the link of notes in description box.
A relation has 45 tuples & 5 attributes, what will be the Degree & Cardinality
of that relation?
i. Degree 5, Cardinality 45
ii. Degree 45, Cardinality 5
iii. Degree 50, Cardinality 45
iv. Degree 50, Cardinality 2250...mam how to do question like this??
Degree means -- number of columns (or attributes)
Cardinality means -- number of rows (or tuples)
Ans. Degree - 5, Cardinality - 45
U R SUPERB MAM
thanku...
👌
🔥
Mam aliasing me kahi as lagate hai or kahi sirf " " me likhte hai 🤔🤔
Both are correct
@@SwatiChawlaofficial ok ma'am. Thank you ma'am 💯
Mam please upload the videos on how to study full marks in computer science..
Yes... definitely...before exams...will upload..
Don't worry
Mam u teaching style and all is good but please provide pdf notes
*Hey, now you can avail all these notes at the discounted rate….*
*Class - X Information Technology*
* Employability Skills (Notes) - X rzp.io/l/1mcA8UL
* Employability Skills (Ques Ans) - X rzp.io/l/2hxw8tY6N
* NCERT Solutions of CBSE Class 10 IT 402 rzp.io/l/fKUADxvbv
* Unit - 1 Digital Documentation Advanced using LibreOffice rzp.io/l/GUhTNcTpH
* Unit - 2 Electronic Spreadsheet Advanced (using LibreOffice) rzp.io/l/PpBEONKRN
* Unit - 3 DBMS (based on LibreOffice Base) rzp.io/l/XJrYs2P
* Unit - 4 Managing Health and Safety rzp.io/l/TQWvwOa
*Class 11 Computer Science (083)*
* Python rzp.io/l/cKflR95C
*Class 12 Computer Science (083)*
* Computational Thinking & Programming - 2 rzp.io/l/wihJhPBO
* Computer Networks rzp.io/l/OKWrgua
* Database Management rzp.io/l/z0mu2uBVu
* Assertion and Reasoning rzp.io/l/TgngGDjb
*IMPORTANT : After successful payment, don't refresh or go back (Redirecting...... will be shown on screen) , just wait for a while, and then Click on Request Access button, then you will get access to notes on your G-Mail ID within 24 hours.*
Paper aa gye h fatti padi h hmari.... How can u even think we'll getting bored...🙃
Your like to dislike ratio is 🔥🔥🔥
Yes....Noticed just now....Thanks for bringing it into my notice... :)
570:12
=285:6
thanks mam ye sari pdf kaha milegi
Sure..You can enjoy special perks by joining the membership.
Have a look at this.
th-cam.com/channels/2vH9rqGh-fJELF8acGfBdw.htmljoin
👍👍👍👍
Thanku..
query ok
Ma'am.. where can we get sample papers 2021?
Ma'am can we use UNIQUE clause in the first question... If not... Why so??
The UNIQUE is a constraint which ensures that all values in a column are different.
To fetch unique values from a table, Distinct is used.
@@SwatiChawlaofficial ooh...okay ma'am thanks a lot.....!
thanks for making me understand the difference
Ma'am, have you also taught the syllabus that was deleted for session 2020-21? For 2021-22, there is no reduction in syllabus, so can the students of 2021-22 batch also refer to the videos?
yes.....students of 2021-22 also can refer my channel and the uploaded videos..
The chapters which were deleted last year...u will find the video on those chapters also..
Plz share this channel with others also..
@@SwatiChawlaofficial OK ma'am, thank you so much.. Your videos are really helpful.. Thanks a lot once again..
Most welcome
@@SwatiChawlaofficial Ma'am, one more doubt.. Is everything given in sumita arora book important from exam point of view? I am getting really confused ma'am.. And should I practise the questions given in it because I am finding some questions which have not been taught..
Do follow sumita Arora also...it will help u to be master in python...but the questions given in that book..some of are not according to exam point of view..
Whereas in my videos..i have covered those questions which are important from exam point of view...
Mam commands ko excute karke dikhaye
Plx check out the complete playlist of MySqL..
There is not even a single command which is not executed..
Mam how to download this ppt
Sure..You can enjoy special perks by joining the membership.
Have a look at this.
th-cam.com/channels/2vH9rqGh-fJELF8acGfBdw.htmljoin
Ma’am can you provide a link for the official computer science ncert? Can’t find it anywhere. My school uses the one by Sumita Arora
ncert.nic.in/textbook.php
This is the link of NCERT books...just fill out the class and subject...But this is not according to ur curriculum...
For CS board exams, refer the curriculum and sumita arora is also according to ur syllabus..
@@SwatiChawlaofficial ok ma’am thank you
@@SwatiChawlaofficial Ma'am are all the things given in sumita arora book there in our syllabus?
174 like and 0 dislikee
Power
Thanks....even i didn't know about this... 😊
now it is 222 likes and still 0 dislikes🙂🙂🙂🤩
Your teeth is very good😁
mam can i refer this video as i am an ip student
Yes..
First
thanku...
Please send the PDF or word file
Sure..You can enjoy special perks by joining the membership.
Have a look at this.
th-cam.com/channels/2vH9rqGh-fJELF8acGfBdw.htmljoin
0 DISLIKES !!!! BOW
Yes...didn't knew about this..
Thanku so much...
Mam bohoti acha explanation hain..but mam please explaination ke pehle answer maat daliye please..warna akh sida answer ke taraf jah raha hain..question par ne ke pehleyi so mam behtar hoga ap pehle question read kijiye phir students ko time dijiye ya boliye video pasue karne ke liye..and then ans show kijiye..i hope you got it mam..
ya sure... Thanku so much for your valuable suggestion.. Will implement this...
Sorry for the inconvenience caused..
@@SwatiChawlaofficial No mam it's fine no inconvenience has occured...Once again thanks for the service you are doing for the students...
My pleasure...
Mam how to download sql
I don't know 🙁
th-cam.com/video/XJNLw3W7xew/w-d-xo.html
Check out this
mam please provide pdf
Sure..You can enjoy special perks by joining the membership.
Have a look at this.
th-cam.com/channels/2vH9rqGh-fJELF8acGfBdw.htmljoin
Mam aap pdf kyun nhi dalti
Mam vo smja do round off in SQL wla
actually, it's not in your curriculum... that's why..not covered..
😢 mam camputer science me camp. Ah gya to plz most important questions share me 😢❤
Sample Paper for Class 12 Computer Science
Sample Paper for Class 10 Information Technology
🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲
*Question Bank for Class 12 Computer Science* 📘
🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲
*🤩Available on:*
*✅Notion Press:*
notionpress.com/read/question-bank-of-computer-science-with-python
*✅Amazon:* amzn.eu/d/g2jVkwg
*✅Flipkart:*
dl.flipkart.com/s/MJsq63NNNN
_If you will buy this from NotionPress Website, no delivery charges will be there._
🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲
Question Bank of Class 10 Information Technology
🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲
🤩Available On
✅Notion Press
notionpress.com/read/question-bank-for-cbse-class-10-information-technology-for-2023-exam
✅Amazon
amzn.eu/d/6aU43gZ
✅Flipkart
dl.flipkart.com/s/3UgBKDNNNN
🌟🌟🌟🌟🌟🌟🌟🌟🌟🌟🌟🌟🌟🌟🌟🌟
Social Handles.. (Please Subscribe and Follow)
🥏TH-cam Channel: th-cam.com/users/Swatichawlaofficial
🥏Instagram: instagram.com/Swatichawlaofficial
🥏Facebook: www.Facebook.com/Swatichawlaofficial
🥏Telegram Channel for Class 12 Computer Science: t.me/swatichawla12cs
🥏Telegram Channel for Class 10 Information Technology: t.me/swatichawla10it
Aap ke pass computer thi class 12 me agr thi to plz batana computer me acha score kese kre ...plz I really need help
Mam pls provide pdf of these questions plsss
Sure... You can enjoy special perks by joining the membership.
Have a look at this.
th-cam.com/channels/2vH9rqGh-fJELF8acGfBdw.htmljoin
Mem please please provide pdf
Sure..You can enjoy special perks by joining the membership.
Have a look at this.
th-cam.com/channels/2vH9rqGh-fJELF8acGfBdw.htmljoin
Mem pdf 😭
Sure..You can enjoy special perks by joining the membership.
Have a look at this.
th-cam.com/channels/2vH9rqGh-fJELF8acGfBdw.htmljoin
Mam can u make a marks distribution of each chapter video👀🙏
chapter wise marks distribution not released by cbse..
@@SwatiChawlaofficial mam by taking assumptions from sample paper🤔