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...
Auf dieser Seite können Sie das Online-Video MS SQL Basic to Advance Part 4 Update & Delete Hands-On SQL Tutorial mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Moonir Canopy 29 Dezember 2023 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 28 Mal angesehen und es wurde von 2 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
