#6 Delete vs Drop in SQL | Database Management | Class 12 CBSE Computer Science and IP
Welcome to the Part 6 of the Unit on Database Management by Bhargab Kakati for CBSE Class 12 Computer Science (083) and Informatics Practices (IP) Examination. In this part, i have discussed about two very important commands in SQL drop and delete. If you haven't watched other parts of this unit , you may watch from the links below : ? Part 1 - Introduction to Databases https://youtu.be/hd4hqQRqdsQ ? Part 2 - Keys and Its Types - Primary , Candidate , Alternate and Foreign Key https://youtu.be/LFc81g17hW8 ? Part 3 - Introduction to SQL https://youtu.be/6tIJO8emM6A ? Part 4 - Getting Started with SQL https://youtu.be/qiEfzqYV6E8 ? Part 5 - Data Filtering in SQL https://youtu.be/NjIhR6qyf2I ? Part 7 - Pattern Matching in SQL using like operator https://youtu.be/KZ6K1Yp7gXk ? Part 8 -Data Manipulation in SQL | alter vs update https://youtu.be/Ilzj1XBmW9U ? Part 9 - Sorting data in SQL | order by clause https://youtu.be/QVs996GIGe4 ? Part 10 - Aggregate Functions in SQL https://youtu.be/R4dLs9AQf98 ?Part 11 - Grouping Results in SQL | group by https://youtu.be/HasU1kXV5W0 ?Part 12 - Joins in SQL | Equi Join and Natural Join https://youtu.be/DF9cAZ01MLA ?Part 13 - Constraints in SQL | Not Null , Unique , Primary Key and Default Constraint https://youtu.be/Q3tUHtNOB5k ?Part 14 - Foreign Key Constraint in SQL https://youtu.be/Qk1nd8bPAqE This video is a part of my e- learning initiative during the days of novel Corona Virus . Topics Covered: delete command in SQL drop command in SQL with its variations: drop table drop database delete vs drop Practical demonstration of drop and delete commands in SQL Connect on these social media Handles: ? Instagram: https://www.instagram.com/bhargab_kakati/ ? LinkedIn : https://www.linkedin.com/in/bhargabkakati/ ? Twitter : https://twitter.com/bhargab008 #Database #SQL #Class12 #ComputerScience #MySQL #IP #DataFiltering #deletevsdrop Bhargab Kakati PGT (Computer Science)
Welcome to the Part 6 of the Unit on Database Management by Bhargab Kakati for CBSE Class 12 Computer Science (083) and Informatics Practices (IP) Examination. In this part, i have discussed about two very important commands in SQL drop and delete. If you haven't watched other parts of this unit , you may watch from the links below : ? Part 1 - Introduction to Databases https://youtu.be/hd4hqQRqdsQ ? Part 2 - Keys and Its Types - Primary , Candidate , Alternate and Foreign Key https://youtu.be/LFc81g17hW8 ? Part 3 - Introduction to SQL https://youtu.be/6tIJO8emM6A ? Part 4 - Getting Started with SQL https://youtu.be/qiEfzqYV6E8 ? Part 5 - Data Filtering in SQL https://youtu.be/NjIhR6qyf2I ? Part 7 - Pattern Matching in SQL using like operator https://youtu.be/KZ6K1Yp7gXk ? Part 8 -Data Manipulation in SQL | alter vs update https://youtu.be/Ilzj1XBmW9U ? Part 9 - Sorting data in SQL | order by clause https://youtu.be/QVs996GIGe4 ? Part 10 - Aggregate Functions in SQL https://youtu.be/R4dLs9AQf98 ?Part 11 - Grouping Results in SQL | group by https://youtu.be/HasU1kXV5W0 ?Part 12 - Joins in SQL | Equi Join and Natural Join https://youtu.be/DF9cAZ01MLA ?Part 13 - Constraints in SQL | Not Null , Unique , Primary Key and Default Constraint https://youtu.be/Q3tUHtNOB5k ?Part 14 - Foreign Key Constraint in SQL https://youtu.be/Qk1nd8bPAqE This video is a part of my e- learning initiative during the days of novel Corona Virus . Topics Covered: delete command in SQL drop command in SQL with its variations: drop table drop database delete vs drop Practical demonstration of drop and delete commands in SQL Connect on these social media Handles: ? Instagram: https://www.instagram.com/bhargab_kakati/ ? LinkedIn : https://www.linkedin.com/in/bhargabkakati/ ? Twitter : https://twitter.com/bhargab008 #Database #SQL #Class12 #ComputerScience #MySQL #IP #DataFiltering #deletevsdrop Bhargab Kakati PGT (Computer Science)