Introduction to Structured Query Language | points regarding its Features and
Syllabus
Gate Smashers
Gate Smashers is going to discuss Introduction to Introduction to SQL. Along with
the introduction, we will also discuss a little about the history of the SQL and
its syllabus. Because many times the query of students comes that what are the
topics we have to cover inside the sql , Whether it is about higher competitive
exams or placement. IBM converted to this language that is structured query
language and initially called it Simple English Query language. The structure data
we have at today 's time is very less. Only ten percent of the data on this earth
is unstructured , for which we have no sequel. There is no general use of SQL so it
is a particular domain where we use what is that domain ? Relational database ,
that 's why we call it Domain Specific Language. There are two categories -
declarative and procedural. What to do happens and how to do also that means I have
to mention both things inside the program what to do.
We do n't write query in sequel , you have APIs available. We use direct
application program interface and we do query like that particular day , I have to
search any train. I would say that is the most important that is join and nested
query. I will give the most stars to this point here because the students who get
stuck the most get stuck. PL SQL means that the sequel is declarative. In which we
have also added the procedural part in which we create triggers , create
functions , create cursors , we can also create procedures which we do in C
language. But pure SQL tells what to do and how to do it.
All Types of SQL Commands with Example | DDL, DML, DCL, TCL and CONSTRAINTS | DBMS
Gate Smashers
Gate Smashers are going to discuss about types of SQL commands. We use structure
query language to deal with structure data. Structure data means data that we
normally store in the form of tables or relations. When we store the data then I
need some commands to store and language. DDL means data definition so the data we
have to store before storing I need a structure in which I can put that data. Table
means table Whatever these commands are in the table , actually we will see these
commands one by one in detail with explanation that how they works ? and what is
their syntax ? Transactions and controlling transactions in DBMS is a very major
funda in itself , so if we talk about commands , then it is used for our commit ,
commit. commit means if the transaction is completed commit then we will put all
the values in the database. Commit Rollback is acid property which is acid
properties inside the transaction and we have to use them. If the transaction fails
then we rollback , in Actual acid property. If we want to credit money, debit money
or transfer money then what word do we use for all these things ?
KVS talking about any competitive exam then these commands which are in it are more
than enough. If you want to execute then you use the software which is from Oracle.
Oracle Line I 10 G, 11 G , 11 , 11, 12 , 12 , 15 , 16 we have many different
versions or you can use my sequel. You can use sequel server or sequel software. We
get direct name in competitive exams.
ALTER Command (DDL) in SQL with Implementation on ORACLE
Gate Smashers
Varun Singla: In today 's video we are going to discuss About ALTER command As we
had discussed in the last video In DDL the first command about create In which we
had done create table with implementation In this video we will also do its
implementation In Oracle. All we can do with alter command is add column or columns
which means even if you want to add more then 2 columns Then through one command
only Through alter command You can do it simply By adding bracket over here You can
write multiple columns Then remove a column Let 's say that in future we have
requirement That I do n't want this particular column Then what you will do Will
you delete full table No For that proper privileges are required. Alter command is
Syllabus
Gate Smashers
Gate Smashers is going to discuss Introduction to Introduction to SQL. Along with
the introduction, we will also discuss a little about the history of the SQL and
its syllabus. Because many times the query of students comes that what are the
topics we have to cover inside the sql , Whether it is about higher competitive
exams or placement. IBM converted to this language that is structured query
language and initially called it Simple English Query language. The structure data
we have at today 's time is very less. Only ten percent of the data on this earth
is unstructured , for which we have no sequel. There is no general use of SQL so it
is a particular domain where we use what is that domain ? Relational database ,
that 's why we call it Domain Specific Language. There are two categories -
declarative and procedural. What to do happens and how to do also that means I have
to mention both things inside the program what to do.
We do n't write query in sequel , you have APIs available. We use direct
application program interface and we do query like that particular day , I have to
search any train. I would say that is the most important that is join and nested
query. I will give the most stars to this point here because the students who get
stuck the most get stuck. PL SQL means that the sequel is declarative. In which we
have also added the procedural part in which we create triggers , create
functions , create cursors , we can also create procedures which we do in C
language. But pure SQL tells what to do and how to do it.
All Types of SQL Commands with Example | DDL, DML, DCL, TCL and CONSTRAINTS | DBMS
Gate Smashers
Gate Smashers are going to discuss about types of SQL commands. We use structure
query language to deal with structure data. Structure data means data that we
normally store in the form of tables or relations. When we store the data then I
need some commands to store and language. DDL means data definition so the data we
have to store before storing I need a structure in which I can put that data. Table
means table Whatever these commands are in the table , actually we will see these
commands one by one in detail with explanation that how they works ? and what is
their syntax ? Transactions and controlling transactions in DBMS is a very major
funda in itself , so if we talk about commands , then it is used for our commit ,
commit. commit means if the transaction is completed commit then we will put all
the values in the database. Commit Rollback is acid property which is acid
properties inside the transaction and we have to use them. If the transaction fails
then we rollback , in Actual acid property. If we want to credit money, debit money
or transfer money then what word do we use for all these things ?
KVS talking about any competitive exam then these commands which are in it are more
than enough. If you want to execute then you use the software which is from Oracle.
Oracle Line I 10 G, 11 G , 11 , 11, 12 , 12 , 15 , 16 we have many different
versions or you can use my sequel. You can use sequel server or sequel software. We
get direct name in competitive exams.
ALTER Command (DDL) in SQL with Implementation on ORACLE
Gate Smashers
Varun Singla: In today 's video we are going to discuss About ALTER command As we
had discussed in the last video In DDL the first command about create In which we
had done create table with implementation In this video we will also do its
implementation In Oracle. All we can do with alter command is add column or columns
which means even if you want to add more then 2 columns Then through one command
only Through alter command You can do it simply By adding bracket over here You can
write multiple columns Then remove a column Let 's say that in future we have
requirement That I do n't want this particular column Then what you will do Will
you delete full table No For that proper privileges are required. Alter command is
