Keys in SQL | Telugu | Primary Key, Foreign Key

SQL Project 🏏 for Beginners: imyai.in/
keys in SQL, Primary key, foreign key, Unique key, Composite Key, Surrogate Key, Candidate Key, Super KEY for beginners in Telugu.
📚 Resources:
CREATE database JNTUH;
USE JNTUH;
🔑 Primary Key:
CREATE TABLE STUDENTS(
ID INT PRIMARY KEY,
NAME VARCHAR(255),
COURSE VARCHAR(255)
);
DESCRIBE STUDENTS;
insert INTO STUDENTS VALUES (01,"UDAY","AIML");
insert INTO STUDENTS VALUES (01,"RAJ","CSE");
SELECT * FROM STUDENTS;
🔑 Foreign Key:
CREATE TABLE STUDENTS1(
ID INT,
NAME VARCHAR(255),
COURSE VARCHAR(255),
COURSEID INT PRIMARY KEY
);
CREATE TABLE COURSES(
COURSEID INT PRIMARY KEY,
NAME VARCHAR(255),
FOREIGN KEY (COURSEID) REFERENCES STUDENTS1(COURSEID)
);
DESCRIBE COURSES;
🔑 Unique Key:
CREATE TABLE STUDENTS3(
ID INT UNIQUE,
NAME VARCHAR(255),
COURSE VARCHAR(255)
);
DESCRIBE STUDENTS3;
INSERT INTO STUDENTS3 VALUES(01,"UDAY","AIML");
INSERT INTO STUDENTS3(NAME, COURSE) VALUES("UDAY","AIML");
SELECT * FROM STUDENTS3;
🔑 Composite Key:
CREATE TABLE ROLLNUMBER(
YOJ INT,
COLLEGECODE VARCHAR(255),
COURSECODE VARCHAR(255),
PRIMARY KEY(YOJ, COLLEGECODE, COURSECODE)
);
INSERT INTO ROLLNUMBER VALUES(18,"JN45","A0");
INSERT INTO ROLLNUMBER VALUES(19,"JN45","A0");
SELECT *,CONCAT(YOJ, COLLEGECODE, COURSECODE) AS ROLLNO FROM ROLLNUMBER;
🔑 Surrogate Key:
CREATE TABLE STUDENTS4(
ID INT AUTO_INCREMENT PRIMARY KEY,
NAME VARCHAR(255),
COURSE VARCHAR(255)
);
SELECT * FROM STUDENTS4;
INSERT INTO STUDENTS4(NAME, COURSE) VALUES ("RAM","ECE");

[@spandanat9488]

Very well explained. Chaala easy ga ardham ayyettu chepparu. Thanks a lot👏🏻

[@maheshlingampalli7354]

Bro your explain so super bro but only one prblm bro please sql full videos go fast bro...

[@uday_ai]

Definitely 💯

[@mallarpuganesh479]

This is my 1st time watching your videos, the way you explain is amazing sir. There is also an eagerness to learn.

[@praveenkumaranamala6565]

Hi uday , Good thanks for doing. please do VIEWS , TRIGGEERS, STORED PROCEDURES, INDEXING cheyandi chala use itundi andariki

[@tarunkumar3784]

Tq so much bro ❤ for giving valuable information

[@saikumarkorada6950]

Bro doing fast videos,i am excited to listen your videos bcz ur teaching very well

[@yuvaranisandeep_bellary1026]

Do a vedio on string functions and date functions. Please upload regularly its important for me

[@uday_ai]

Sure..

[@prasannareddy9415]

Can u please upload videos regularly

[@uday_ai]

Definitely 💯..

[@Rakesh-le6mi]

Thank you bro 😍.

[@KedharnadhMaddula]

analytical or window functions please........ continue with etl testing is good start.....

[@uday_ai]

Sure soon am going to make videos on Window Functions & more advanced topics, Stay Tuned..!

[@boddulabhargav2324]

Anna konchum fast ga cheyyu anna remaining videos, we will definitely support you

[@uday_ai]

For SQL specially for beginners I covered everything so please make sure you have tried the Chinna SQL Proejct ,to get hands on experience

[@suhailmohammad513]

Unique key only one null value ne accept enduku chestundi ante ... In my view,.. it allows only unique values right, So more than one null value doesn't make it unique. So having one null value is also a unique thing.

[@akhilkumar459]

Thank you

[@Obito847]

Bro, one doubt on Roll number table. In a year like 2018, there might be many students joining same college having college code as JN45 and at least 5% of them might take same course id like A0 right, so, in that case, the next rows might give an error, right if am not wrong. So, how about keeping their last name or last 4 digits of their Aadhar card as Primary key to add it as ROLL_NUMBER? It's just a doubt, please clarify it on your next video. Thank you!

[@LOHITHKUMARMATRAPU]

sql full course upload bro dont stop doing videos

[@uday_ai]

Definitely 💯

[@tharuntrendy8995]

Bro tables use chesi relationship or convert chestaru kada like (one to one, one to many, many to many)aa topic meda oka video chy bro pichaa confusion uudhi...🙏🏻

[@uday_ai]

Definitely 💯

[@ALEKHYA-ou2tn]

Hi, can you talk about business analyst also I'm a student of University of Hyderabad, studying mba ba , but placements are not in high amount , i want to know the highest package a BA as a fresher can get ...if I try off off the campus which companies should I try And the stand out skills that BA should learn ...it will be really grateful if u can make a video on BA

[@uday_ai]

Meanwhile, if you see my youtube community post I will be setting up virtual meets for those who completed the Pedda SQL Project, try to complete that & hope we'll discuss lot of things there...

[@saisuprajac]

I have been waiting for ur video from a very long time .....hw r u bro?

[@uday_ai]

Tqsm 🙂, am good 💫

[@suldn2113]

normailization petu with normal forms

[@uday_ai]

Sure Meanwhile, if you see my youtube community post I will be setting up virtual meets for those who completed the Pedda SQL Project, try to complete that & hope we'll discuss lot of things there...

[@suldn2113]

@@uday_ai Thanks bro for previous videos interview ki baga use ieyaiii

[@pushkalchodisetty3923]

bro CTE explain cheyara?

[@uday_ai]

Soon am going to make video on CTEs.., Stay Tuned..!

[@PuttupuSasikanth]

Inka anni videos unnayi undachu bro?

[@uday_ai]

May be 2-3..

[@Vijaykumar-hm6mp]

Anna nuvu mali vachinave😢 rav anukunnane.....