The video owner has disabled playback on external websites.
This video is no longer available on YouTube.
This video cannot be played right now.
Watch on YouTube
ابزارهای یادگیری هوش مصنوعی را باز کنید
ثبتنام کنید تا به ابزارهای قدرتمندی دسترسی پیدا کنید که به شما کمک میکنند سریعتر از هر ویدیو یاد بگیرید.
SQL Basics for Beginners | Learn SQL | SQL Tutorial for Beginners | Edureka
آمار یادگیری
سطح CEFR
سختی
زیرنویسها (718 بخشها)
[Music]
hey guys this is prathi from eureka i
welcome you all to this interesting
session on sql basics but before we get
started let's have a look at the agenda
for today's session so we're gonna begin
with understanding what is sql followed
by that we'll be looking at what is data
and database
next up i shall give a detailed
explanation of a table and finally i'll
end the session by discussing some sql
basic queries such as how to create a
table how to insert data into it how to
delete it and many more
so i hope the agenda is clear but before
moving forward i would like to request
all of you to subscribe to our edureka
youtube channel to never miss out an
update so without any further delay
let's get started
so the first topic i'll be discussing in
today's session is introduction to sql
in today's world data is everything but
to manage it one has to master the art
of data management to play with the data
and database we need to know the
language that is understood by these
databases and that language is sql sql
is a core of relational type databases
because of its huge popularity it is
used by most companies today worldwide
after understanding the basic
introduction the first question that
arises in our mind is what is sql sql is
an abbreviation for structured query
language it is a language used to
perform actions such as update retrieve
manipulate and store data on a
relational database
now that we have learned what exactly
sql is let's see some of its interesting
facts do you know when sql was born well
let me answer that question for you sql
was developed at ibm by donald d
chamberlain and raymond f boyce in the
early 1970s
it was initially called as sql that is
structured english query language but
later it was chained to sql because sql
was a trademark of uk-based engineering
company
sql is said to be a powerful language
reason for that is it uses very simple
english sentences and also uses very few
lines it uses common words such as
select insert update and many more to
perform its core functionalities
sql is known to be a declarative
language when you write a query you have
to describe what needs to be done and
you don't have to worry regarding the
flow of the query it will be handled
internally by the dbms that you're using
now let's look at some of the features
of sql so the first feature is sql has
well-defined standards as it says
developers of sql has clearly mentioned
how exactly each and every query has to
be written there is no room for
ambiguity when it comes to writing a
query the standards has to be followed
sql is easy to learn yes sql is a
language that is used to work with the
database since sql has a large user base
as well as well-defined standards for a
beginner it is really easy to learn
next one is in sql we can create
multiple views this is one of the unique
and early feature that sql came up with
view is nothing but creating a virtual
table a virtual table is a temporary
table for certain use by doing this we
can protect the integrity of the data
sql has the ability to not only create a
single view but can create multiple
views
finally sql queries are portable in
nature it means we can execute the sql
query in one system and execute the same
query in another system without changing
the format but the condition is the
environment setup of these two system
has to be same as the sql query won't be
executed
so these were some of the features of
sql
now let's look at the next topic that is
data and database
firstly let's look at what is data so
the standard definition for a data is
values from differences which has been
translated for some purpose
and this purpose can be anything source
for the data can be like temperature
reading financial data videos blogs text
etc it goes on in the end it should make
a meaningful sense only then we can
consider it as a data
this image clearly depicts a different
source of data so we can clearly
understand that the data source can be
anything
since we are clear about what data is
all about let's head to the next topic
that is what is database
firstly let's look at the formal
definition for a database
a database is an organized collection of
data where the data is stored and
accessed electronically from computer
system to make you understand what it
means let me use an analogy to explain
the concept of database consider a
library usually the library contains a
huge collection of books of different
genre here library is a database and
these books are the data
in the image we can see a person
performing an action on the data and
those action can be like create store
update etc when the user sends the
instruction as well as the data it will
be stored inside the database after
certain process and this entire process
is bi-directional that is control flows
on both the sides
next i am going to talk about different
types of databases there are different
kinds of databases that are in use today
and these databases are classified based
on capabilities features functionality
size and performance so few of them are
distributed database object oriented
زیرنویس کامل در پخشکننده ویدیو موجود است
با تمرینها یاد بگیرید
تمرینهای واژگان، گرامر و درک مطلب از این ویدیو بسازید
نظرات (0)
برای نظر دادن وارد شویدثبتنام کن و همه امکانات رو باز کن
پیشرفتت رو دنبال کن، واژگان رو ذخیره کن و تمرین کن
حالت تعاملی
آزمون
پاسخ صحیح:
ویدیوهای مرتبط
Stanley and Pammy's Lottery Win - Harry Enfield - BBC comedy
Dune (2021) 4K - Paul & Jamis’ Knife Fight | Movieclips
Hank Discovers Gus's Meth Operation | Breaking Bad (Dean Norris)
How to use "WOULD" like a native English speaker
The Rattlin' Bog (Irish Folk Song) Cover
edureka!
آزمون
پاسخ صحیح:
آزمونها هنگام تماشای ویدیو ظاهر میشوند
راهنمای حفظ
از این ویدیو
شروع رایگان یادگیری زبان
