Skip to main content

SQL : DML Commands



For freshers venturing into the realm of databases, comprehending Data Manipulation Language (DML) commands is akin to unlocking the ability to interact with and transform data within the database. This blog post seeks to provide a beginner-friendly understanding of DML commands, shedding light on their significance and practical applications using MS SQL snippets.

Background: What is DML?

DML (Data Manipulation Language) is a subset of SQL that focuses on the manipulation of data stored in a database. It includes commands for inserting, updating, and deleting data, allowing users to interact with the contents of their databases.

The DML Command Ensemble

INSERT: Introducing New Entries

The INSERT command is akin to adding new entries to a database. Suppose you want to add a new employee to the Employees table
INSERT INTO Employees (FirstName, LastName, Salary)
VALUES ('John', 'Doe', 50000.00);
 

UPDATE: Making Revisions

The UPDATE command allows users to modify existing records. If an employee's salary needs adjustment
UPDATE Employees
SET Salary = 55000.00
WHERE EmployeeID = 1;
 
Real-World Analogy: Editing a Document

Consider the UPDATE command as editing a document; you make changes to specific sections without rewriting the entire content.

DELETE: The Vanishing Act

The DELETE command removes specific records from a table. If an employee leaves the company
DELETE FROM Employees
WHERE EmployeeID = 1;
 

Real-World Analogy: Removing a Page

Imagine the DELETE command as removing a page from a notebook; the information is gone, but the notebook structure remains.

Conclusion

In the vast landscape of database management, DML commands serve as the storytellers, allowing users to not only read but actively shape the narrative of their data. Understanding and wielding these commands empower freshers to navigate and manipulate the intricate threads of information stored within databases.

As you embark on your journey with DML commands, envision them as your tools for crafting and refining the tales your data tells. 

Happy Querying!
Labels:

Comments

Post a Comment

Popular posts from this blog

Implementing and Integrating RabbitMQ in .NET Core Application: Shopping Cart and Order API

RabbitMQ is a robust message broker that enables communication between services in a decoupled, reliable manner. In this guide, we’ll implement RabbitMQ in a .NET Core application to connect two microservices: Shopping Cart API (Producer) and Order API (Consumer). 1. Prerequisites Install RabbitMQ locally or on a server. Default Management UI: http://localhost:15672 Default Credentials: guest/guest Install the RabbitMQ.Client package for .NET: dotnet add package RabbitMQ.Client 2. Architecture Overview Shopping Cart API (Producer): Sends a message when a user places an order. RabbitMQ : Acts as the broker to hold the message. Order API (Consumer): Receives the message and processes the order. 3. RabbitMQ Producer: Shopping Cart API Step 1: Install RabbitMQ.Client Ensure the RabbitMQ client library is installed: dotnet add package RabbitMQ.Client Step 2: Create the Producer Service Add a RabbitMQProducer class to send messages. RabbitMQProducer.cs : using RabbitMQ.Client; usin...
Post a Comment
Read more

.NET 10: Your Ultimate Guide to the Coolest New Features (with Real-World Goodies!)

 Hey .NET warriors! 🤓 Are you ready to explore the latest and greatest features that .NET 10 and C# 14 bring to the table? Whether you're a seasoned developer or just starting out, this guide will show you how .NET 10 makes your apps faster, safer, and more productive — with real-world examples to boot! So grab your coffee ☕️ and let’s dive into the awesome . 💪 1️⃣ JIT Compiler Superpowers — Lightning-Fast Apps .NET 10 is all about speed . The Just-In-Time (JIT) compiler has been turbocharged with: Stack Allocation for Small Arrays 🗂️ Think fewer heap allocations, less garbage collection, and blazing-fast performance . Better Code Layout 🔥 Hot code paths are now smarter, meaning faster method calls and fewer CPU cache misses. 💡 Why you care: Your APIs, desktop apps, and services now respond quicker — giving users a snappy experience . 2️⃣ Say Hello to C# 14 — More Power in Your Syntax .NET 10 ships with C# 14 , and it’s packed with developer goodies: Field-Bac...
2 comments
Read more

Optional Parameters in C# — Writing Flexible and Clean Methods

Hello, .NET developers! 👋 How often have you created multiple method overloads just to handle slightly different cases? Maybe one method accepts two parameters, another three, and one more adds a flag for debugging? That’s a lot of code duplication for something that can be solved beautifully with optional parameters . Optional parameters in C# let you define default values for method arguments. When a caller doesn’t pass a value, the compiler automatically substitutes the default. This feature helps keep your APIs simple, readable, and maintainable. 🎥 Explore more on YouTube : DotNet Full Stack Dev Understanding Optional Parameters Optional parameters are defined by assigning default values in the method signature. When calling the method, you can omit those parameters if you’re okay with the defaults. Example public class Logger { public void Log(string message, string level = "INFO", bool writeToFile = false) ...
Post a Comment
Read more