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
On this page of the site you can watch the video online How to Create , Alter, DROP ,USE database | SQL Tutorial | RahulQALabs with a duration of hours minute second in good quality, which was uploaded by the user Rahul QA Labs 18 July 2022, share the link with friends and acquaintances, this video has already been watched 1,499 times on youtube and it was liked by 68 viewers. Enjoy your viewing!
