Class 11 Informatics Practices Ch 8 | SQL for Data Definitions (Alter & Drop Statement)

Channel:
India Magnet Brains
Subscribers:
13,900,000
Published on ● Video Link: https://www.youtube.com/watch?v=d3lQ4SDEq_Y


Duration: 1:15:44
8,656 views
217

✅ In this video,

✔️ Class: 11th
✔️ Subject: Informatics Practices (Code 065)
✔️ Chapter: Introduction To Structured Query Language (SQL) (Chapter 8)
✔️ Topic Name: SQL for Data Definitions (Alter & Drop Statement) (Theory & Practical)
✔️ Topics Covered in This Video (By Barkha Mam): SQL for Data Definitions, Alter & Drop Statement, ALTER Table, Different Ways to Use Alter Add, Modify, Drop Statement, Example for SQL Data Definition, Modify Constraint of an Attribute, Practical For Alter & Drop Statement
=======================================================
0:00 Introduction
1:50 SQL for Data Definition: Alter Table
14:15 Add Primary Key to a Relation
18:53 Add Foreign Key to a Relation
26:25 Add Constant Unique to an Existing Attribute
28:44 Add an Attribute to an Existing Table
33:34 Modify Datatype of an Attribute
37:04 Modify Constraints of an Attribute
40:30 Add Default Value to an Attribute
43:49 Remove an Attribute
46:42 Add Primary Key from a Table
49:51 Drop Statement
54:41 Practical
1:14:25 Slides
==========================================================
👉Previous Video: https://www.youtube.com/watch?v=VkTn--MJzL4
👉Next Video: https://www.youtube.com/watch?v=UrwralBCZGA
✔️📚👉 Get All Subjects playlists: ​https://www.pabbly.com/out/all-videos-playlist
✔️📚👉 Watch Full Free Course: https://www.magnetbrains.com
✔️📚👉 Get Notes Here: https://www.pabbly.com/out/magnet-brains
✔️📚👉 Student Feedback Form: https://forms.pabbly.com/form/share/eQaF-477327
=======================================================
Why study from Magnet Brains?
Magnet Brains is an online education platform that helps gives You NCERT/CBSE curriculum based free full courses from Kindergarten to Class 12th so that you can perform well in any and all exams you give in your academic career.

👉 Contact us 🤑🤑
➡️ Connect with us : magnetbrainsbhopal@gmail.com
➡️ Website : https://www.magnetbrains.com
➡️ Subscribe to us on YouTube: https://www.youtube.com/channel/UC3HS6gQ79jjn4xHxogw0HiA?sub_confirmation=1
➡️ Subscribe to Magnet Brains Hindi Medium : https://www.youtube.com/channel/UCwO6AYOIRYgyP1KJ5aPbDlw?sub_confirmation=1
➡️ Facebook : https://www.facebook.com/Magnet-Brains-Education-110955641184512
➡️ Instagram : https://www.instagram.com/magnetbrains/
➡️ Telegram : https://t.me/magnetbrainsbhopal .

Disclaimer: "This video is for educational and informational purposes only and is not intended to infringe on any copyrights. If you believe that this video has used any copyrighted material in a way that constitutes copyright infringement, please contact us at contact@magnetbrains.com and we will take appropriate action."



Other Videos By Magnet Brains


2022-01-25Class 12 Students Economics (IED) MCQs Coming Soon - Stay Connected! #Shorts #Magnetbrains
2022-01-25The Ashes that Made Trees Bloom - Summary & MCQs | Honeycomb Class 7 English Unit 4
2022-01-25Class 1 Maths (Math Magic Book) Chapter 2 | Counting - Numbers From One to Nine
2022-01-25The Shed (Poem) - Summary & Multiple Choice Questions | Honeycomb Class 7 English Unit 3
2022-01-25Sarojini Naidu - the First Woman President of the Indian National Congress! #Shorts #Magnetbrains
2022-01-25Class 1 Maths (Math Magic Book) Chapter 2 | As Many As - Numbers From One to Nine
2022-01-25Subhashitani (Bhavarth Lekhan) भावार्थलेखनम् - One Shot Revision | Class 10 Sanskrit Ch 6 (2022-23)
2022-01-25Cash Flow Statement - Illustrations 58 to 60 | Class 12 Accounts Chapter 6 (2022-23)
2022-01-25Class 7 Science Chapter 5 | Acids, Bases and Salts - Multiple Choice Questions (MCQs)
2022-01-25Good Manners for Kids | List of Good Manners | Kindergarten EVS
2022-01-25Class 11 Informatics Practices Ch 8 | SQL for Data Definitions (Alter & Drop Statement)
2022-01-25Numbers and Its Classification (Part 1) | Class 9 & 10 Maths Olympiad (IMO/RMO/INMO/PRMO) 2022-23
2022-01-24Differential Equations - Concepts, Examples & Imp Ques Ex 21.2 | Class 12 Maths RD Sharma 2022-23
2022-01-24First Indian Woman to Hoist Indian Flag in Germany - Madam Bhikaiji Cama! #Shorts #Magnetbrains
2022-01-24Time And Time Again MCQs | Class 12 English Kaleidoscope Poem 7 (15 MCQs Solved) (2022-23)
2022-01-24Class 10 Maths Chapter 10 | Questions Based on Tangent Theorems (Part 5) - Circles 2022-23
2022-01-24Playing With Numbers - Quick Revision/All Concepts (Que 45 - 74)| Class 8 Maths Ch 13 NCERT Exemplar
2022-01-24Class 10 International English Olympiad (IEO) | Homonyms and Homophones (50 MCQs)-Intermediate Level
2022-01-24Class 9 International English Olympiad (IEO) | Homonyms and Homophones (50 MCQs)- Intermediate Level
2022-01-24Princess September - Full Chapter Explanation & Solutions | Class 8 English Ch 5 | It So Happened
2022-01-24Class 12 Sociology Chapter 8 | Social Movements Full Chapter Explanation 2022-23


Tags:
term 2 exam class 11
informatics practices
chapter 8
sql for data definitions
alter & drop statement
sql
create
alter
drop
database
rdbms
sql for beginners
alter command
mysql
sql queries
alter vs update
alter table command in sql
sql basics queries
sql server
alter and update in sql
alter in sql oracle
alter in sql table
alter modify update in sql
basic sql
sql basic queries
sql introduction
mysql commands
cbse class 12 mysql
magnet brains