Lec-49: 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 La nguage. 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.
,Lec-50: 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.
, Lec-51: 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 used so these are the multiple
ways through which you can Thorough Alter command you can perform all these
task So come we will see its implementation Come we will start with
implementation First of all I want to tell you Over here I have written create
table command And we are creating a table over here Employee And I have
added 2 columns Id and Name in it.
Oracle by default works with the name of varchar2 The by default datatype in
this is varcha2 So according to oracle even if you are giving simple varcho ar
Then also it will consider this as vachar2 only. In this way we can add , drop and
modify column datatypes and along with that you can rename So alter table
Tablename Employee. Table or view does not exist. Object to be described Could
not be found which means. nothing exists with the name employee. Table name
What we have changed ? Emp11 So this major , what we can do is With alter
Add , drop , modify , rename column Or rename table. constraints Alter table
tablename.
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 La nguage. 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.
,Lec-50: 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.
, Lec-51: 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 used so these are the multiple
ways through which you can Thorough Alter command you can perform all these
task So come we will see its implementation Come we will start with
implementation First of all I want to tell you Over here I have written create
table command And we are creating a table over here Employee And I have
added 2 columns Id and Name in it.
Oracle by default works with the name of varchar2 The by default datatype in
this is varcha2 So according to oracle even if you are giving simple varcho ar
Then also it will consider this as vachar2 only. In this way we can add , drop and
modify column datatypes and along with that you can rename So alter table
Tablename Employee. Table or view does not exist. Object to be described Could
not be found which means. nothing exists with the name employee. Table name
What we have changed ? Emp11 So this major , what we can do is With alter
Add , drop , modify , rename column Or rename table. constraints Alter table
tablename.
