database management

Hello guys in this tutorial , we will learn the first step of using sql server. We will see how we can create database and perform crud operation using sql queries.

Setting up database on plesk server

Database Backup .bak

Hello guys, sometimes while working with sql server we often create tables with wrong columns names and we often need to rename those columns. So we will see how to rename table column in sql server.

Hello guys, sometimes while working with big databases in sql server we often need to find all tables where we have used specific columns. So we will see how to do that.

The GROUP_CONCAT() function was built specifically for the purpose of concatenating a query’s result set into a list separated by either a comma or a delimiter of your choice.