Скачать или смотреть How to Create , Alter, DROP ,USE database | SQL Tutorial | RahulQALabs

DATABASE : (Reference : Oracle.com)
1.A database is an organized collection of structured information, or data, typically stored electronically in a computer system.
2.A database is usually controlled by a database management system (DBMS).
3.Together, the data and the DBMS, along with the applications that are associated with them, are referred to as a database system, often shortened to just database

How to create a Database
========================
This tutotial describes how to create a database in SQL Server by using SQL Server Management Studio

CREATE DATABASE database_name

Name of the database : The maximum length of the database name depends on upon the vendor of the database

Query To check the databses :
-----------------------------
SELECT name, database_id, create_date
FROM sys.databases;

Operations on Database
=====================
ALTER DATABASE : used to modify, maintain, or recover an existing database
Syntax :
alter database database_name modify name =database_name2

DROP DATABASE : The SQL DROP DATABASE statement is used to drop an existing database in SQL schema
Syntax :
DROP DATABASE DatabaseName

USE DatabaseName : select any existing database in the SQL schema
===========================================================
In this video , I have explained operations on database

Sql Server 2019 download link : https://www.microsoft.com/en-us/sql-s...
SSMS download Link:https://docs.microsoft.com/en-us/sql/...
======================================================================================================


-----------------------------------------------------------------------------------------
For any doubts/questions , visit my website and do leave a comment. I will Try to answer ASAP.
Website : https://rahulqalabs.wordpress.com/
-----------------------------------------------------------------------------------------

Vlogging Gears :(affiliate links)

Apple Iphone : https://amzn.to/3lsf608

Digitek Tripod : https://amzn.to/3hQRboM

One Plus Phone : https://amzn.to/2EPuSRN

Main Camera (Sony Cybershot DSC-HX400V) : https://amzn.to/3jqqOXc

---------------------------------------------------------------------------------------------------------------------------
Note : The above link are affiliate links through which I may earn a commission
if the products are purchased.
---------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------

Visit Other Playlists as well :

TestLink tutorial :   • Beginner's Tutorial on TestLink  
MantisBT Tutorial :   • Beginner's Tutorial on Mantis Bug Tracker  
Jira Tutorial :   • Beginner's Tutorial on Jira Tool  
Postman Tutorial :   • Basic Tutorial on POSTMAN  
TestRail Tutorial :   • TestRail Test Management tutorial  
=============================================================================================
==============================================================
Follow Me on FaceBook :   / rahul81087  
My Instagram :   / rahul81088  
Twitter :   / rahulcool81088  
==============================================================
----------------------------------------------------------------------
Follow my Channel on Instagram :  / rahulqalabs  
----------------------------------------------------------------------
Hello Viewers,

I am Rahul.
Welcome To My Channel RAHUL QA LABS.

I create videos in the QA space which may help you all in some way or the other.
It will help you learn new things in testing domain.

Hope you all enjoy the videos.
Always try to Learn,Share and Explore.

Thanks,
Rahul