MS SQL Basic to Advance Part 4 Update & Delete Hands-On SQL Tutorial
Welcome to the fourth episode of our 'SQL Mastery' series! In this tutorial, we'll guide you through essential SQL commands for updating, deleting, and maintaining status in your database tables. Follow along as we cover practical examples using the tbl_Department and tbl_Salary tables.
Video Highlights:
Exploring tbl_Department:
Execute SELECT * FROM tbl_Department to view the initial data.
Create a new table dpt using SELECT * INTO dpt FROM tbl_Department.
View the contents of the new table with SELECT * FROM dpt.
Updating Records in dpt:
Use UPDATE dpt SET department_name='New Test' WHERE id=5 to modify a specific record.
Update multiple records with UPDATE dpt SET department_name='No Value' WHERE id=10 OR id=8.
Salary Data Manipulation:
Fetch salary details for employee 141 with SELECT * FROM tbl_Salary WHERE emp_id=141.
Update medical allowance to half of the basic salary with UPDATE tbl_Salary SET medical_allowance=basic_salary/2 WHERE emp_id=141.
Deleting Records from dpt:
Delete a record from the 'dpt' table using DELETE FROM dpt WHERE id=5.
🛠️ Hands-On Learning:
Follow our step-by-step guide to execute these commands in your own SQL environment.
Gain a deeper understanding of SQL data manipulation and table management.
📚 Recommended Resources:
Part 1 • MS SQL Data Model, Primary Key Foreign Key...
Part 2 • MS SQL Basic to Advance Part 2: Advanced S...
Part 3 • MS SQL Basic to Advance Part 3 Insertion t...
En esta página del sitio puede ver el video en línea MS SQL Basic to Advance Part 4 Update & Delete Hands-On SQL Tutorial de Duración hora minuto segunda en buena calidad , que subió el usuario Moonir Canopy 29 diciembre 2023, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 28 veces y le gustó 2 a los espectadores. Disfruta viendo!
