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

Pubblicato il: 29 dicembre 2023
sul canale di: 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...

In questa pagina del sito puoi guardare il video online MS SQL Basic to Advance Part 4 Update & Delete Hands-On SQL Tutorial della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Moonir Canopy 29 dicembre 2023, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 28 volte e gli è piaciuto 2 spettatori. Buona visione!

262