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
Nesta página do site você pode assistir ao vídeo on-line How to Create , Alter, DROP ,USE database | SQL Tutorial | RahulQALabs duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Rahul QA Labs 18 Julho 2022, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 1,475 vezes e gostou 68 espectadores. Boa visualização!
