SQL Server - How to Perform CRUD Operations in SQL Server

in Education2 years ago

Learn How to Perform CRUD Operations in SQL Server. What is SQL Server CRUD operations, this is what we are going to find out in this tutorial. Basically when we create a database we do the operations which makes it easy to add, remove, delete the content from the database.

I decided to create a visual instructional video on this topic. I made the video and posted it on the YouTube. Basically by the end of this video, you are going to see how to use the SQL Server management studio. You would learn pretty simple way. If you have SQL Server Installed, if not then check out SQL Server 2019 Install on Windows.

If you are interested in checking out the Video instructions, you should check out the video.

First step that we do when we create a database in the SQL Server is we create a table. In such case we use the CREATE Query. After creating the table, the next immediate step that we take is adding the data into the table.

Now that we have added the data into the table, we have to think of the INSERT query. This query adds the data into the table - columns and rows. Now after that say you want to update the data into the table, you have to use the UPDATE query. This is pretty cool.

Next step would be using the DELETE query for removing the row and columns. And when you want to display the data to the users, you make use of the SELECT query on the table. Which makes all the data to be displayed on console based on the query parameters.

crud-operation.png

You can visualize the whole queries like the below infographic. It makes things easier for you to view. I personally prefer the below graphic for you to understand the queries easier for the CRUD operations.

This part for the CRUD operation can be done on console, powershell, SQL Server management Studio and also using any other tool. You can also do this using the Driver and language of your choice. This makes it easy to do the interface work.

Like say you have Node.js or the Python language installed on system. And you want to install the driver for the SQL Server and then make use of the driver to interface. And then you can use the CRUD operations on those database. It makes things easier to work with as well.

If you like the content, do keep tab on it through my Youtube Channel and the tutorial. This makes things easier to work with SQL Server if you learn from the simple instructions like I explained in this video and the tutorial. So hopefully you find this post useful.

If you happen to view the content, do give me feedback over there and that would help me improve my efforts in near future.

Sort:  

This is a good beginning to create a SQL server
Good luck! I hope that StemSocial grows a lot!
!1UP

You can earn passive income by delegation of tribe tokens to "The Cartel".

dlmmqb-TheCartel-banner
Click this banner to join "The Cartel" discord server to know more.

1UP-PIZZA.png

You have received a 1UP from @gwajnberg!

The @oneup-cartel will soon upvote you with:
@stem-curator, @cent-curator
And they will bring !PIZZA 🍕.

Learn more about our delegation service to earn daily rewards. Join the Cartel on Discord.

Hi!

If you are interested in checking out the Video instructions, you should check out the video

How can we verify you own that Youtube Channel so you own the video? I couldn't find a backref to your Hive account there.

Do you want me to add the reference link to this account in the Video description?
Does that satisfy your doubt? or is there anything else you think can be done?

Nope. Is the video yours? If that's the case, can you add a note to the video description with a link to this post? That could help verify that you own that video.

Check the video description here for the link to this post. I won't be adding this type of reference for every post I make on hive. I want hive traffic to go to video and not the other way around. I hope you understand.

Check the video description here for the link to this post.

Ok.

I want hive traffic to go to video and not the other way around.

Why not? I'm curious. In that case, you can add a reference to your hive blog in the about section of your channel. Here:

This section is also intended to show your social media, network parts, etc.

Why not? I'm curious. In that case, you can add a reference to your hive blog in the about section of your channel.

I want to use hive as a traffic resource and not a place attached to the content account.
Like I said, traffic from Hive to main YouTube account and not the other way around.
Is there any specific reason you are demanding me to do all this?
Like for what reason you want me to do this? what's your motive behind demanding this?

"Demanding" sounds like strong. Like I said in my comments, it's to verify you own the content. Unfortunately there are many fake hiver accounts, impostors, identity thieves, etc. They plagiarize other's people content. Verification and validation of the sources is usually part of the job of dedicated content curators, like my case. It can also help hivers get better support.

Thanks for your contribution to the STEMsocial community. Feel free to join us on discord to get to know the rest of us!

Please consider delegating to the @stemsocial account (85% of the curation rewards are returned).

You may also include @stemsocial as a beneficiary of the rewards of this post to get a stronger support.