DATABASE AND SQL | Class 12 Python | Computer Science
HTML-код
- Опубликовано: 14 окт 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...
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: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
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
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
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
Correction must 6:17
Degree---->no. of attribute/columns
Tuple------->no. of tuple/rows
😊🙃
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
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
6:20
Correction
Degree is No of attributes/ column
Cardanility is no of tuple/ Rows
mujhe bhi laga tha ye galat hai
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 ;
degree = no. of columns
cardinality = no. of rows
Next video kahaa hai ???
@@FINNHIMANSHUYTkabhi aayi nahi😂
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
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”
Can u make a proper video for connecting python with SQL and all the issues
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 😔🙏🏻
• 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.
Bhaiya aap kaha chale gye .... interface between my sql aur python b krado plZz .. vo imp b h aur smj b ni aara 🥺🥺
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
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
6:30 *Mistake*
Degree is number of Columns
Cardinality is number Rows
Thanks bhai i was confused
Bhaiya plz aap or questions kar vaya kijiyae. This is the humble request🥺🥺🥺🥺🙏🏻🙏🏻🙏🏻🙏🏻😭😭😭😭😭
kvs wala hai kya
PYQ video coming
@@harsh_sharma_1210 when???
6:17 correction
Degree - the number of colunms/attributes.
Cardinality - the number of rows/tuples.
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 ??
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👍👍
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
19:50 ......here the format of date should be yyyy-mm-dd but in yor querries it's yyyy-dd-mm
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
2 APRIL WHILE LISTNING GETTING BORED
J jip 💀
Bhayia syllabus complete hai? Is play lost mein?? Sare chapters hain?? Plzz tell 🥺
Cardinality refers to the number of tuples/rows in a table whereas, Degree refers to the number of attributes/columns in a table.
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 ....
Thankyou Aman Bhaiya and TEAM APNI KAKSHA 🙏🙏
Please 15 Feb tak pura syllabus karva do🙏🙏🙏
Bhot help hogi👍
Please🙏🙏🙏
Huge request 🙏🙏🙏🙏
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
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
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.
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.
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
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
thank u sir..was waiting eagerly for sql!:) awesome content as always!
Bhai sir ka name kya hai cs wale?
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
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
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 :)
A Big thanks to Atul Kumar and Anurag Sahu.
You just saved me.
I searched on net and you were correct. 🔥🔥🔥
Comment section really is important, most times I ignore it but now I won't. 👍
Waah Bhai waah adha ghante mein chapter complete
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
Sir please check your data once
Degree is number of columns
Cardinality is number of rows
Chemistry ke lectures upload kar deegea bhaiya
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
Bhaiya plz make a video on Intro to software engineering(ch. 4) & Society, law & ethics(ch. 9)
Alternate key - aise key jo ban sakti thi par humne nahi banayi.. Yeh definition hay shayad 8:40
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🔻💗🔻
A database is collection of interrelated data
-it reduces redundancy(repentance)
-ensures data security
-integrity can be maintained
DBMS:-(database management system ) is a software that helps us to establish and implement a database,it helps in storing and manipulating data.
Relational data model:- this data is organised In tables(rows and columns) these tables are called relations.
Terminologies:-
1.view:-a virtual table that doesn't really exist but it's used to view the base tables derived from one or more base tables
2. Primary key:- one or more attributes that can uniquely identify tuples within the tables
3. Candidate key:-all attribute combinations inside a table that are candidates to become a primary key.
4. alternate key:-a candidate key which is not a primary key
5. Foreign key:- a non key attribute whose values are derived from the primary key of some other table.
💢🌟🌟🔴🔴blunder blunder blunder 🔴🔴 definition of degree and cardinality have been exchanged btw thanks for everything else
Sir two term are wrong right one is
*degree* is for no. Of cloumns\ attributes
And cardinality is for no. Of rows\tuples.
Degree: no. of columns
Cardinality: no. of rows
Please do it correct in the video
Alternate keys are candidate keys which are not primary..
correction (likha sahi hai aapne galat samjhya)
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
6:31 definition of cardinality and degree are opposite .
bhaiya please focus on audio if possible try to increase
degree = no. of coloumn
cardinality = no. of row
please upload ip lectures asap....i"m totally banking on apni kaksha for ip..so its a request to u to upload the same
subah tak ho jayega na guys abhi start karu toh?
Ha
Haa
ho jayega main bhi abhi lga hun
probably good luck vai!
ha
Thank youuuuuuuuu sir !!🙏🙏
Difference between degree and cardinality in a relation.
Degree is no of columns or attributes and cardinality is the no of tuples or rows
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🥰🥰
Sir,tomorrow is my cs exam and this video is really really helpful as I don't know anything about this chapter
Bhaiya next video upload krdo. Plzzzz!!!!!!! 🥺🥺🥺🥺🥺🥺🥺
Thank you so much sir..I am literally facing lots of trouble in this chapter but you lecture clear my all queries and it's just become easy peasy chapter for me in entire computer science...
Please Deta inconsistency to thora achhe. Se explain kar dijeyeaa
Actually I amm confused about other defination of data incosistency 'multiple mishmaching of data '
Hope it will soon sort out
The videos are great, but the volume is quite low.!
Interface with Python is still left the last part of this lecture.....fetchall () fecthone() row count()
Lol thanks for giving me 100 marks hahahaha😂(5:15)
Very Good, you got IIT bombay!!
😏😏🤣
@@ASRu2k3 to lele na, mere se kyu puch rha hai?
is this was the last video for python class 12th cource ? plz if you studied completely then plz reply
When will be the next video on interface Python with MySQL?
he said this is last chapter, so will he even post videos of interface python and networking? :-/
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
Thank you so much sir...🙏🙏🙏
For making it veri simple for us❤
interfacing python with mysql bhi daal do iss playlist mein
Watching before just 5 hrs before exam 💀
true
I am watching it rn🤡
35:50 wrong❌
PRIMARY KEY(class,marks) nahi❌
PRIMARY KEY(class,roll no) hoga
Ek din pehle padhne ka plan bnate h aur ek din pehle padhne ka maan he ni krt h... 🤧💀
Bhaiya class 11 Computer science vaalon ke liye bhi banado, Please...🙏🙏🙏
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
6:41 sir aap ne thodi si galati ker di hai, DEGREE: matlab number of attributes and CARDINALITY: matlab number of unique records present in those attributes
What about rest of the syllabus ?
Plz make a video for python interface with sql
plzz upload the next video fast .............preboards are coming
19:17 YYYY-MM-DD
is correct, the example given is wrong no year has more than 12 months
So pointing so straight so much explanation 💯 thank ya v much ❤️
Next video kaha hai ???
Make vd for final 12th revision plz
Kaun board ke exam ke do din pehle padhne aaya hai 😂
Meh.😂😂
Us bro
Idhar idhar!
Meh bhi 😂
😅
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.
Thankyou so much sir....itni achi explanation ke liye ye video mere liye bht helpful rhi sir❤️❤️
Please upload daily
Sir when u will solve sample paper of the same
watching on the exam day😅😅
Us
Us
Bhai ab next video kab aayega. ? . Jaldi krwado yr as no one is as good as you in teaching python and computer science.
Please note at 5:45 there is a mistake in degree and cardinality of relation ,there definition are interchanged
Sir, how much sllybaus is left?.?
How much time u will take to cover the sllybaus??
Because on 12 feb i have my PREBOARD EXAM
Bro is this 25 videos is sufficient for class 12 boards