Відео

Great lecture as always 😊

Hello ma'am Are you working professional in data domain field.

Good one 😂

Madam Do you teach Python Class .

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 );

Ma'am please start interview questions and answers of SQL So we can crack good companies 😊

Great lecture as always ma'am ☺️

Waiting for more lectures & More interviews questions and answers videos 😊

Awesome lecture 😁😊

Case when video is incomplete ma'am Pls upload remaining part of the case when video Pls 😊😊

Awesome lectures as always 🎉😊

Ma'am please start interview questions and answers playlist on SQL So we can crack good companies 😊 pls 😁

Watching your videos gives more knowledge than any other videos I watch

thankyou mam❣

Pls upload 1 industry level projects 😊

Hi ,mam....for data analytics DDL AND DML COMMANDS is enough please let me..

Functions part 1 and 2 are all you need to get enough knowledge on SQL functions. Well explained all the functions!

Omg 😳 too much knowledge in 1 video, too much functions By the way great lecture as always ma'am 😊

Great lecture 😁 Pls solve lots of interview questions and explain like this 😊 Interview questions is important 😊

nice brief of this topic mam for easily understand. SQL Functions

Pls 1 industry level project in SQL In the end of the series 😊

Nice lecture Ma'am pls cover interview questions and answers so we can crack good companies 😊

Amazing teaching style.

Perfect explanation of questions, Very informative video Thanks ma'am 😊

Thank you for the gr8 Explanation Pragya 😊

Great one, good way to remember concepts

Best teacher is arrived Pls make some noise 😁🎉 Pls cover everything ma'am in SQL so we can crack good companies interview rounds 😊

Well explained!!

Well explained!

Wow that is awesome , your explanation is very clear Pragya

Hello madam, plz guide me on how to download the MS SQL Server. Class is all good for basic concepts of SQL or understanding.

hi mam, please clarify which version of Microsoft SQL we should download. developer or express??

Pragya is a one of the best mentor for SQL classes! She explains the concepts with clear examples, making it easy to understand, even for beginners. I highly recommend her!

The best channel to learn SQL from basic to advanced!!!

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

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

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!

Thanks for making youtube channe. Please upload these type of long videos. I like those videos which have class based. Happy for your channel creation. Love from Pakistan