CampusX Data Science Mentorship Program 2022-23 - Session 32 - SQL DML Commands | DSMP 2023

Session 32 - SQL DML Commands | DSMP 2023 ------------------------------------------------------------------------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------------------------------------------------------------------------- Task 32 link - https://colab.research.google.com/drive/1AESyuQ6Wc3kqoNfavXt9iSWdRlLYXCwP?usp=sharing ------------------------------------------------------------------------------------------------------------------------------------------------------- SQL Operators - https://drive.google.com/file/d/13Cu0VUqbENcUX76bx_aoBS0EAtzDPDrE/view?usp=share_link Dataset Link - https://drive.google.com/drive/folders/1rN2AkOfuJEhroHqRuECshxBKhz0gJBeJ?usp=share_link ------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- | Time stamp | ----------------------- Chapters Session Details 00:00:00 - Session Start 00:03:56 - Summary + Agenda 00:06:38 - doubts clearance 00:07:56 - Summary of CRUD 00:08:38 - MySQL Workbench Info INSERT Query 00:11:07 - INSERT query 00:19:11 - INSERT query variation 00:22:58 - INSERT multiple values 00:25:23 - doubt clearance SELECT Query 00:26:59 - Import data into MySQL Workbench 00:26:20 - SELECT all columns 00:33:16 - filter columns 00:35:55 - alias | renaming columns 00:37:52 - create expression using columns 00:44:50 - doubt clearance 00:45:58 - constant value 00:47:24 - DISTINCT(unique) values from a column 00:50:27 - DISTINCTcombinations 00:52:40 - Filter rows WHERE clause 00:55:04 - Operator Example 1 00:57:22 - Example 2 with BETWEEN operator 00:59:28 - Operator Example 3 01:02:05 - Operator Example 4 01:03:12 - Operator Example 5 01:04:06 - doubt clearance 01:06:29 - Query Execution Order 01:12:53 - Operator Example 6 01:14:42 - IN and NOT IN Operator UPDATE Query 01:18:36 - UPDATE Query to update row(s) 01:24:04 - Update multiple columns DELETE Query 01:25:35 - DELETE Query to delete row(s) 01:27:48 - deletion based on multiple conditions 01:32:14 - doubt clearance Functions in MySQL/SQL 01:34:33 - Info about SQL Functions 01:38:40 - Different aggregate functions 01:39:09 - MAX() & MIN() 01:42:14 - AVG() 01:43:46 - SUM() 01:44:30 - COUNT() 01:46:48 - STD() & VARIANCE() 01:48:11 - Different scalar functions 01:48:24 - ABS() 01:50:05 - ROUND() 01:51:19 - CEIL() & FLOOR() Session End 01:52:56 - Next steps for functions 01:53:37 - Some practice questions 01:54:09 - Next sessions' agenda and doubt clearance #datanalytics #Database #DBMS #SQL #DML