DATABASE AND SQL | Class 12 Python | Computer Science
ฝัง
- เผยแพร่เมื่อ 23 ก.ย. 2024
- SQL and Database: drive.google.c...
Notes and Important Links of this lecture 👇
Discord Server: / discord
Instagram: / apnikaksha
Telegram of Apni Kaksha: t.me/apnikaksh...
![[Full Episode] The Restaurant War Thailand ศึกพ่อค้าซ่าแม่ค้าแซ่บ Episode 1 | 22 ก.ย. 67](http://i.ytimg.com/vi/BuzQ70v-UZQ/mqdefault.jpg)
6:17 Correction
Degree : no. of Columns/Attributes
Cardinality : no. of Rows/Tuples
Exactly i am also saying that
@@Krishnihks 🥺mera bhi
Merko bhi laga ki book me galat likha hai kya 🥲
👍 I was thinking either my book is wrong... But this man doesn't know
Yes bro
6:46 degree is not number of rows,degree is number of columns,cardinality is number of rows
Yup i also checked it
Lo inko khud hi confusion h😅
Correct
sahi kaha mai bhi wahi soch rha tha
me bhi wahi soch raha tha aise kaise bol rhe h
6:34
Degree - no. of columns
Cardinality - no. of rows or records
Video me thoda mistake hai
Nahi bhai sahi hai
M bhi yhi soch rha tha ki ulta likha h
Yes degree nom of columns hi hoti h video me galat likha h
@@anuragsahu191 Han bhai Tum sahi ho, net me hi nhi book me bhi ;
Degree : number of attributes (columns) in a relation
Cardinality : number of tuples (rows) in a relation
@@neeraj.chaudhary bhai me aaj hi exam me galat krke aaya hu shitt yrr
1 april 2024 wala koi hai ya akela hu idher 🫣🥲
Mai hu bhai
Mai hu
Mai bhu
Nhi bhai mein bhi hoo
Abhi start kr rha hu bai
Degree: number of attribute or column
Cardinality: number of tuples or row
..... correction
Bhai sahi bol raha hai👍
Sahi pakad liya brother👍
Int kya he
@@hrishikeshsingh69 int is integer data type that means only integer values can be accepted ;)
Matlab degree 3 thi aur cardinality 4
24:14 GROUP BY
26:38 IN, HAVING
35:46 Composite key
37:10 ALTER TABLE
velle log 🤦♂
@@vineetsingh5599 wohi XD
thanks bhai yehi dhudh rhaa tha...❤
@@vineetsingh5599 tere jaise
@@vineetsingh5599 ha bhai tu toh majdoor hai tuze bhot kaam hai na
Degree signifies the number of attributes in case of the relation and the total number of columns. Cardinality is known to be the number of tuples in case of the relation and the number of rows. At the end the cardinality will be 4 and the amount of degree will be 5
.
The cardinality of a join between two tables is the numerical relationship between rows of one table and rows in the other. Common cardinalities include one-to-one, one-to-many, and many-to-many. For example, consider a database of electronic health records.
Thx mai bhi confuse hogyaa tha
ye ye dekhe ke mei paper de aata thanks mujhe btane ke liye
Kaun board ke exam ke do din pehle padhne aaya hai 😂
Meh.😂😂
Us bro
Idhar idhar!
Meh bhi 😂
😅
Thanks for sql videos
Bro Kia apni kaksha ka yeh python course sufficient h acche marks k liye aagar Mene shuru kuch na pdha ho to or inka yeh playlist acche krlu to kaafi h pls rply
@ to yeh playlist or pyq. Krlu to me bhi phod skta hun
@@yatendrakumar9895 Ha bro.....
@@yatendrakumar9895 bro networking chapter nahi hai is playlist me to vo bhi kar lena jyada mushkil nahi hai theory theory hai
@@yatendrakumar9895 networking to 10th me bhi kiya tha jyada diff nahi hai
Phir next video kabhi aayi nhi
😂😂
Ab practice kaise karunga 🤡 main video to ayi hi nhi
Vhi toh SO SAD 😢😕 bhut gussa bhi aa rha h in pr 😤😡 lekin phir thik bhi ho km se km itna toh ho gya easily 😊🙃
Bhai kabhi search bhi kr lo phele ..playlist mai nhi hai mtlb todhi nah uploaded nhi hai....lecture 24 hai
Playlist mein nahi hai, par video is already released. Search karo “python and sql class 12”
Legends will know that notes have been made from Sumita Arora
is this course complete
@@dreamiit5759 I think, its not PYTHON CONNECTIVITY and other topics are still missing
@@amralifts phir bhi kitna percent course khatam hua hai??
@@niveshkothari networking and interface Python with my sql is left
@@sameepkapoor6695 bhai networking m lecture s bdia h yaad hi krlo book s
Thq so much .My exam of IT is coming and due to lockdown I came to know nothing about MySQL and from ur video i think I come to know everything. Thq so much really and GBU
Bhaiya plz make next video practical exam is going to start 🙏🙏🙄
yes
Bhai kaun se school se ho
@@storyteller3740 wo ab college me h
@@aviralomar3760 bhai ho skta ho drop lia ho🙂
@@mayank5549 mene ye sambhavna sochi to thi pr socha ki iska jikra n kru pr pta nhi tha duniya me tum jaise maha fursat log baithe honge jo hm jaise fursat logo ke kiye hua comment pr ye kami nikalne aa jyenge
Aman Bhaiya Please Upload a Video Which Cover All Previous Year Question So That We Can Practice Them and Score Good in Boards
Hello
Kitna aalsi banoge be
correction ;
degree = no. of columns
cardinality = no. of rows
Next video kahaa hai ???
@@FINNHIMANSHUYTkabhi aayi nahi😂
Love the way of teaching. Simple, fast and understandable
And wrong tooo
@@rashmipandey4797 ??
@@afmclover7889 degree and cardinality
@@rashmipandey4797Bhai ek hi cheez to wrong boli hai, baaki to badhiya padha rhe hi sir
subah tak ho jayega na guys abhi start karu toh?
Ha
Haa
ho jayega main bhi abhi lga hun
probably good luck vai!
ha
6:20
Correction
Degree is No of attributes/ column
Cardanility is no of tuple/ Rows
mujhe bhi laga tha ye galat hai
Next Videos exam ke baad daloge kya bhaiya???
Aur haan sample paper bhi karwa do toh maja hi ajayega kya bolti public!!!🙏🏻
Aur abhi kitne topics baaki hai??
Abhi kitna potion cover hua hai itne videos me?
@@niveshkothari bs itna pata hai ki abhi aage course baki hai, aur ye aage ka course daal hi rahe hain 😭
@@niveshkothari 35% lgbhg baki h
String kya he
Stop complaining about the videos and stuff, the Apni kaksha team is already pushing limits for us. Show some effort from your side too and start studying instead of asking for new videos. Making animated videos is not like surfing on Instagram, it takes time
You are absolutely correct.We should comment and motivate aman bhai.I know he is trying so hard to put the whole syllabus before boards.
Who is complaining
Lol
@@frost26336 many people
Bhai ab jadi video acche se banoge and phir video mei dekhaoge 2+2=5 hota hai tho complain je sivai kya kare students?
Correction must 6:17
Degree---->no. of attribute/columns
Tuple------->no. of tuple/rows
😊🙃
Can u make a proper video for connecting python with SQL and all the issues
Bhaiya plz aap or questions kar vaya kijiyae. This is the humble request🥺🥺🥺🥺🙏🏻🙏🏻🙏🏻🙏🏻😭😭😭😭😭
kvs wala hai kya
PYQ video coming
@@harsh_sharma_1210 when???
Bhaiya aap kaha chale gye .... interface between my sql aur python b krado plZz .. vo imp b h aur smj b ni aara 🥺🥺
Sir please it a humble request increase the frequency of video there is pre boards very soon after this week
So, what are you doing now bro ??
6:30 *Mistake*
Degree is number of Columns
Cardinality is number Rows
Thanks bhai i was confused
Bhayia syllabus complete hai? Is play lost mein?? Sare chapters hain?? Plzz tell 🥺
Kon kon aaj padh rha mai akela toh nhi hu🙂
nhi bhai tu akela nhi hai xhinta mat kar
@@ItachiUchiha-fh1vp sahi kaha bhai physics ke exam ke baad bakchodi kab ki tayag di mene merko aukkat dikha di ab me koi subject halke me ni leta.Revision ke liye dekh raha hu.
easy ke chakker mai padha nahi , ab soch raha thoda pahle suru karna chaiye tha,
lekin koi na ab jo hai wo hai , jitna hoga utna karunga
mai to ab kar raha
Best of luck bro @@AshishKhetwal
@@tanmay_yadav_2004 bhai bekar kar aya 😔🙏🏻
2 APRIL WHILE LISTNING GETTING BORED
J jip 💀
sir there is mistake that in case of DEGREE = NO. OF COLUMNS/ ATTRIBUTE
and in case of CARDINALITY = NO. OF ROWS/TUPLE .......THANK YOU SIR👍👍
I know I'm late but last time bhi notice kiya tha fir se kar raha hoon so just to help if someone's confused. Jo keys ka defination likha gaya hai vo sahi hai par sir se explain karne me mistake ho gaya hai. Just remember har vo field/column ya combination of column jo unique ho vo candidate key hai, unme se ek primary key banega aur baki sub alternate key.
Bhai 23 March ke liye yeh videos enough hai if I also practice the quest
i am in 11th...can i really depend on this videos for my boards in 12th?please reply my seniors
U can depend for the lectures. But i am using my school notes. So notes i have no idea
@@mohamedsufeeyan4423 ok...i got it
@@arghojitsaha3568 U have any idea about how much videos are left on this course?
@@mohamedsufeeyan4423 I'm in 11th..so i don't know anything
Nope.
Cardinality: number of rows
Degree: number of columns
Relation: store logically data
Domain: pool of values from which actual values appearing in given column .
Tuple: row
Attribute: columns
Degree: no. Of columns/ attribute
Cardinality:no of rows
19:15 format of date is YY-MM-DD but it it written 2021-17-01
correct date should be '2021-01-17' as according to the format of DATE ....... 17 cannot be a month ....
6:17 correction
Degree - the number of colunms/attributes.
Cardinality - the number of rows/tuples.
Boards last exam on : 8th June 2021🤡
Tu Phodega !
@@shashwatdubey6864 Thanks bro 🙌
8t june hai bhai change ho gaya
8th bro
le bhai milgya chainnn
21 din i chutti hone ke baad bhi ek raat padhne wala me :). PS-Kal fail hone wala hu....
Don't worry bro nahi hoga fail
Theory vale chapter bhi h 👍
@@kushagrajoshi9624 me doomed hu vai tu padh
Nahi hoga bhai 🔥
@@kushagrajoshi9624kitna numbers ke hai bhai vo 😢
@Garlic_boy_ kaisa hua exam?
thank u sir..was waiting eagerly for sql!:) awesome content as always!
Bhai sir ka name kya hai cs wale?
Amazing lecture sir. Bas ek cheez hai ki ye sir ki voice beech mein slow ho jaati hai toh wahan dikkat hoti hai so sir can you please teach in a loud and clear voice. THANK YOU
Bhai ab time kha h
Thankyou Aman Bhaiya and TEAM APNI KAKSHA 🙏🙏
Please 15 Feb tak pura syllabus karva do🙏🙏🙏
Bhot help hogi👍
Please🙏🙏🙏
Huge request 🙏🙏🙏🙏
35:50 wrong❌
PRIMARY KEY(class,marks) nahi❌
PRIMARY KEY(class,roll no) hoga
• DDL (Data Definition Language) includes SQL statements such as, Create table, Alter the table and Drop table.
• DML (Data Manipulation Language) includes SQL statements such as insert, select, update and delete.
thx bro
Ty bro
this one came so many times in our exams
● DQL ( Data Query Language) :- SELECT statement.
2 April wala koi h ?
Mee 😢
Bilkul
Kyu nahi
Difference between degree and cardinality in a relation.
Degree is no of columns or attributes and cardinality is the no of tuples or rows
Bhai log all the best for the exam
Thx bro
lekin isse mera kya faeda
Bhai kitna aaya tha marks computer me out of 100?
@@rudraraj5637 93 :)
Cardinality refers to the number of tuples/rows in a table whereas, Degree refers to the number of attributes/columns in a table.
Aman bhaiya pls video dal do practical aane wale hai
6:46
Degree is no.of columns
Cardinality is no.of rows
Ur from ip or cs
@@rashmijain5467 Cs
So sarla can u reffer some utube channel for it as i am unable to understand. Sql pls help sarla
@@rashmijain5467 🤔 I am also unable to find any perfect channel ....But things taught by my school teacher are enough for good marks in cs ....
I think there is a channel Edutainment
You must have already checked it 😂...Mujhe bhi kuch khaas samjh nahi aaya uss se....
Hm yrr i have already seen
Tomorrow on 2/4/2024 is 2023-24 batch CS exam. And today is 1/4/24😂.
What's so funny?
Funny is honey for them 😂😅
Black honey 🍯 (🐝)
19:50 ......here the format of date should be yyyy-mm-dd but in yor querries it's yyyy-dd-mm
anyone say that this is wroth to watch for 2april exam ( not studied anything about cs)
please sayy
if u dont know anything then ofc this video will be helpful. but try dtudying textbook too
@@gandyyy3 thx broo
6:27
degree is the no. of attributes
cardinality is the no. of rows/tuple
Ur from ip or cs one
@@rashmijain5467 cs
Plss suggest a channel for sql chapter i genuinely need it
Plss suggest a channel for sql chapter i genuinely need it
@@rashmijain5467 this one only is enough just go through ppt once all questions will seem easy
Sir please chemistry ke lectures dal dijiye asa animated content pure youthub me nai hai
Bro missed some things to explain but bro won my heart
The best cs teacher l have ever seen
Not just on yt but also bro teaches better than offline teachers
degree = no. of coloumn
cardinality = no. of row
Degree- no of column
Chemistry ke lectures upload kar deegea bhaiya
6:2 Ye ulta nhi likha hua? Sumita Arora ki book me to Degree is number of columns/attributes likha tha
Haa jo book ke according hai woh likhna isne galat bola hai
@@angelinascrewed ohhh alright, thanks a lot!
Maine personally aise abbreviations banakar yaad kar rakha hai:
TinkeRCAD
= TRC for Tuple, Row, Cardinality
CAD for Column, Attribute, Degree
@@M1551NGN0 np and thanks for that will help me remember it as well, best of luck for the exam :)
@@M1551NGN0bro lol maine bhi same aise hi yaad kiye😂. just that maine rct ka crt rkha
@@angelinascrewed same to you! ❤️
watching on the exam day😅😅
Us
Us
please🙏please 🙏🙏🎉Mai 12hr tak padh lunga🔥, please 100% dene ke liye taiyaar hu me
Please guide me❤️
Jaise hi 2 Feb ko dates announce hogi CBSE ki, 12 pcm ke liye full 3 months detailed strategy bana dena subject wise please , abhi tak 10-15% hi padha h{pcm me} please
3 months me kaise syllabus compelete karke revise karu for 90%?🙏🙏🙏
Please 🙏🙏🙏👍👍👍
Much needed🙏🙏
Huge request 🙏🙏
Please think on it🙏
Don't ignore 🙏🙏🙏
Suicidal feeling aa rhi h please🙏
Practicals bhi badiya jaye aisa bhi kuch karna pleasee(strategy video for practical)🙏🙏🙏🙏
Please bata dijiye bhaiya Jisne class 11th theek se nahi Padha kya woh class twelfth Mein computer science Mein Achcha kar sakta hai Computer Science Ki Jo paper Hai vah NCERT Ke Piche se aati hai ki kahan se aati hai agar ham log Guiya pura series Dekh Le To Kya pure number a sakte hain
@@Malaika_ki_rahein ye series enough h🙏
@@dakshjain6673 aur bhai jo exam Mein questions Aate Hain vah Kya textbook Ke Piche se aate hain aur jismein class 11th acche se nahin Pada computer science Mein Uska Kya Karen bhai
@@Malaika_ki_rahein everything is covered here in brief
@@dakshjain6673 bhai yah puchna tha ki jismein class 11th Nahin Paida hua kya Karega usko sab Kuchh aaega Aage
The best thing of apni kaksha is
It don't take too much MB's to download the video and the second thing I love about apni kaksha is we don't need to put the video on 1.5x and so on...😊
Thankyou to all teachers of apni kaksha😇😇❤
Yes 720p quality pe sirf apni kaksha ke hi lectures download kar sakte hai🥰🥰
I have a question
Is this all the syllabus for class 12
And if no then why is other videos not present in the playlist or is the series discontinued
bhaiya please focus on audio if possible try to increase
Degree refers to no. of columns not rows 😕
Ha right. Galat bataya hai vid me
Watching before just 5 hrs before exam 💀
true
I am watching it rn🤡
Cardinality -no of raw
Like the comment if
Legends watching it few days before exam ,😂 Cbse board 2023
Bhai kitna aaya tha marks computer me out of 100?
Bhaiya there is a mistake at 6:22 in the video .... Degree in number of columns/attributes and Cardinality means number of rows/tuples but in the video it is written opposite. Please check whether it is correct or Wrong
Galat he hai
Sir please chemistry ke lectures dal dijiye asa animated content pure youthub me nai hai
Sir chem. Ke ase ek number lectures se notes or understanding do hi jaldi hote hai🔻💗🔻
Sir please check your data once
Degree is number of columns
Cardinality is number of rows
sala aaj exam ha khali networ padha🤣
Mai bhi 😂😂
kal paper hai :) all the best dosto
Sir it's a humble request please complete the syllabus because preboards are going to occur next week
Bhai yeh course ke aur kitne videos baaki hai
Bhaiya next video kidhar hai
Kya mtlb mai Akela hu Abhi 2ghnte me paper h 😂ur abhi aaya dekhne video
8:22 likha kuchh aur hai aur aap samjha kuchh aur diye
candidate keys: primary + aur jo primary ho sakti
alternate key: candidate key jo ki primary key nhi hai
Alternate keys are candidate keys which are not primary..
correction (likha sahi hai aapne galat samjhya)
kon kon boards ke 3 ghnte phele pdra h ?
mai
Me 😢
1 ghanta pehle
5:45 HARSH NE APNE AAP KO 100 MARKS DE RKHE H😂😅
Ek din pehle padhne ka plan bnate h aur ek din pehle padhne ka maan he ni krt h... 🤧💀
Bhai ye puri series 6 hours ki hai aur maine 2 din pehle dekhi hai series half yearly se aur mere 61 out of 70 aa gye😂☕🔥
Bro ek help krde yh bta de is playlist m sb chapters h 2023 ke exam ke liye?
@@Ayeisha1111 Bhai networking pad lio baaki sab almost h is playlist me
@@puttjattda2509 okay thanks bro
Alternate key - aise key jo ban sakti thi par humne nahi banayi.. Yeh definition hay shayad 8:40
Kal ke best of luck bhai sabko👆🏻
Mera toh pta nahi kya hoga😭☝🏻
bhai yaar apne aap pr itna gussa araha hey😭😭
@@huzaifa9438sahi me bro💀👍🏻
Kon kon 2 April ko aaya hai😂
Me 😂😂😂
😁
Bhai 😢
😁
lol me too
Degree: no. of columns
Cardinality: no. of rows
Please do it correct in the video
Sir plzz baccho ko galt to maat padhao...
Degree- No. of columns/attributes.
Cardinality- No. of rows/tuple.
.
CORRECTION
Yup maine bhi notice kiya
Is count(*) and count(marks)
The same thing???
no
@@ankitamishra3230 thenn?
@@aishwarya17 incase you count(*) sometimes it may yield different result from count(marks) because count(*) is the only count statement that counts everything including nulls but count(column) will count values excluding nulls
@@ankitamishra3230 ohh well!! Okayy!
Thank you so much for your help 🤠
@@aishwarya17 npp
25 din se jese depresion samaj raha tha vo meri haramkhori nikli
Us bhai us😭☝🏻
Woh sab toh thik hai raat ke 10:30 pr kon pdhne aya hai
Me 😭
me but at 11pm
23:10
11:17
11:46
kuch ghante hai, kuch bhi nhi aata
lets see apni kaksha se kitna score kar paaunga
yeh 24 dinn toh bass controversy ke maje lene mei hi nikal gye :(
Kon kon abhi pdh rha hai
Mein bro
@@kartikeykartikey8953 12 b?
please upload ip lectures asap....i"m totally banking on apni kaksha for ip..so its a request to u to upload the same
Sir date ko yyyy:mm:dd me dalna h to apne month 17 likh diya date samagh kr
Next video kahan ha??
Sir python and MySQL connectivity pr bhi lecture Dena
It's a humble request
2 marks ka hi hai boards me
Degree - The number of attributes or columns in a relation is called the Degree of the relation. Cardinality - The number of tuples/ rows in a relation is called the Cardinality of the relation.
Make vd for final 12th revision plz
bhaiya ye term 2 k liye h?
Yes
you re a real legend man🤣🤣🤣
@@HARSH-kp5vm 🤣🤣 sahi Mai bhai
interfacing python with mysql bhi daal do iss playlist mein