SQL Server: Create, Alter & Drop Database (Hindi) | Part 4

Learn SQL Server : Zero to Hero (Hindi) | Complete Course - Part 4: Create, Alter & Drop Databases

Welcome to Part 4 of the SQL Server Tutorial Series in Hindi by ASH-TECH MANTRA!

In this video, we dive into DDL (Data Definition Language) commands specifically for Databases. You will learn the complete lifecycle of a database in SQL Server Management Studio (SSMS)—how to create it, how to modify it, and how to delete it safely.

We cover both the GUI (Graphic User Interface) method and the T-SQL Query method, which is essential for SQL Interviews.

🔥 TOPICS COVERED IN THIS VIDEO:
--------------------------------
1. How to CREATE a Database (GUI & Script)
2. How to ALTER a Database (Renaming & Modifying)
3. How to DROP (Delete) a Database properly
4. Important SQL Interview Questions related to Database management

📌 TIMESTAMPS:
00:00 Introduction & Session Agenda
01:50 How to Create Database (GUI Method)
03:30 Verify New Database Files (MDF/LDF)
05:40 Create Database using T-SQL Query
10:30 Alter Database (Rename & Modify Size)
13:00 Drop Database Command
13:40 Fixing "Database Currently in Use" Error (Important!)
16:30 Summary & Next Steps

📺 WATCH THE PREVIOUS PARTS:
Part 1: Introduction -    • Learn SQL Server: Zero to Hero (Hindi) | C...  
Part 2: Basics -    • Learn SQL Server: Zero to Hero (Hindi) | C...  
Part 3: System Databases -    • Learn SQL Server: Zero to Hero (Hindi) | C...  

****************************************************
Practice Set- Query ( Please copy-paste below queries on SSMS and execute it as per my video guidelines and Create, Alter and Drop database with me, and comment me for further information or any issue/error.
****************************************************

#sql create database | #sql | #sqlschool | #sqlserver | #sqlforbeginners
sql server, sql server tutorial, sql server in hindi, create database sql server, drop database sql server, alter database sql server, sql server management studio, how to create database in sql server, learn sql server, sql server basics, sql tutorial for beginners, database management, sql server course, ssms, ash-tech mantra
Create Database AshTechDB
select * from sys.databases where name ='AshTechDB'

Select Name as LogicalName, Physical_name as PhysicalPath, Type_desc as FileType
from sys.master_files where name ='AshTechDB_log' or name ='AshTechDB'

-- Rename --01
Exec sp_renamedb 'AshTechDB' , 'AshTechDB_Dev'

-- Rename --02
Alter Database AshTechDB_GUI modify name =AshTechDB_GUI_Dev

Use AshTechDB_Dev
-- Drop database
Drop database AshTechDB_Dev

Use Master
select * from sys.databases where name='AshTechDB_Dev'
Drop database AshTechDB_Dev
select * from sys.databases where name='AshTechDB_Dev'

****************************************************************************************************



#SQLServer #SQLHindi #CreateDatabase #AshTechMantra #SQLForBeginners #DDLCommands
#SQLInterview #LearnSQL #sql