Database Management Exam > Database Management Videos > Microsoft SQL for Beginners > SQL Tutorial - 5: Create; Use and Drop Databases
SQL Tutorial - 5: Create; Use and Drop Databases Video Lecture | Microsoft SQL for Beginners - Database Management
FAQs on SQL Tutorial - 5: Create; Use and Drop Databases Video Lecture - Microsoft SQL for Beginners - Database Management
| 1. How do I create a database in SQL? |  |
Ans. To create a database in SQL, you can use the "CREATE DATABASE" statement followed by the desired database name. For example, to create a database named "mydatabase", you would use the following SQL query:
CREATE DATABASE mydatabase;
This will create a new database with the specified name.
| 2. How do I use a database in SQL? | |
Ans. To use a database in SQL, you need to use the "USE" statement followed by the name of the database you want to use. For example, to use the "mydatabase" database, you would use the following SQL query:
USE mydatabase;
This will switch the current database to the one specified, allowing you to perform operations and queries on that database.
| 3. How can I drop a database in SQL? | |
Ans. To drop a database in SQL, you can use the "DROP DATABASE" statement followed by the name of the database you want to drop. However, it is important to note that dropping a database will permanently delete all its data and cannot be undone. Here is an example of dropping a database named "mydatabase":
DROP DATABASE mydatabase;
Make sure to exercise caution when using this command, as it can lead to irreversible data loss.
| 4. Can I create multiple databases in SQL? | |
Ans. Yes, you can create multiple databases in SQL. Each database will have its own set of tables, views, and other database objects. You can create multiple databases by using the "CREATE DATABASE" statement followed by different names for each database. For example:
CREATE DATABASE database1;
CREATE DATABASE database2;
CREATE DATABASE database3;
This will create three separate databases named "database1", "database2", and "database3".
| 5. Is it possible to change the current database in SQL without using the "USE" statement? | |
Ans. Yes, it is possible to change the current database in SQL without using the "USE" statement. You can specify the database name directly in your queries by using the "database_name.table_name" syntax. For example, instead of using "USE mydatabase" and then querying a table called "mytable", you can directly specify the database name in your query like this:
SELECT * FROM mydatabase.mytable;
This will retrieve data from the "mytable" table in the "mydatabase" database without explicitly switching the current database. However, using the "USE" statement is generally recommended for better clarity and readability of your SQL code.
Text Transcript from Video
hello guys welcome to my channel this is
the fifth tutorial in this course and in
this tutorial we are going to talk about
three very important and simple SQL
commands we're gonna learn how to create
a database and how to use it and also
how to drop it or remove it from our
list of databases if you know not
required so anyway you can see that I
have the MySQL workbench software opened
up and I have connected to the server
right by typing in my password and
that's why I have the screen and over
here as I said in the text editor
program sorry in the text editor region
we type in our SQL queries so the first
command we gonna learn to type is the
create database command right and to do
that you have to type in create that's
the word create CR EA te and then give a
space and then type in the keyword
database or the word database and and
the reason why I call these words as
keywords is because these words have got
special meaning to SQL write so create
has some significance for SQL and you
cannot use it as a name for your table
right so you type in create database and
then you give a space and then you type
in name for your database and that could
be anything right so I'm gonna call my
database sample and at the end of this
command I'm going to put a semicolon
right so that's to terminate the
statement and then I press the key
combination ctrl + Enter so when I do
that I see that in the output section I
get the message
create database sample this command has
been executed successfully and that's
because I see this green check box right
and if I want to see this database
sample in my object browser then you can
see that there's this refresh button and
when I click on it I see that the sample
database is now displayed in the list of
databases in the object browser right
the next thing that we're going to learn
to do is to use this database and the
command for that is you type in use the
keyword use and then you give a space
and then you type in the name of your
database which is sample right so in
order to put tables in this
so in order to do anything with this
database you have to first use it right
so when you create a database that
doesn't mean that you can you know just
start using you have to execute this
command as well right so again you type
and use give a space type in the name of
your database which is sample and I put
a semicolon at the end and again press
control enter to execute this query and
again you can see that in the output
section I get a green check mark one
small and it tells me a time at which
the square was executed it tells me you
know how many rows is it affected so it
didn't really affect you know any rows
but you know now we are in a position to
use the sample database so the next
thing that we're gonna learn to do is
draw up this database you know if you're
not interested in having sample around
anymore then you can drop it and to do
that you have to type in the keyword
drop and then you have to type in the
keyword database and then you have to
type in the name of the database that
you wish to drop and which in this case
is sample right I type in these three
things and when I put in a semicolon
press the Enter key I see that I get a
check mark again a green one and it
tells me that a drop database sample
query was executed and if I would press
the sorry click on the Refresh icon
again in the object browser then I would
see that my sample database would
disappear because we've dropped it so it
no longer has to be displayed in the
list here right so these are very simple
basic commands but the create keyword in
itself has got a lot of functionality
and we use it to create views we use it
to create tables and loads of other
things and so is drop you know drop is
also pretty powerful so anyway I want
you to notice one thing that the
keywords that you type in you know the
ones that have special meaning
associated you know the ones to which
SQL associate special meaning those
keywords are displayed in blue color and
the identifiers that you type in like
for instance sample here the name
my database does not have any you know
special special meaning to SQL so that's
why it was displayed in black right and
also just to make sure that the commands
are readable I'm going to try to you
know type in all the SQL keywords in
capital letters and you know this is
this is recommended people suggest that
you should do this it's it's a it's a
practice among programmers some people
do not follow it you know that can
sometimes be a little difficult to
understand because you won't always get
SQL code you know that you can access
using you know such fancy we do
sometimes you would have to you know use
text editors like you know notepad to
view SQL files so in that case it's it's
really you know helpful if you can
distinguish between your SQL keywords in
your identifiers you know when you have
your keywords and capital letters when
you have your identifiers in small case
so anyway thank you so much for watching
this tutorial I'm going to see you in
the next one in which we'll discuss
something interesting again and please
subscribe much are in case you have
already and as usual
the fifth tutorial in this course and in
this tutorial we are going to talk about
three very important and simple SQL
commands we're gonna learn how to create
a database and how to use it and also
how to drop it or remove it from our
list of databases if you know not
required so anyway you can see that I
have the MySQL workbench software opened
up and I have connected to the server
right by typing in my password and
that's why I have the screen and over
here as I said in the text editor
program sorry in the text editor region
we type in our SQL queries so the first
command we gonna learn to type is the
create database command right and to do
that you have to type in create that's
the word create CR EA te and then give a
space and then type in the keyword
database or the word database and and
the reason why I call these words as
keywords is because these words have got
special meaning to SQL write so create
has some significance for SQL and you
cannot use it as a name for your table
right so you type in create database and
then you give a space and then you type
in name for your database and that could
be anything right so I'm gonna call my
database sample and at the end of this
command I'm going to put a semicolon
right so that's to terminate the
statement and then I press the key
combination ctrl + Enter so when I do
that I see that in the output section I
get the message
create database sample this command has
been executed successfully and that's
because I see this green check box right
and if I want to see this database
sample in my object browser then you can
see that there's this refresh button and
when I click on it I see that the sample
database is now displayed in the list of
databases in the object browser right
the next thing that we're going to learn
to do is to use this database and the
command for that is you type in use the
keyword use and then you give a space
and then you type in the name of your
database which is sample right so in
order to put tables in this
so in order to do anything with this
database you have to first use it right
so when you create a database that
doesn't mean that you can you know just
start using you have to execute this
command as well right so again you type
and use give a space type in the name of
your database which is sample and I put
a semicolon at the end and again press
control enter to execute this query and
again you can see that in the output
section I get a green check mark one
small and it tells me a time at which
the square was executed it tells me you
know how many rows is it affected so it
didn't really affect you know any rows
but you know now we are in a position to
use the sample database so the next
thing that we're gonna learn to do is
draw up this database you know if you're
not interested in having sample around
anymore then you can drop it and to do
that you have to type in the keyword
drop and then you have to type in the
keyword database and then you have to
type in the name of the database that
you wish to drop and which in this case
is sample right I type in these three
things and when I put in a semicolon
press the Enter key I see that I get a
check mark again a green one and it
tells me that a drop database sample
query was executed and if I would press
the sorry click on the Refresh icon
again in the object browser then I would
see that my sample database would
disappear because we've dropped it so it
no longer has to be displayed in the
list here right so these are very simple
basic commands but the create keyword in
itself has got a lot of functionality
and we use it to create views we use it
to create tables and loads of other
things and so is drop you know drop is
also pretty powerful so anyway I want
you to notice one thing that the
keywords that you type in you know the
ones that have special meaning
associated you know the ones to which
SQL associate special meaning those
keywords are displayed in blue color and
the identifiers that you type in like
for instance sample here the name
my database does not have any you know
special special meaning to SQL so that's
why it was displayed in black right and
also just to make sure that the commands
are readable I'm going to try to you
know type in all the SQL keywords in
capital letters and you know this is
this is recommended people suggest that
you should do this it's it's a it's a
practice among programmers some people
do not follow it you know that can
sometimes be a little difficult to
understand because you won't always get
SQL code you know that you can access
using you know such fancy we do
sometimes you would have to you know use
text editors like you know notepad to
view SQL files so in that case it's it's
really you know helpful if you can
distinguish between your SQL keywords in
your identifiers you know when you have
your keywords and capital letters when
you have your identifiers in small case
so anyway thank you so much for watching
this tutorial I'm going to see you in
the next one in which we'll discuss
something interesting again and please
subscribe much are in case you have
already and as usual
Related Exams
About this Video
|
4.95/5 Rating |
|
Nov 24, 2024 Last updated |
Video Description: SQL Tutorial - 5: Create; Use and Drop Databases for Database Management 2024 is part of Microsoft SQL for Beginners preparation.
The notes and questions for SQL Tutorial - 5: Create; Use and Drop Databases have been prepared according to the Database Management exam syllabus.
Information about SQL Tutorial - 5: Create; Use and Drop Databases covers all important topics for Database Management 2024 Exam.
Find important definitions, questions, notes, meanings, examples, exercises and tests below for SQL Tutorial - 5: Create; Use and Drop Databases.
Introduction of SQL Tutorial - 5: Create; Use and Drop Databases in English is available as part of our Microsoft SQL for Beginners for Database Management & SQL Tutorial - 5: Create; Use and Drop Databases in
Hindi for Microsoft SQL for Beginners course. Download more important topics related with notes, lectures and mock test series for
Database Management Exam by signing up for free.
Description
Video Lecture & Questions for SQL Tutorial - 5: Create; Use and Drop Databases Video Lecture | Microsoft SQL for Beginners - Database Management - Database Management full syllabus preparation | Free video for Database Management exam to prepare for Microsoft SQL for Beginners.
Information about SQL Tutorial - 5: Create; Use and Drop Databases
Here you can find the meaning of SQL Tutorial - 5: Create; Use and Drop Databases defined & explained in the simplest way possible.
Besides explaining types of SQL Tutorial - 5: Create; Use and Drop Databases theory, EduRev gives you an ample number of questions to practice SQL Tutorial - 5: Create; Use and Drop Databases tests,
examples and also practice Database Management tests.
|
Explore Courses for Database Management exam
|
|
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
Related Searches
shortcuts and tricks
,MCQs
,Free
,Semester Notes
,SQL Tutorial - 5: Create; Use and Drop Databases Video Lecture | Microsoft SQL for Beginners - Database Management
,Extra Questions
,Viva Questions
,SQL Tutorial - 5: Create; Use and Drop Databases Video Lecture | Microsoft SQL for Beginners - Database Management
,ppt
,study material
,Objective type Questions
,mock tests for examination
,video lectures
,past year papers
,SQL Tutorial - 5: Create; Use and Drop Databases Video Lecture | Microsoft SQL for Beginners - Database Management
,Summary
,Important questions
,Exam
,Sample Paper
,practice quizzes
,Previous Year Questions with Solutions
;
Study SQL Tutorial - 5: Create; Use and Drop Databases on the App
Students of Database Management can study SQL Tutorial - 5: Create; Use and Drop Databases alongwith tests & analysis from the EduRev app,
which will help them while preparing for their exam. Apart from the SQL Tutorial - 5: Create; Use and Drop Databases,
students can also utilize the EduRev App for other study materials such as previous year question papers, syllabus, important questions, etc.
The EduRev App will make your learning easier as you can access it from anywhere you want.
The content of SQL Tutorial - 5: Create; Use and Drop Databases is prepared as per the latest Database Management syllabus.
|
© EduRev
|
Education Revolution
|
Follow Us
|
Signup to see your scores
go up within 7 days!
Access 1000+ FREE Docs, Videos and Tests
Takes less than 10 seconds to signup