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...
Nesta página do site você pode assistir ao vídeo on-line MS SQL Basic to Advance Part 4 Update & Delete Hands-On SQL Tutorial duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Moonir Canopy 29 Dezembro 2023, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 28 vezes e gostou 2 espectadores. Boa visualização!
