#9 SQL Foreign Key in Telugu| SQL Full Course in Telugu| Foreign Key in SQL Telugu

#9 SQL Foreign Key in Telugu| SQL Full Course in Telugu| Foreign Key in SQL Telugu

Explained in very easy mode and every one can understand easily!!

Telugu Programming Tutorials -- HTML , C#, CSS, Java Script, PHP, .NET, JAVA, Interview Questions and Answers etc...

[kishorereddy]

Sir meeru chala manchiga explain chestunnaru sql gurinchi deep ga videos cheyyandi sir like full course

[Saikumargunna]

create table statesInfo(stateid int primary key identity, statename nvarchar(50), statecode nvarchar(20))
insert into statesInfo values('AndhraPradesh', 'Ap')
insert into statesInfo values('Telangana', 'TG')
insert into statesInfo values('MadhyaPradesh', 'Mp')
insert into statesInfo values('Maharastra', 'MH')
insert into statesInfo values('Karnataka', 'KA')
select * from statesInfo


create table districtInfo(districtid int primary key, districtname nvarchar(50), stateid int references statesinfo(stateid));
drop table districtInfo
create table districtInfo(districtid int primary key, districtname nvarchar(50), stateid int, CONSTRAINT FK_StateID FOREIGN KEY (stateid) references statesinfo(stateid));

insert into districtInfo values(1, 'mumbai', 4)
insert into districtInfo values(2, 'mumbai', 4)


insert into districtInfo values(3, 'bidar', 5)
insert into districtInfo values(4, 'chikballapur', 5)


insert into districtInfo values(5, 'Indore', 3)
insert into districtInfo values(6, 'Bhopal', 3)


insert into districtInfo values(7, 'Anantapur', 1)
insert into districtInfo values(8, 'Guntur', 1)


insert into districtInfo values(9, 'war', 2)
insert into districtInfo values(10, 'kari', 2)


select * from statesInfo
select * from districtInfo

[janushaik]

Very nice explanation
We need all topics of SQL

[gopal.kkunchepu]

Bro meru enka SQL vedios update cheyandi meru chala Baga explain chesthunnaru pls more vedios upload cheyandi

[sureshsiripurap_]

your explanation is very excellent brother

[manipalukuru]

very good explanation brother, keep doing the same

[smhkede]

you r explanation is too good make more videos

[vinodkumar-fmbk]

hi sir nadi oka doubt oka comp lo rendu tables create chesina tharwata ee oka table lo kuda foreing key constraint evaledu alantappudu manam table middel lo foreing key constrain echi aa rendu tables ki joins apply cheyadaniki untadaaa sir. Is it possiable sir

[pavanmadineni-pemc]

Intha arthamayyetatlu evvaru cheppaledhu. Nuvvu Sarvepalli radhakrishna anna🙏

[anjalipabbathi]

It's good but the screen is not much clarity please see that

[kheemws]

nice explanation you are the best....but no response from that mail to real time experience .

[Saikumargunna]

select statename, districtname from statesInfo si join districtInfo di on si.stateid=di.stateid

[pmviesb]

sir can you please expalin the difference betweeen table level and coloum level

[Navee____]

Foreign key class asala enni sarlu chusina ardam katle

[uppalasrikanth]

bro qlik view tool gurichi cheppandi bro

[glvrmsh]

I have sent an email regarding sql real-time project on 25th Jul 22 but not received any response from the respective team.

[cvyeier]

anna userinfo table syntax chupinchu anna last lo

[revanth]

I have Intrest on real time project but if I need to pay for course I am not Intrested

[raghutelugutraveller]

both tables lo column id same udala bro.

[shahedaarshu]

Your syntax not Very small font is appearing