#13 Constraints in SQL | Not Null , Primary Key , Unique , Default | Class 12 CBSE Computer Science
Welcome to the Part 13 of the Unit on Database Management by Bhargab Kakati for CBSE Class 12 (XII) Computer Science (083) and Informatics Practices (IP) Examination. In this part, i have discussed about the concept of constraints in SQL and its types .
If you haven't watched other parts of this unit , you may watch from the links below :
👉 Part 1 - Introduction to Databases
• #1 Introduction to Database Concepts ...
👉 Part 2 - Keys and Its Types - Primary , Candidate , Alternate and Foreign Key
• #2 Keys and Its Types - Primary,Candi...
👉 Part 3 - Introduction to SQL
• #3 Introduction to SQL | Class 12 CBS...
👉 Part 4 - Getting Started with SQL
• #4 Getting Started with SQL | Class 1...
👉 Part 5 - Data Filtering in SQL
• #5 Data Filtering in SQL | Database M...
👉 Part 6 - delete vs drop in SQL
• #6 Delete vs Drop in SQL | Database M...
👉 Part 7 - Pattern matching in SQL | like operator
• #7 Pattern Matching in SQL | like ope...
👉 Part 8 - Data Manipulation in SQL | alter vs update
• #8 Data Manipulation in SQL | alter v...
👉 Part 9 - Sorting Data in SQL | order by
• #9 Sorting Data in SQL | order by | D...
👉 Part 10 - Aggregate Functions in SQL
• #10 Aggregate Functions in SQL | Data...
👉Part 11 - Grouping Results in SQL | group by
• #11 Grouping Results in SQL | group b...
👉Part 12 - Joins in SQL | Equi Join and Natural Join
• #12 Joins in SQL | Equi Join and Natu...
👉Part 14 - Foreign Key Constraint in SQL
• #14 Foreign Key Constraint in SQL | C...
This video is a part of my e- learning initiative during the days of novel Corona Virus .
Topics Covered:
00:00 Intro
00:38 Concept of Constraints
02:40 Types of Constraints :
03:09 Not Null
09:48 Primary Key constraint
16:10 unique constraint
24:26 default constraint
21:05 Differences between primary key constraint and unique constraint
practical demonstration of all the SQL concepts mentioned above
Connect on these social media Handles:
👉 Instagram: / bhargab_kakati
👉 LinkedIn : / bhargabkakati
👉 Twitter : / bhargab008
#Database #SQL #Class12 #ComputerScience #MySQL #IP #Constraints #PrimaryKey #Unique #NotNull #Default
Bhargab Kakati
PGT (Computer Science)