I copy this from discrimination Tmecodes: 00:00:00 : Start 00:05:45 : introduction to Database 00:19:41: Degree and cardinality 00:22:09 : Keys in a Database 00:49:51 : Introduction to SQL 00:52:52 : Practical implementation on Database 01:00:42 : Constraints 01:13:57 : DML Commands 01:24:38 : Alter command 01:30:21 : Drop 01:33:44 : Distinct 01:33:44 : Between and 01:40:20 : Like and not Like 01:46:05 : in and not in 01:47:55 : is null 01:48:22 : order by 01:51:29 : Questions
See foreign key act as a primary key it is not the primary key and it can be null because as you saw in doctor one example if we don't know which doctor is checking the patient then we will write null in that case now you understood 😊
Thanks ma’am for your guidance . After listen to this video my concepts are crystal clear for those topics which you studied in this class. Thanks a lot mam🙏.
@@awm3828are bhai phle kyu har man rhe !! Kal ka pure din para hain !! Kyu chinta lete !! Meanwhile me - who just pass with 25-30 marks in halfyearly till now and didn't study cs till now !!
@@FardeenKhan-ue6fxactually I gave up now I can't even understand a shit dude and all my exams were shit too I think I've to repeat class 12 it's over for me
@@FardeenKhan-ue6fxbhai ye jo lec hai ise Kar lunga to sql mein 20 mein. Se 15 marks aajayenge kya tune kia hai kya ye lec aur bhai networking Kar lunga bhai pls bta jaldi pass ho skun
@@aman-2392 bhai 1) fail v ho gaya toh ab bukatna toh hona ghar ma , but its life ups and downs atte ha sabke life me, just move karna siikho , khud par believe toh chize hard nai lagengi 2) NIOS se exam de dena dubara october ma ..dont worry it is acceptable everywhere 3) SQL , NETWORKING , STACK OR LOOPING KE kuch questions karlo and last ma PYQs karke jana ......pass ho jaouge aram se 4) subhe 6 baje tak padh sakte ho fir so jaw 2 hrs
🟢Join our Free Sikandar Batch for Class 12 Board Exams:
ua-cam.com/play/PLIuyYdw7LjvC3Y2IpWc6MaGe0IXNMtHE8.html
LOVEJEET MAM OP
I hope may all the aspirants will get above 95%
yes
Yes ofcourse
@@krish7890 ha bhai,,lekin sirf SQL baaki jo mam alag se IP walo k liye karwa rhi h wo dekhna.
@@manishs_waybhaiya mera smj ni aata sql and python as mera 10 th computer na tha school wale ne apne aap daal diya mera computer 😅
Any one watching 👀from 2024 batch
Present
present
Bro ye ip ke liye bhi hai kya?
:)
anyone here in 2024?
Yes
Me
Me
Yup
hnji mai hu🙂
Video start from at 6:30
🙏🙏
Thank you 🙏🙏🙏🙏
Most underrated teacher in computing
Pratical wala part karna hai kya
Having group by
Count
Count(*)
Joining of two tables.
These topics are not covered
It is a best lec in whole youtube to revise everything of sql within 2 hrs ! ❤❤
I copy this from discrimination
Tmecodes:
00:00:00 : Start
00:05:45 : introduction to Database
00:19:41: Degree and cardinality
00:22:09 : Keys in a Database
00:49:51 : Introduction to SQL
00:52:52 : Practical implementation on Database
01:00:42 : Constraints
01:13:57 : DML Commands
01:24:38 : Alter command
01:30:21 : Drop
01:33:44 : Distinct
01:33:44 : Between and
01:40:20 : Like and not Like
01:46:05 : in and not in
01:47:55 : is null
01:48:22 : order by
01:51:29 : Questions
Bhai description hota hai 💀
Useful video
Watch 1day before exam
Did u passed not offensive but I'm in same position
@@saumyaaaaa__ u passed?
😂
17:10,54:11 mam aap jab ye bolte hona toh jo mere jese h jinhone 2,3 din pehle he shuru kiya unhe alg level ka demotivation hit hota😶😶🌫
Bilkul shi.. 6 ko jee mains bhi h😮
@@thenishantx7unka kya jinka 4,5 Tarik kon hain and jyada Sylabbus huya bhi nhi !! Yeh yad krrhe isme kag rhe baki sab bhul gye !! Meri to uski bhi revision ,practice puri nhi huyi !! Pichli bar bhi REVISION reh gyi thi !!
@@sggoyal2022 us bhaii... me toh maths exam ke baad bhot chill hogaya tha.. jee bhi bacha hua aur cs toh gaya me kal😔
Mera toh Rt aa jayega
Kal ke liye all the best everyone
Thank you 💙
Who are here just after maths exam 😂
Are you from rampus????
😂
Me today was my maths pre board
Me😂😂😂
Us moment bro😅😅
Kis kisne abi tk kuchni pda
Bhai es video sai ho gye ga ky ?
@@devashishdhyani5748 shi hai bhai krle
meine bhai, ek din padhkar top marenge sab...
bro paper 9 ghante baad hei and mein ab start krra hu😭
@@Anurag-ct9zv koi nahi krle bhai mene bhi thoda sa padha hai subah tk ho jaryga
kon kon abhi chalu kar raha hai padhna
Bhai bhai ❤
Bhai ji
Us bro us
Us moment kar deya bro
SQL networking stack kr rha hu bss.. bhaii
Thanks you mam for the lovely session
Sidu and card trick awsm ❤❤❤
bhai cartesian join natural join wagerah to chhor diye
How can a foreign key be null? If foreign key is a primary key for another table, how can it hold null values? Lil confused
See foreign key act as a primary key it is not the primary key and it can be null because as you saw in doctor one example if we don't know which doctor is checking the patient then we will write null in that case now you understood 😊
@@ketanraj612 okkk thanks!!!
@@pranjalkumar8721 if you liked please honor me by being first subscriber
Mam plz.....jyada se jyada MCQs with elplanation dalo.....KVS ke liye
Thanks ma’am for your guidance . After listen to this video my concepts are crystal clear for those topics which you studied in this class. Thanks a lot mam🙏.
I think Mam is an SRK fan😂😂 or she watched DDLJ before this session, cos at start she mentioned about Raj-Simran, and at 37:57 about Shah Rukh😂😂
😂😂😂😂
Who watch Bca student 😅 for exam or Basics...please like
Legends watching last night before board exams😅
😎👊🏻
We legends😂🫂
Bhai
My SQL connector with python
Where and have difference something like that is missing here pls refer other videos for those
Thanks maam for supporting us on last moment ❤
Bhai kitne number aaye CS mein
Thank you Mam for this amazing session😊
THANK YOU MA'AM.I COMPLETEDIN 5 HOURS WITH NOTES MAKING.
Thank you ma'am 💪🏻❤️❤️
Thanku soo muchhhhhh maam...🥺🙏🏻
U made my concept crystal clear ❤✨
Learnohub ke student ho kya 😂
49:22 sidhu moosewala
joins kahan hain?
watching just a day before board exam
samee
Starting 6:10
Yaar ye mam kitne cute hai aur yaar ye kitne achhe se padate hai
Awesome class mam
very helpful ma'am!! Thank you
Kya koi h meri tarah jo sirf database and networking pdh kr ja rha h 2 april 2024 ko😂😂😅
😅
Haa Bhai
😂😂😂mai bhi
Hnn
😭
I came here to study but i fell in love with her
fail ho jayegaa
Starting ke 40 minutes samjh aaya lekin uske baad hawa tak na laga 😢
Ye cs walo k liye hai ya ip walo ke liye bi?
Apka class mst lgaa sb smj aa gyaa bhut accha sa
Interface of paython with an SQL database..... Karwa do....
49:32 dill da ni mada..... tera sidhu musse wala....🎤☝️
Ap bht acha pdate ho
frpm where we can get notes ??
MAM YOUR WAY OF EXPLANATION IS ALSO SUPER DUPER COOL
Thank you so much mam kal exam hai Mera 😭❤
Thank you for video 🥰🥰🥰🥰
mam maeray 95/100 board mai thank you
Mam you are the only teacher jiska mujhe samajh me aya h
Thanks a lot mam 💖
Syllabus hogya ya revision chal rha hai😊
@@BittuGoswami-fk6wp syllabus bhi ho gya or abhi revision chal rha h bhaiya 💖
Bhai fail hojaunga yrr m k h nhi arha computer pe :)
Us Bhai us🥲
SQL and computer networks ke bharose h sab kuch 🙃
@@sakshiiiy vo bhi nhi jaa rha h dimaag m kuch ni hone ka ab🥲
@@awm3828are bhai phle kyu har man rhe !! Kal ka pure din para hain !! Kyu chinta lete !! Meanwhile me - who just pass with 25-30 marks in halfyearly till now and didn't study cs till now !!
@@sggoyal2022 bol to shi rhe ho bhai tum🥹🙌apna pura best dunga
Legends are studying at last night before cs board😂😂
2 months pahle konsa exam tha bhai Tera 😂
Mam notes kaha par milengey??
*Range*
char 0-255
varchar 0-65535
Ma.am love your expressions
Ma'am this is best class
ye vdo sikandar batch (computer science) ki playlist me kyu nhi ha ..... darr gaya tha ma toh..... ki ab sql kaha se krunga lovejeet mam ke bina😅
Koi ip student hai yaha par 😅
Jo pura vdo lec dekh rha ho 👇
this is toh class 11th no group by wagera..
Nots kaha h??
Thank you mam 😊
Thank you mam
ma'am life saviour ho app
We want class 12 I.P. class
Ma'am please ip ki video only pandas please please please ma'am 🥺🥺🥺🥺🥺🥺🤗🤗🤗🤗
Mam join group by cimmands?
Notes Kaha milega
Thank You Ma'am.
IS THIS IS USEFUL FOR BOARDS????
@@NEETCLASSES_FREE Its 70% usefull for boards
@@NEETCLASSES_FREE yes sql ke liye sahi h but kuch functions nhi krae h wo kisi aur se dekh lena
@@pranjalkumar8721 ok
Sidu spelling is wrong right spelling is sidhu❤😂🎉😢😮😅😊
is it just me who is in college and is watching it for sec????
Waywa by lovejit Arora
❤❤❤❤❤
EF CODD*
Lelo mje C.S k Exam k
Di ismh apne simple quaries karaye??
Bhai jisne 11th aur 12th dono m kuch na pdha ho ..uske liye thik hoga ye lec?
Mam plz network ki combined class lgwa do
2024 batch >>>>
Ya bro
maam aap insaan nhi aap devi hain😊😊😊😊😊😊😊😊
bilkkul sahi bole ho bhai
@@abhimanyukarna6729 khud ko reply de raha hai 🤣🤣🤣
@@Ryuu72-e1d mere pet me dard hai, iske piche mard hai
Add to playlist all lec of computer
Isme.. Group by aur having by kaha hai?
Mam why are you so cute
Yrr iske age ki video kahan hai , agle topics, btado koi ???
Mam apka telegram channel kis name se h
Nice mam
Abb me CS padna start kar Raha hu kya ho gya hai muje 🤦🤦🤦
same bruh
@@FardeenKhan-ue6fxactually I gave up now I can't even understand a shit dude and all my exams were shit too I think I've to repeat class 12 it's over for me
@@aman-2392 are bruh esa mat socho, mere bhi acche nhi gaye, mera bhi man kr rha hai give up krne ka
@@FardeenKhan-ue6fxbhai ye jo lec hai ise Kar lunga to sql mein 20 mein. Se 15 marks aajayenge kya tune kia hai kya ye lec aur bhai networking Kar lunga bhai pls bta jaldi pass ho skun
@@aman-2392 bhai 1) fail v ho gaya toh ab bukatna toh hona ghar ma , but its life ups and downs atte ha sabke life me, just move karna siikho , khud par believe toh chize hard nai lagengi
2) NIOS se exam de dena dubara october ma ..dont worry it is acceptable everywhere
3) SQL , NETWORKING , STACK OR LOOPING KE kuch questions karlo and last ma PYQs karke jana ......pass ho jaouge aram se
4) subhe 6 baje tak padh sakte ho fir so jaw 2 hrs
14 july for compartment 😅
Nice one ma'am
Mam Do you have Crush on Shahrukh Khan sir ?? 😅😅😅
1:45:00
thankyou mam
Is this video also helpfull for IP students
Plz batana mai bhi ip ki hu😢
New section 2024 to 2025
Super dupr cool
i love you maam
go go
can ip students watch this
Matlab hame EDGAR FRANK ko phlna hai
Mam ye beech beech me ruka mat karo bacho s baat krne k liye flow nhi bn pata phir pdai k beech m baate aur
1 to 255 varchar