Session 31 - SQL DDL Commands | DSMP 2023

Session 30 - Database Fundamentals | DSMP 2022-23
-------------------------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------------------------

-----------------------
| Time stamp |
-----------------------
0:00 Start
3:58 Session start
5:06 Software Installation
7:15 Database server
9:10 SQL start
10:42 Types of SQL Commands
14:10 Doubts
15:46 DDL Commands For database - Create and Drop
20:22 DDL Commands for Table
21:14 Create Table
25:05 Truncate Table
28:06 Drop table
30:02 Data Integrity
34:35 Constraints
43:19 NOT NULL - Constraints
46:35 Unique - Constraints
50:13 Another way of making constraints
56:00 Primary Key - Constraints
01:01:14 AUTO Increment - Constraints
1:04:00 Doubts
1:06:35 Check - Constraints
1:10:11 Defaults
1:17:07 Foreign Key
1:23:28 Referential Actions
1:27:23 Cascade
1:37:37 Doubts
1:38:38 Alter Table command
1:46:20 Adding and deleting - Constraints
1:54:00 Remaining Topics - and Doubts

#datanalytics #Database #DBMS #SQL #DDL

[akshita]

Sir at 1:34:07 I think the error is because we have put NOT NULL constraint on cid column, so we can't use SET NULL referential action on it.

[vinayshukla]

This is the best Youtube channel to learn Data Science in Hindi because most of the channel's content is available in English. And sometimes it's hard to understand some concepts in English.

[SumanPokhrel]

Thank you for this amazing tutorial and the overall series too. WIll always be grateful for this.

[yadavajay]

for checking constraint the quries is
SHOW CREATE TABLE tablename;

[ShaMiiiKhaliq]

Sir how to Select top 50% rows in mySql or any 50% rows top or bottom??

[MonkeyDLuffy]

Great video, just a suggestion, can you decrease the size of your webcam screen in the overall video?

[indianengineer]

Sir your face-camera is sometimes blocking content on screen. Please fix it.

[gauravpaithane]

able to modify constraints using

ALTER TABLE dummy
ADD CONSTRAINT new UNIQUE(age);

[learningsinlife]

@campusx can we get sql scripts for the coding we see in video

[Snr]

in mysql how to retrieve customer name through foreign key?

[surajhadole]

Select command comes under DQL not in DML, I think

[AnshulParmar]

Sir is session ke notes ni hn available. Can you please share

[tanmayshinde]

how can DROP is DDL command It should come under DML as well as UPDATE should come under DDL

[Noob]

sir regluar exapression ka session ho gaya kya nahi to please karva do kisi extra session mai

[kratikaagarwal]

Sir at 55:31 you said ki poora data delete krna pdega agr constraint htaana hai, toh yeah toh hum code mein jaakr vahan se unique constraint ko code se remove krke bhi kr skte hein toh yeah toh koi benefit nhi hua

[roushanmondal]

time stamps galat hai....infact previous class ke time stamps diya hua hai

[wakeart]

What is the full course fee for certificate can someone tell me

[karankeshav]

Database such a big topic and in pwskills they completed just in one single video of 39min😢

[Snr]

used this syntax to find the constraint names in the db please cross check
SELECT DISTINCT(constraint_name)
FROM
WHERE constraint_schema = 'campusx'
ORDER BY constraint_name ASC;