Summary

Summary SQL BEGGGINERS

0 view 0 purchase

Course
SQL

Institution
SQL

What is SQL? SQL stands for Structured Query Language. SQL lets you access and manipulate databases. SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987.

[Show more]

Preview 3 out of 17 pages

View example

Uploaded on February 28, 2023
Number of pages 17
Written in 2022/2023
Type Summary

sql
mysql
queary
select query
database search engine

CA$11.60

Added

Add to cart

Add to wishlist

100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached

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.

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller rjchudasama. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for CA$11.60. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

77254 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling