Constraints (Unique, Not Null, Primary Key, Foreign Key , Check , Default)

[@RahulChoudhary-c3b]

Amazing teaching style.

[@vandanapatil8182]

We need all lectures of SQL So we can crack good companies Pls include 1 industry level project also in the end 😊

[@InsightsLift]

Sure I will do that ❤ thanks for you comment 😊

[@JunaidKhan-vy5ir]

Your way of explaining concepts is very unique at its best and all the concepts are well-covered with Interview tips Thank you for teaching!

[@InsightsLift]

So nice of you ❤😊

[@soumyaranjanbaliarsing]

Madam Do you teach Python Class .

[@soumyaranjanbaliarsing]

Thanks, Pragya Mam here is an easy way to teach SQL constraints. Using this concept I have cheate 3 table in using all Constraints . Example CREATE TABLE MOVIE ( Ticket_No INT PRIMARY KEY, Seat_No CHAR(10) UNIQUE, Age INT CHECK (Age>18), Movie_name VARCHAR(15) DEFAULT ('PUSPA-2'), AMOUNT INT NOT NULL ); SELECT * FROM MOVIE CREATE TABLE [FOOD ZONE] ( Ticket_id INT PRIMARY KEY, Order_id INT ,FOREIGN KEY (Order_id) REFERENCES MOVIE (Ticket_No), Table_No CHAR (10) UNIQUE, No_Order INT CHECK (No_Order>2), Items VARCHAR (20) DEFAULT ('COLD DRINKS'), Amount INT NOT NULL ); SELECT * FROM [FOOD ZONE] CREATE TABLE PAYMENT ( Transaction_NO INT PRIMARY KEY, Recipit_1 INT , FOREIGN KEY (Recipit_1) REFERENCES MOVIE (Ticket_No), Recipit_2 INT , FOREIGN KEY (Recipit_2) REFERENCES [FOOD ZONE] (Ticket_id), Payment_Mode VARCHAR (10) DEFAULT ('UPI'), No_Of_Payment INT CHECK (No_Of_Payment>5), Amount_Recipit_NO VARCHAR (20) UNIQUE, Amount INT NOT NULL );

[@sivaanju8947]

I need to know U r teaching the course of data analytics .for free of cost

[@InsightsLift]

@@sivaanju8947 No actually full data analytics course can’t be free ,but we are trying to provide as much as we can for free . Though our courses are designed in best way and they are very very affordable as compared to any course that is in market.

[@sivaanju8947]

I have think this videos It will helpful to freshers too work as data analyst those don't have any IT knowledge. Can we select as data analytics by watching ur videos.

[@InsightsLift]

@@sivaanju8947yes you can crack companies by my videos also I am posting one video everyday before 1 pm IST . Just watch my full sql series and u r good to crack any company. After uploading my basic to adv sql series I will be uploading sql interview questions also . I hope that will help you ❤.

[@sivaanju8947]

Tq sis