How to Create , Alter, DROP ,USE database | SQL Tutorial | RahulQALabs

Publicado el: 18 julio 2022
en el canal de: Rahul QA Labs

1,475

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

En esta página del sitio puede ver el video en línea How to Create , Alter, DROP ,USE database | SQL Tutorial | RahulQALabs de Duración hora minuto segunda en buena calidad , que subió el usuario Rahul QA Labs 18 julio 2022, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 1,475 veces y le gustó 68 a los espectadores. Disfruta viendo!

14,740

135