CampusX Data Science Mentorship Program 2022-23 - Session 31 - SQL DDL Commands | DSMP 2023

Session 30 - Database Fundamentals | DSMP 2022-23 ------------------------------------------------------------------------------------------------------------------------------------------------------- Enroll in this Programme from our Website - https://learnwith.campusx.in/ Course Website Link - https://campusx1040.graphy.com/s/preview/courses/CampusX-Data-Science-Mentorship-Program#6376dbd8e4b065a4cadac4db YouTube Playlist - https://www.youtube.com/playlist?list=PLKnIA16_RmvbAlyx4_rdtR66B7EHX5k3z ------------------------------------------------------------------------------------------------------------------------------------------------------- https://dataschool.com/data-modeling-101/row-vs-column-oriented-databases/ https://www.crio.do/blog/what-is-redis/ ------------------------------------------------------------------------------------------------------------------------------------------------------- Handwritten note used for this season: https://drive.google.com/file/d/146GPq4K7135qOVwggYZ4zjbWhX8J0p8W/view?usp=share_link ----------------------- | 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