What is PRIMARY KEY & NOT NULL Constraints in SQL

No video

What is PRIMARY KEY & NOT NULL Constraints in SQL - Part 5

Рет қаралды 19,745

Күн бұрын

#SQLTutorials #NaveenAutomationLabs
In this video, we will learn about what is CONSTRAINT in a table. We will talk about NOT NULL Constraint and Primary Key Constraint.
Learn:
What is Primary Key?
Notes:
--MUST CONTAIN UNIQUE VALUES
--CAN NOT HOLD ANY NULL VALUES
--CAN HAVE ONLY ONE PRIMARY KEY
--BUT CAN CONTAIN SINGLE OR MULTIPLE COLUMNS
What is NOT Null Constraint?
Notes:
The NOT NULL constraint enforces a column to NOT accept NULL values.
~~~Subscribe to this channel, and press bell icon to get some interesting videos on Selenium and Automation:
www.youtube.co...
Follow me on my Facebook Page:
/ naveenqtpexpert
Let's join our Automation community for some amazing knowledge sharing and group discussion on Telegram:
t.me/joinchat/...
WebServices API Automation Tutorials:
vimeo.com/onde... Subscribe to this channel, and press bell icon to get some interesting videos on Selenium and Automation:
www.youtube.co...
Follow me on my Facebook Page:
/ naveenqtpexpert
Let's join our Automation community for some amazing knowledge sharing and group discussion on Telegram:
t.me/joinchat/...
Paid courses (Recorded) videos:
Java & Selenium Course: www.naveenautom...
API Course: www.naveenautom... ➡️Get Our Courses✔️
📗 Get My Paid Courses at
Paid courses (Recorded) videos:
Java & Selenium Course: www.naveenautom...
API Course: www.naveenautom...
-------------------------------
✔️SOCIAL NETWORKS
Facebook: / naveenqtpexpert
Twitter: / naveenkhunteta
Blog: www.naveenautom...
--------------------------------
Support My Channel✔️Or Buy Me A Coffee
Paypal: paypal.me/nave...
Google Pay: naveenanimation20@gmail.com
--------------------------------
✔️Thanks for watching!
देखने के लिए धन्यवाद
Благодаря за гледането
感谢您观看
Merci d'avoir regardé
Grazie per la visione
Gracias por ver
شكرا للمشاهدة

Пікірлер: 28

@rashmibharti3653 4 жыл бұрын

Though we have many other videos on u tube for SQL but your way of teaching is really admirable as u make concept very easy to understand ...please make remaining videos on this series.

@vaishnavi8988 4 жыл бұрын

please videos on joins

@SarangHoley 5 жыл бұрын

The way Naveen you teach the things, its just like anyone can learn, your way of teaching is very different that's why any boring topic also be consumed easily.😊👌, awaiting for next video of the series.

@trahamatrah8250 2 жыл бұрын

Thanks a ton for all these comprehensive videos!!

@sanjaypathak6722 4 жыл бұрын

You are great sir,waiting for your next SQL videos.Please make video over joins.

@abraham2961 5 жыл бұрын

Hi Naveen thanks for making Db video but parallely make video on Rest API please

@ajitavchakrabarty 3 жыл бұрын

Hi Naveen, as usual you're explaining things so well that whosoever is going through it does not have any doubt left. I would like to request you to continue on this series to add some videos on Joins and other important topics on SQL with proper concept and explanation. Thanks in advance.

@khushboomadaan7563 3 жыл бұрын

All the videos are great but please create the videos for foreign keys and joints as well, Thank you so much👍

@sujitblues 3 жыл бұрын

Thank You so much sir for sharing on database testing series.please add one video on Join , simple join to complex Join with practical examples.

@arabindamohanty2190 3 жыл бұрын

Thanks a lot I learnt sql 🙏

@varindervirk2440 5 жыл бұрын

sir,please upload videos on other joins ,becoz we are preparing for an interviews

@dilberer2770 5 жыл бұрын

Hi, I guess DROP is used to delete a whole database or just a table. DROP object object_name or DROP TABLE table_name; table_name: Name of the table to be deleted. When I search it I found that we should remove the autoincrement property before dropping the key: ALTER TABLE Table_Name MODIFY id INT NOT NULL; ALTER TABLE Table_Name DROP PRIMARY KEY; I am not expert, but I wanted to share:)

@rahulpawar7726 5 жыл бұрын

Hi Naveen, can you please upload the Videos on Joins also

@surudhivenkat7268 4 жыл бұрын

The videos are really good. Please upload the video for joins as soon as possible.

@arunpondhe7949 5 жыл бұрын

thank you naveen sir so much effort you are doing for us, SQL query retrieves using java code please make some video

@MadiraSarkar 3 жыл бұрын

Hi Naveen, can you please create a video on other constraints ? I have gone through your all other videos from this SQL series and the new series on join concept also. If you can cover that part , it will be very helpful. Thank you 🙏🏻

@nanistar2400 4 жыл бұрын

Hii Naveen, The knowledge from your above 5 videos is enough to tackle the interviews in auto and manual testing or i should learn some more in sql.

@naveengudipati376 5 жыл бұрын

Hi Naveen thanks for making the sql videos . please upload the video on remaining constraints and joins

@rashmiagarwal67 2 жыл бұрын

Hi Naveen, thank you for your videos, its really helpful. can you also include topic where in we can have unique values in multiple columns like phonenumber, idnumber and both to be unique in a table, not combination basis...

@yuktialagh4099 4 жыл бұрын

Waiting for remaining sql joins video.. thanks

@footprints2489 5 жыл бұрын

Thanks Naveen .. could you please make video for the remaining constraints also..

@abhishekkarkoon4584 3 жыл бұрын

Naveen can you make videos on stored procedures in sql

@vijayaraghavanvashudevan1977 3 жыл бұрын

Hi bro.. can you make video on Joins and Foreign keys as well.. Thanks

@sendrayannallasamy7109 5 жыл бұрын

Hi Naveen, can you please tell me these 5 SQL videos which you taught is related with Selenium? or different.. if you say "yes it is related, then i wanted to learn these 5 videos or help me know know which SQL i can lean for Selenium webDriver...please reply..