MS SQL Basic to Advance Part 4 Update & Delete Hands-On SQL Tutorial

Publié le: 29 décembre 2023
sur la chaîne: Moonir Canopy

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...

Sur cette page du site, vous pouvez voir la vidéo en ligne MS SQL Basic to Advance Part 4 Update & Delete Hands-On SQL Tutorial durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Moonir Canopy 29 décembre 2023, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 28 fois et il a aimé 2 téléspectateurs. Bon visionnage!

1,090