Скачать с ютуб Keys in SQL | Telugu | Primary Key, Foreign Key в хорошем качестве

Keys in SQL | Telugu | Primary Key, Foreign Key

SQL Project 🏏 for Beginners: https://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");